DBMS Questions – Set 19

Dear Aspirants,
Welcome to the Professional Knowledge Section in Affairscloud.com. Here we are providing sample questions in Computer Networking. It will be useful for the upcoming SBI Assistant Manager(System) and IBPS SO(IT Officer) examinations. We have also included some important questions that are repeatedly asked in previous exams.

  1. Which of the following is suited for loosely defined data structures?
    A. CDBMS
    B. IMDBMS
    C. Column Database Management System
    D. Cloud based Data Management System
    E. NoSQL DBMS
    Answer & Explanation
  2. In NoSQL Database, NoSQL refers?
    A. Non SQL
    B. Non relational
    C. Not only SQL
    D. All of the Above
    E. None of the Above
    Answer & Explanation
  3. Which of the following database provides faster response time and better performance?
    A. CDBMS
    B. IMDBMS
    C. Column Database Management System
    D. Cloud based Data Management System
    E. NoSQL DBMS
    Answer & Explanation
  4. Which of the following is suited for data warehouses that have a large number of similar data items?
    A. NoSQL DBMS
    B. IMDBMS
    C. Columnar Database Management System
    D. Cloud based Data Management System
    E. None of these
    Answer & Explanation
  5. Data warehousing involves which of the following?
    A. data cleaning
    B. data integration
    C. data consolidations.
    D. All of the Above
    E. None of the Above
    Answer & Explanation
  6. Which of the following is a subset of the data warehouse and is usually oriented to a team?
    A. Data Cleaning
    B. Data Mart
    C. Data Integration
    D. Data consolidations
    E. None of these
    Answer & Explanation
  7. Which is a database management system that is hosted by a third-party service provider on a remote server and accessed over the Internet?
    A. NoSQL DBMS
    B. IMDBMS
    C. Columnar Database Management System
    D. Cloud based Data Management System
    E. None of these
    Answer & Explanation
  8. A _________ is a central repository for all or significant parts of the data that an enterprise’s various business systems collect.
    A. Spread Mart
    B. Data Mart
    C. Data Warehouse
    D. Data consolidations
    E. None of these
    Answer & Explanation
  9. Which of the following is a business data analysis system running on spreadsheets or other desktop databases that is created and maintained by individuals or groups?
    A. Spread Mart
    B. Data Mart
    C. Data Warehouse
    D. Data consolidations
    E. None of these
    Answer & Explanation
  10. Which of the following is characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE)?
    A. OLTP
    B. OLAP
    C. Predictive Analysis
    D. All of these
    E. None of these
    Answer & Explanation