Q1. What are the different events in triggers?
(A) Define, Create
(B) Drop, Comment
(C) Insert, Update, Delete
(D) All of the mentioned

Q2. Trigger are supported in
(A) Delete
(B) Update
(C) Views
(D) All of these

Q3. Trigger are supported in
(A) Delete
(B) Update
(C) Views
(D) All of the above

Q4. A command to remove a relation from an SQL database
(A) Delete table table_name
(B) Drop table table_name
(C) Alter table table_name
(D) Erase table table_name

Q5. Which of the following describes “Is-a-Relationship”?
(A) Dependency
(B) Aggregation
(C) Inheritance
(D) None of these

Q6. The total participation by entities is represented in E-R diagram as
(A) Double line
(B) Dashed line
(C) Double rectangle
(D) Circle

Q7. Tables in second normal form
(A) Eliminate all hidden dependencies
(B) Eliminate the possibility of a insertion anomalies
(C) Have a composite key
(D) None of these

Q8. In E-R diagram generalization is represented by
(A) Ellipse
(B) Rectangle
(C) Triangle
(D) Dashed ellipse

Q9. Data integrity constraints are used to:
(A) Ensure that duplicate records are not entered into the table
(B) Control who is allowed access to the data
(C) Improve the quality of data entered for a specific property
(D) None of these

Q10. A relation is in which normal form if an attribute of a composite key is dependent on an attribute of other composite key.
(A) First Normal Form
(B) Second Normal Form
(C) Third Normal Form
(D) Second or Third Formal Form

Related Multiple choice questions:
computer hardware objective questions and answers part1
computer hardware objective questions and answers part2
computer hardware objective questions and answers part3
computer hardware objective questions and answers part4
computer hardware objective questions and answers part5

computer networking objective questions and answers part1
computer networking objective questions and answers part2
computer networking objective questions and answers part3
computer networking objective questions and answers part4
computer networking objective questions and answers part5

computer programming objective questions and answers part1
computer programming objective questions and answers part2
computer programming objective questions and answers part3
computer programming objective questions and answers part4
computer programming objective questions and answers part5

basics of computer science objective questions and answers part1
basics of computer science objective questions and answers part2
basics of computer science objective questions and answers part3
basics of computer science objective questions and answers part4
basics of computer science objective questions and answers part5
basics of computer science objective questions and answers part6
basics of computer science objective questions and answers part7
basics of computer science objective questions and answers part8
basics of computer science objective questions and answers part9
basics of computer science objective questions and answers part10
basics of computer science objective questions and answers part11
basics of computer science objective questions and answers part12
basics of computer science objective questions and answers part13
basics of computer science objective questions and answers part14
basics of computer science objective questions and answers part15
basics of computer science objective questions and answers part16
basics of computer science objective questions and answers part17

Database management system multiple choice questions and answers part1
Database management system multiple choice questions and answers part2
Database management system multiple choice questions and answers part3
Database management system multiple choice questions and answers part4
Database management system multiple choice questions and answers part5

Operating system multiple choice questions and answers part1
Operating system multiple choice questions and answers part2
Operating system multiple choice questions and answers part3

MS Office multiple choice questions and answers part1
MS Office multiple choice questions and answers part2
MS Office multiple choice questions and answers part3
MS Office multiple choice questions and answers part4
MS Office multiple choice questions and answers part5

More Multiple choice questions:
Computer Science multiple choice questions and answers
Computer Science multiple choice questions and answers
Computer Science multiple choice questions and answers