DBMS Questions – Set 6
1. ODBC is based on ________
(A) C++ language
(B) RDBMS
(C) Structured Query Language
(D) C language
Answer
(C)
2. In oracle, which tablespace is the minimum required when creating a database?
(A) System tablespace
(B) Undo tablespace
(C) temporary tablespace
(D) None of the above
Answer
(A)
3. Which of the following is another name for weak entity?
(A) Dominant
(B) Child
(C) Owner
(D) None of the above
Answer
(B)
4.Which model remains operative until the software is required?
(A) Waterfall model
(B) Incremental model
(C) Prototyping model
(D) Spiral model
Answer
(D)
5. A top to bottom relationship among the items in a database is established by a ______
(A) Network Schema
(B) Relational Schema
(C) Hierarchical Schema
(D) None of the above
Answer
(C)
6. Aggregation is a special form of _______
(A) Specialization
(B) Association
(C) Generalization
(D) None of the above
Answer
(B) Association
7. In E-R Diagram, _________ represents Key Attribute.
(A) Ellipse with underlying line
(B) Rectangle with underlying line
(C) Double rectangle
(D) None of the above
Answer
(A) Ellipse with underlying line
8. Which TCL command is used to permanently save any transaction into database?
(A) rollback
(B) savepoint
(C) commit
(D) None of the above
Answer
(C) commit
9. Which TCL command restores the database to last committed state?
(A) rollback
(B) savepoint
(C) commit
(D) None of the above
Answer
(A) rollback
10._______ is used to control privilege in Database.
(A) Data Manipulation Language
(B) Data Definition Language
(C) Data Query Language
(D) Data Control Language
Answer
(D)
0 Comments