GK

1. The language used in application programs to request data from the DBMS is referred to as the ______
   (A) DML
   (B) DDL
   (C) DCL
   (D) None of the above
   
   Answer

   (A) DML
2. In Oracle, who owns the data dictionary?
   (A) DBA
   (B) SYS
   (C) SYSTEM
   (D) None of the above
   
   Answer

   (B) SYS
3. In SQL, which command is used to update existing row in a table?
   (A) Insert
   (B) Delete
   (C) Update
   (D) None of the above
   
   Answer

   (C) Update
4. A ________ contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.
   (A) Record
   (B) Field
   (C) Table
   (D) None of the above
   
   Answer

   (B) Field
5. A relation between two entities is treated as a single entity is called__________
   (A) Aggregation
   (B) Specialization
   (C) Generalization
   (D) None of the above
   
   Answer

   (A) Aggregation
6. Data mining evolve as a mechanism to cater the limitations of _______ systems to deal massive data sets with high dimensionality.
   (A) OLAP
   (B) OLTP
   (C) DWH
   (D) None of the above
   
   Answer

   (B) OLTP
7. In Relational table, the term “Attribute” is also used to represent _______
   (A) row
   (B) column (or) field
   (C) entity
   (D) None of the above
   
   Answer

   (B) column (or) field
8. Which of the following categories of the data integrity RDBMS will enforce specific business rules?
   (A) Entity Integrity
   (B) Domain Integrity
   (C) User-Defined Integrity
   (D) None of the above
   
   Answer

   (C) User-Defined Integrity
9. E-R Modeling technique is a _______
   (A) top-down approach
   (B) bottom-up approach
   (C) User-Defin
   (D) None of the above
   
   Answer

   (A) top-down approach
10. The number of attributes in a relation is called its _____
    (A) row
    (B) column
    (C) degree
    (D) None of the above
    
    Answer

    (C) degree