IBPS IT Officer Quiz on DBMS - Set 1

The Professional Knowledge section in IT Officer Exam comprises 50 questions and 75 marks. So, it's the decider. If you managed to do well in this section, Your chances of clearing IT Officer exam will increase. We have already provided a big collection of Question Answers and Quizzes on Professional Knowledge for IT Officer Exam. You can find the collection Here.

In this Post, We are providing you the first set of Quiz on Data Base Management System or DBMS. Participate in this Quiz to know about your preparation level.

1. In E-R diagrams, the term cardinality is a synonym for the term-
   (A) Attribute
   (B) Degree
   (C) Entities
   (D) Cartesian
   (E) None of these
   
   View Answer

   (B) Degree
2. In SQL, which command is used to change data in a data table?
   (A) UPDATE
   (B) INSERT
   (C) BROWSE
   (D) APPEND
   (E) None of these
   
   View Answer

   (A) UPDATE
3. In a relational schema, each tuple is divided into fields called
   (A) Relations
   (B) Domains
   (C) Queries
   (D) All of these
   (E) None of these
   
   View Answer

   (B) Domains
4. The language used in application programs to request data from the DBMS is referred as the
   (A) DML
   (B) DDL
   (C) Query Language
   (D) DCL
   (E) None of these
   
   View Answer

   (A) DML
5. In SQL, which command is used to add new rows to a table?
   (A) Alter Table
   (B) Add row
   (C) Insert
   (D) Append
   (E) None of these
   
   View Answer

   (C) Insert
6. The relational model includes two general integrity rules. Integrity rule 1 is concerned with ........and integrity rule 2 is concerned with.........
   (A) Primary Key, Foreign Key
   (B) Primary Key, Composite Key
   (C) Unique Key, Foreign Key
   (D) Composite Key, Foreign Key
   (E) None of these
   
   View Answer

   (A) PrimaryKey, Foreign Key
7. OLAP aplication are widely used by........... and it uses...........Schema.
   (A) RDBMS, Bus
   (B) Operating System, Star
   (C) Java, Bus
   (D) Data Mining Techniques
   (E) None of these
   
   View Answer

   (D) Data Mining Techniques
8. ODBC is based on_________
   (A) Structured Query Language
   (B) C language
   (C) C++ language
   (D) .Net
   (E) None of these
   
   View Answer

   (A) Structured Query Language
9. Which of the following is record based logical model?
   (A) Network Model
   (B) Object Oriental Model
   (C) E-R Model
   (D) All of the above
   (E) None of these
   
   View Answer

   (A) Network Model
10. To delete a particular column in a relations, the command used is
    (A) DELETE
    (B) UPDATE
    (C) DROP
    (D) ALTER
    (E) None of these
    
    View Answer

    (D) ALTER