Current Affairs PDF Sales

DBMS Questions – Set 1

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. A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as ……….
    (A) Data Model
    (B) E-R Model
    (C) DBMS
    (D) All of the above
    (A) Data Model

  2. Dr.E.F. Codd represented ……. rules that a database must obey if it has to be considered truly relational.
    (A) 10
    (B) 15
    (C) 14
    (D) 12
    (D) 12

  3. In E-R Diagram, weak entity is represented by…….
    (A) Rectangle
    (B) Square
    (C) Double Rectangle
    (D) Circle
    (C) Double Rectangle

  4. An entity that is related with itself is known as…….
    (A) binary relationship
    (B) recursive relationship
    (C) ternary relationship
    (D) None of the above
    (B) recursive relationship

  5. ……. is a bottom-up approach in which two lower level entities combine to form a higher level entity.
    (A) Aggregation
    (B) Specialization
    (C) Generalization
    (D) None of the above
    (C) Generalization

  6. An entity set that does not have sufficient attributes to form a primary key, is a ……
    (A) Primary entity set
    (B) Weak entity set
    (C) Strong entity set
    (D) None of the above
    (B) Weak entity set

  7. Which SQL command delete all the records and does not remove the structure?
    (A) Drop
    (B) Insert
    (C) Truncate
    (D) None of the above
    (C) Truncate

  8. Which of the following is a Data Definition Language (DDL) command?
    (A) Delete
    (B) Insert
    (C) Drop
    (D) Merge
    (C) Drop

  9. In …….. database, data is organized in the form of trees with nodes.
    (A) Hierarchical
    (B) Relational
    (C) Network
    (D) None of the above
    (A) Hierarchical

  10. Which command is used to retrieve records from one or more table?
    (A) Delete
    (B) Insert
    (C) Drop
    (D) Select
    (D) Select