Current Affairs PDF

DBMS Questions – Set 6

AffairsCloud YouTube Channel - Click Here

AffairsCloud APP 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. Which SQL statement is used to extract data from a database?
    (A) EXTRACT
    (B) GET
    (C) OPEN
    (D) SELECT
    (D) SELECT

  2. Which of the following keyword can be used to return different values?
    (A) SELECT
    (B) GET
    (C) OPEN
    (D) DISTINCT
    (D) DISTINCT

  3. ______ operator is used to display a record if either the first condition or the second condition is true.
    (A) AND
    (B) OR
    (C) Both (A) & (B)
    (D) None of the above
    (B) OR

  4. Which of the following DBMS provides faster response time and better performance?
    (A) Relational Database Management System (RDBMS)
    (B) NoSQL DBMS
    (C) In-Memory Database Management System (IMDBMS)
    (D) None of the above
    (C) In-Memory Database Management System (IMDBMS)

  5. ________is suitable for data warehouses that have a large number of similar data items.
    (A) Relational Database Management System (RDBMS)
    (B) Columnar Database Management system (CDBMS)
    (C) In-Memory Database Management System (IMDBMS)
    (D) None of the above
    (B) Columnar Database Management system (CDBMS)

  6. Which of the following is standard interactive and programming language for getting information from and updating a database.
    (A) SQL
    (B) PHP
    (C) ASP
    (D) None of the above
    (A) SQL

  7. _______ keyword sorts the record in ascending order by default.
    (A) ORDER BY
    (B) SORT BY
    (C) SORT
    (D) None of the above
    (A) ORDER BY

  8. Which of the following is an open standard Application Programming Interface (API) for accessing a database?
    (A) Universal Data Access
    (B) Open Database Connectivity
    (C) Command Line Interface
    (D) Open Data-Link Interface
    (B) Open Database Connectivity

  9. Which SQL statement is used to insert new data in a database?
    (A) INSERT INTO
    (B) ADD NEW
    (C) ADD RECORD
    (D) None of the above
    (A) INSERT INTO

  10. Which method of Online Analytical Processing stores data in both a relational and a multi dimensional database.
    (A) Hybrid OLAP
    (B) Relational OLAP
    (C) OLAP
    (D) None of the above
    (A) Hybrid OLAP