Current Affairs PDF Sales

DBMS Questions – Set 3

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. The language used in application programs to request data from the DBMS is referred to as the ______
    (A) DML
    (B) DDL
    (C) DCL
    (D) None of the above
    (A) DML

  2. In Oracle, who owns the data dictionary?
    (A) DBA
    (B) SYS
    (C) SYSTEM
    (D) None of the above
    (B) SYS

  3. In SQL, which command is used to update existing row in a table?
    (A) Insert
    (B) Delete
    (C) Update
    (D) None of the above
    (C) Update

  4. A ________ contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.
    (A) Record
    (B) Field
    (C) Table
    (D) None of the above
    (B) Field

  5. A relation between two entities is treated as a single entity is called__________
    (A) Aggregation
    (B) Specialization
    (C) Generalization
    (D) None of the above
    (A) Aggregation

  6. Data mining evolve as a mechanism to cater the limitations of _______ systems to deal massive data sets with high dimensionality.
    (A) OLAP
    (B) OLTP
    (C) DWH
    (D) None of the above
    (B) OLTP

  7. In Relational table, the term “Attribute” is also used to represent _______
    (A) row
    (B) column (or) field
    (C) entity
    (D) None of the above
    (B) column (or) field

  8. Which of the following categories of the data integrity RDBMS will enforce specific business rules?
    (A) Entity Integrity
    (B) Domain Integrity
    (C) User-Defined Integrity
    (D) None of the above
    (C) User-Defined Integrity

  9. E-R Modeling technique is a _______
    (A) top-down approach
    (B) bottom-up approach
    (C) User-Defin
    (D) None of the above
    (A) top-down approach

  10. The number of attributes in a relation is called its _____
    (A) row
    (B) column
    (C) degree
    (D) None of the above
    (C) degree