(A) Is DDL Command
(B) Resets identity of the table
(C) Cannot activate a trigger
(D) Can be Rolled back
Category: Database Mcqs
Database Mcqs for Screening tests, Interviews, Viva and Other competitive exams. Database Mcqs section will help users to prepare mcqs of Database for various exams. Aspirants of Lecturer Computer Science, SST Computer Science, Subject Specialist Computer Science, Data Entry operator, Computer Programmer, Computer Operator, System administrator, Database Administrator and all other Exams can prepare their Database portion from here.
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