(A) Is DDL Command
(B) Resets identity of the table
(C) Cannot activate a trigger
(D) Can be Rolled back
Tag: DBMS Mcqs
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
What kind of mechanism is to be taken into account for converting a weak entity set into strong entity set in entity relationship diagram?
(A) Aggregation
(B) Generalization
(C) Specialization
(D) Adding suitable attributes
For a weak entity set to be meaningful it must be associated with another entity set in combination with some of their attribute values is called as?
(A) Owner entity set
(B) Strong entity set
(C) Neighbour set
(D) Weak set