DATABASE GMETRIX TEST QUESTIONS AND VERIFIED ANSWERS

DATABASE GMETRIX TEST QUESTIONS
AND VERIFIED ANSWERS



ANSWER SELECT * FROM Cambridge WHERE id BETWEEN (1, 5) is
incorrect.

An SQL Server login account is deleted by using the DROP LOGIN command.


SELECT DATEADD(DD, 0, DATEDIFF(DD, 0, GETDATE()): What are they
used for? ANSWER The statement will eliminate the output's time component
and only return the date portion of the current system date.

What distinguishes a third-normal database? ANSWER Each non-prime
attribute in the table does not depend transitively on each of the table's
candidate keys.

When an event (INSERT, UPDATE, DELETE) occurs, ANSWER acts as a
trigger.

What is the purpose of the INSERT statement? ANSWER: Add rows

A table's records are deleted using the DELETE statement. ANSWER TRUE

REMOVE designates a table's contents for reallocation. - FALSE ANSWER

ANSWER TRUE: TRUNCATE TABLE eliminates all data from a table.

1NF: NO repeated groups in the answer

2NF-ANSWER No non-prime attribute in the table depends on a suitable subset
of the candidate key in order to function.