DBMS Questions – Set 9

Dear Aspirants,
Welcome to the Professional Knowledge Section in Affairscloud.com. Here we are providing sample questions in DBMS. It will be useful for the IBPS SO IT officer and SBI Assistant Manager(System). We have also included some important questions that are repeatedly asked in previous exams.

1. ________ allows a unique number to be generated when a new record is inserted into a table.
   (A) Insert Into Select
   (B) Insert Into
   (C) Select Into
   (D) Auto Increment
   

   Answer

   (D) Auto Increment
   
   
2. Which of the following constraint is used to limit the value range that can be placed in a column?
   (A) Check
   (B) Default
   (C) Unique
   (D) None of the above
   

   Answer

   (A) Check
   
   
3. A Foreign key in one table points to a ________ key in another table.
   (A) Alternate
   (B) Default
   (C) Primary
   (D) None of the above
   

   Answer

   (C) Primary
   
   
4. Domain constraints, functional dependency and referential integrity are special forms of _________
   (A) Foreign key
   (B) Primary key
   (C) Referential constraint
   (D) Assertion
   

   Answer

   (D) Assertion
   
   
5. 4NF stands for ______
   (A) Fourth Normal File
   (B) Fourth Normal Form
   (C) Fourth Normal Fraction
   (D) Fourth Negative File
   

   Answer

   (B) Fourth Normal Form
   
   
6. Which of the following field type is used to store photograph of employees?
   (A) Memo
   (B) Picture
   (C) OLE
   (D) Photo
   

   Answer

   (C) OLE
   
   
7. _______ statement is used in conjunction with the aggregate functions to group the result-set by one or more columns.
   (A) Select
   (B) Group By
   (C) Distinct
   (D) None of the above
   

   Answer

   (B) Group By
   
   
8. Which of the following method can be used to add more tables in a database?
   (A) Design View
   (B) Table Wizard
   (C) Both (A) & (B)
   (D) None of the above
   

   Answer

   (C) Both (A) & (B)
   
   
9. Which of the following field type is the best to store serial numbers?
   (A) Number
   (B) Auto Number
   (C) Text
   (D) Memo
   

   Answer

   (B) Auto Number
   
   
10. The feature that database allows to access only certain records in database is______
    (A) Queries
    (B) Reports
    (C) Forms
    (D) Tables
    

    Answer

    (A) Queries