(A) 08
(B) 32
(C) 48
(D) 64
Author:
Which of the following will be deleted relating to a table if you use TRUNCATE command?
(A) Indexes
(B) All rows in a table
(C) Constraints
(D) Table structure and its columns
Which of the following is true about DELETE command?
(A) Is DDL Command
(B) Resets identity of the table
(C) Cannot activate a trigger
(D) Can be Rolled back
How many clustered index(es) do each database table have?
(A) 1
(B) 2
(C) 3
(D) 5
Which of the following statements are Data Definition Language commands?
(A) UPDATE
(B) GRANT
(C) INSERT
(D) TRUNCATE
Which key word is available in SQL to enforce referential integrity?
(A) Check
(B) Primary Key
(C) Unique
(D) Set Default
Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of?
(A) Concurrency Control
(B) Physical Data Independence
(C) Logical Data Independence
(D) Functional Dependency
In ER model Y is the dominant entity and X is subordinate entity?
(A) If X is deleted, then Y is also deleted
(B) If Y is deleted, then X is also deleted
(C) If Y is deleted, then X is not deleted
(D) All of the above