SQL MCQ - Data Definition Language

11. What options did ALTER DATABASE statement add?

A. DATABASE SNAPSHOT syntax
B. ATTACH_REBUILD_LOG clause
C. DB_CHAINING option
D. READ_COMMITTED_SNAPSHOT

View Answer


12. In SQL, which of the following is not a data definition language commands?

A. RENAME
B. REVOKE
C. GRANT
D. UPDATE

View Answer


13. Which command allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained:

A. TRUNCATE command
B. Create command
C. Drop table command
D. Alter table command

View Answer


14. Point out the correct statement.

A. When a database is dropped, the master database should be backed up
B. You can drop a database currently being used
C. Dropping a database snapshot does not delete the database snapshot from an instance of SQL Server
D. None of the mentioned

View Answer


15. All tuples in the relation are assigned null as the value for the new attribute, in the

A. Alter Command
B. Select Command
C. Delete Command
D. Create Command

View Answer


16. Which requirements can be implemented using a CHECK constraint?

A. Customer must have a name
B. Two customers cannot have same email id
C. Both A and B
D. None of the above

View Answer


17. Which statement is TRUE regarding ALTER statement?

A. ALTER TABLE cannot be used to remove a column
B. ALTER table can be used to change size of data type, not the data type itself
C. ALTER table can be used to add a column but it must be NOT NULL
D. None of the above

View Answer


18. Point out the correct statement.

A. When a database is dropped, the master database should be backed up
B. You can drop a database currently being used
C. Dropping a database snapshot does not delete the database snapshot from an instance of SQL Server
D. None of the mentioned

View Answer


19. All tuples in the relation are assigned null as the value for the new attribute, in the

A. Modify command
B. Tailor command
C. Eliminate command
D. Alter command

View Answer


20.  To delete a particular column in a relation the command used is:

A. UPDATE TABLE
B. TRUNCATE COLUMN
C. ALTER , DROP
D. DELETE COLUMN

View Answer






Also check :


Discussion


* You must be logged in to add comment.