MGRADES EXAMS
Database gmetrix UPDATED ACTUAL
Exam Questions and CORRECT Answers
Incorrect syntax - CORRECT ANSWER - SELECT * FROM cambridge WHERE id
BETWEEN (1, 5)
DROP LOGIN - CORRECT ANSWER - removes an SQL server login account
What does SELECT DATEADD(DD, 0, DATEDIFF(DD, 0, GETDATE())) do? - CORRECT
ANSWER - The statement will return just the date part of the current system date,
removing the time part of the output
What determines a database in the third normal form? - CORRECT ANSWER - Every
non-prime attribute in the table is non-transitively dependent on every candidate key in the table
A trigger - CORRECT ANSWER - initiates an action when an event (INSERT, UPDATE,
DELETE) occurs
What does the INSERT statement do? - CORRECT ANSWER - Add rows
The DELETE statement removes records in a table - CORRECT ANSWER - TRUE
REMOVE marks the contents of a table for reallocation - CORRECT ANSWER - FALSE
TRUNCATE TABLE removes all data from a table - CORRECT ANSWER - TRUE
1NF - CORRECT ANSWER - no repeating groups
Database gmetrix UPDATED ACTUAL
Exam Questions and CORRECT Answers
Incorrect syntax - CORRECT ANSWER - SELECT * FROM cambridge WHERE id
BETWEEN (1, 5)
DROP LOGIN - CORRECT ANSWER - removes an SQL server login account
What does SELECT DATEADD(DD, 0, DATEDIFF(DD, 0, GETDATE())) do? - CORRECT
ANSWER - The statement will return just the date part of the current system date,
removing the time part of the output
What determines a database in the third normal form? - CORRECT ANSWER - Every
non-prime attribute in the table is non-transitively dependent on every candidate key in the table
A trigger - CORRECT ANSWER - initiates an action when an event (INSERT, UPDATE,
DELETE) occurs
What does the INSERT statement do? - CORRECT ANSWER - Add rows
The DELETE statement removes records in a table - CORRECT ANSWER - TRUE
REMOVE marks the contents of a table for reallocation - CORRECT ANSWER - FALSE
TRUNCATE TABLE removes all data from a table - CORRECT ANSWER - TRUE
1NF - CORRECT ANSWER - no repeating groups
