Current Affairs PDF Sales

DBMS Questions – Set 5

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. OLAP stands for_____
    (A) Online Arithmetic Processing
    (B) Online Analysis Processing
    (C) Online Analytical Processing
    (D) None of the above
    (C) Online Analytical Processing

  2. The _____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
    (A) Join
    (B) Intersection
    (C) Union
    (D) None of the above
    (A) Join

  3. ________is the multiplication of all the values in the attributes.
    (A) Set difference
    (B) Cartesian product
    (C) Intersection
    (D) None of the above
    (B) Cartesian product

  4. Which command is used to remove a relation from an SQL database?
    (A) Delete
    (B) Remove
    (C) Drop
    (D) None of the above
    (C) Drop

  5. In SQL, the spaces at the end of the string are removed by _______ function .
    (A) Lower
    (B) String
    (C) Trim
    (D) None of the above
    (C) Trim

  6. ________ is used to save permanently any transaction into database.
    (A) commit
    (B) rollback
    (C) savepoint
    (D) None of the above
    (A) commit

  7. A unit of storage that can store one or more records in a hash file organization is denoted as_______
    (A) Bucket
    (B) Disk pages
    (C) Blocks
    (D) Nodes
    (A) Bucket 

  8. Which of the following operator used for appending two strings?
    (A) %
    (B) &
    (C) +
    (D) ||
    (D) ||

  9. The management information system (MIS) structure with one main computer system is called a________
    (A) Decentralized MIS structure
    (B) Distributed MIS structure
    (C) Centralized MIS structure
    (D) None of the above
    (C) Centralized MIS structure

  10. The highest level in the hierarchy of data organization is called________
    (A) data base
    (B) data file
    (C) data record
    (D) None of the above
    (A) data base