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

   E. NoSQL DBMS
   Explanation:
   No SQL is suited for loosely defined data structures. NoSQL isused loosely to refer to non-relational databases
   
   
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

   D. All of the Above
   Explanation:
   NoSQL refers to Non SQL or Non relational or Not only SQL 
   
   
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

   B. IMDBMS
   Explanation:
   An In-Memory Database (IMDB) aka Main Memory Database System(MMDB) or Memory Resident Database is a database management system that primarily relies on main memory for computer data storage.
   
   
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

   C. Columnar Database Management System
   Explanation:
   Columnar Database Management System is suited for data warehouses that have a large number of similar data items.
   
   
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

   D. All of the Above
   Explanation:
   Data warehousing involves data cleaning, data integration and data consolidations.
   
   
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

   B. Data Mart
   Explanation:
   Data Mart is a subset of the data warehouse and is usually oriented to a team.
   
   
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

   D. Cloud based Data Management System
   Explanation:
   Cloud based Data Management System is a database management system that is hosted by a third-party service provider on a remote server and accessed over the Internet.
   
   
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

   C. Data Warehouse
   Explanation:
   A Data Warehouse is a central repository for all or significant parts of the data that an enterprise’s various business systems collect.
   
   
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

   A. Spread Mart
   Explanation:
   A spread mart aka spreadsheet data mart is a business data analysis system running on spreadsheets or other desktop databases that is created and maintained by individuals or groups to perform the tasks normally done by a data mart or data warehouse.
   
   
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

    A. OLTP
    Explanation:
    Online Transaction Processing(OLTP) is characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE).