GK

1. 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) Hierarchical Schema
2. Aggregation is a special form of _______
   (A) Specialization
   (B) Association
   (C) Generalization
   (D) None of the above
   
   Answer

   (B) Association
3. 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
4. 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
5. Which TCL command restores the database to last committed state?
   (A) rollback
   (B) savepoint
   (C) commit
   (D) None of the above
   
   Answer

   (A) rollback
6. _______ 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) Data Control Language
7. Which model remains operative until the software is required?
   (A) Waterfall model
   (B) Incremental model
   (C) Prototyping model
   (D) Spiral model
   
   Answer

   (D) Spiral model
8. 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) System tablespace
9. Which of the following is another name for weak entity?
   (A) Dominant
   (B) Child
   (C) Owner
   (D) None of the above
   
   Answer

   (B) Child
10. ODBC is based on ________
    (A) C++ language
    (B) RDBMS
    (C) Structured Query Language
    (D) C language
    
    Answer

    (C) Structured Query Language