Dive into practice questions
Question 1
Which of the following qualifiers removes duplicate records from a SQL SELECT statement when included in a query?
A. UNIQUE
B. SINGLE
C. DISTINCT
D. TOP 1
Question 2
Which of the following ORM tools enables developers to work with a database using .NET objects?
A. Ebean
B. Entity Framework
C. Eclipse
D. Hibernate
Question 3
Which of the following best describes the policy and/or procedure that ensures records are kept in a database for a period of time and not deleted?
A. Data classification policy
B. Standard operating procedure
C. Data retention policy
D. Global regulation
Question 4
Several users received a message from the Chief Executive Officer asking them for their bank account details. Which of the following types of attacks is taking place?
A. Denial of service
B. Brute-force
C. Phishing
D. Malware
Question 5
A company's backup plan includes only running full backups for its small database. Which of the following frequencies would be most appropriate in this situation?
A. Daily
B. Monthly
C. Weekly
D. Quarterly
Answer key
Question 1: C (DISTINCT)