IBPS IT Officer Quiz on Data Base Management System - Set 2

The Professional Knowledge section in IT Officer Exam comprises 50 questions and 75 marks. So, it's the most important section. 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 last Post, We provided you the first set of Quiz on Data Base Management System or DBMS. In This post, We are providing you the Second set on Data Base Management System.

1. Which of the following is not an advantage of the data-base approach?
   (A) Increased Security
   (B) Elimination of Data Redundancy
   (C) Ability to associate related data
   (D) Programming/data Independence
   (E) None of the above
   
   View Answer

   (E) None of the above
   Explanation:: Everything mentioned in the option are the benefits of using Data Base Approach.
2. In the Relational schema, each tuple is divided into fields called________
   (A) Relations
   (B) Domains
   (C) Queries
   (D) Both (A) and (B)
   (E) None of these
   
   View Answer

   (B) Domain
3. Which Normal form is considered adequate for relational database design?
   (A) 2 NF
   (B) 3 NF
   (C) 4 NF
   (D) BCNF
   (E) None of these
   
   View Answer

   (B) 3 NF
4. A primary key if combined with a foreign key creates
   (A) Parent-Child relationship between the tables that connect them
   (B) Many to many relationship between the tables that connect them
   (C) Network model between the tables that connect them
   (D) All of the above
   (E) None of these
   
   View Answer

   (A) Parent-Child relationship between the tables that connect them
5. In a relationship database, this is a data structure that organizes the information about a single topic into row and columns.
   (A) Blocks
   (B) Record
   (C) Tuple
   (D) Table
   (E) None of these
   
   View Answer

   (D) Table
6. An attribute of a relation that reference the primary key of another relation is known as the___________
   (A) Foreign Key
   (B) Unique Key
   (C) Parent Key
   (D) Child Key
   (E) Index Key
   
   View Answer

   (A) Foreign Key
7. The way a particular application views the data from the database that the application uses is a
   (A) Module
   (B) Relational Model
   (C) Schema
   (D) Subschema
   (E) None of the above
   
   View Answer

   (D) Subschema
8. The modify operation is likely to be done after
   (A) Delete
   (B) Insert
   (C) Look Up
   (D) All of these
   (E) None of these
   
   View Answer

   (C) Look Up
9. In SQL, which command(s) is(are) used to remove rows from a table
   (A) Delete
   (B) Remove
   (C) Truncate
   (D) Both (A) and (C)
   (E) None of these
   
   View Answer

   (D) Both (A) and (C)
10. TRUNCATE statement in SQL is a _________
    (A) DML statement
    (B) DDL statement
    (C) DCL statement
    (D) DSL statement
    (E) None of these
    
    View Answer

    (B) DDL statement