Current Affairs PDF Sales

DBMS Questions – Set 9

AffairsCloud YouTube Channel - Click Here

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
    (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
    (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
    (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
    (D) Assertion

  5. 4NF stands for ______
    (A) Fourth Normal File
    (B) Fourth Normal Form
    (C) Fourth Normal Fraction
    (D) Fourth Negative File
    (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
    (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
    (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
    (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
    (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
    (A) Queries