Database Management System (DBMS)

  • History of Database Systems
  • Purposes of a DBMS
  • Components of DBMS Environment
  • Types of...
    View Complete Description
    ×

    Topic Summary

    • History of Database Systems
    • Purposes of a DBMS
    • Components of DBMS Environment
    • Types of Database Users
    • DBMS Components
    • Advantages/ Disadvantages of DBMS
    • DBMS Architecture (ANSI-SPARC)
Topic Questions:
131
MCQs T/F FiB SQ
48 40 32 11
Question Type Legends

Easy

Medium

Difficult

Multiple Choice Questions for Database Management System (DBMS)

  • 1 Extended Relational, Object-Oriented are the ______ generations of database management system.
    1. 1st
    2. 4th
    3. 2nd
    4. 3rd

  • 2 ______ enables end users and application programmers to share data among multiple applications.
    1. DBMS
    2. data
    3. information
    4. database

  • 3 DBMS provide which one of the following language?
    1. DDL
    2. DML
    3. DCL
    4. all of them

  • 4 Which one of the following DBMS component, communicates with recovery manager and scheduler to ensure data consistency in multi-user environments.
    1. Storage manager
    2. Transaction manager
    3. Query processor
    4. Data dictionary

  • 5 Which purpose of DBMS restrict access to the data?
    1. Views
    2. Layers
    3. Integrity
    4. Security

  • 6 The first generation of database system was:
    1. Hierarchical and Network
    2. Relational
    3. Extended Relational
    4. non of them

  • 7 Which of the following has many users, large transactions and static historical data?
    1. OLTP
    2. OLAP
    3. DBMS
    4. SQL

  • 8 Which of the following helps in exploring the multi-dimensional data?
    1. OLTP
    2. OLAP
    3. DBMS
    4. SQL

  • 9 Which of the following is used for retrieval, update, or insertion of isolated facts?
    1. DBMS
    2. Databases
    3. OLTP
    4. OLAP

  • 10 Which of the following is advantage from DBMS
    1. Has complexity
    2. More Size
    3. They are costly
    4. Provides security

  • 11 Which of the following is an advantage of DBMS?
    1. Sharing of data
    2. Provides Data integrity
    3. Decrease Productivity
    4. Increase concurrency

  • 12 Which of the following component of DBMS help in controlling the recovery process of database?
    1. Query Processor
    2. Transaction Manager
    3. Storage Manager
    4. Database

  • 13 Which of the following DBMS component will first process the DDL statements from DBA?
    1. Query Processor
    2. DD Compiler
    3. Data Dictionary
    4. Storage Manager

  • 14 Information about the structure and organization of data in a database is contained in:
    1. Data Dictionary
    2. Storage Manager
    3. SQL
    4. None

  • 15 The database system environment is composed of the following components:
    1. Hardware, Hard Drive, Monitor, Data, User
    2. Hardware, Software, Data, Procedure, People
    3. Sotware, Hardware, You, DBA, Client
    4. DBMS, Hardware, Software, User, Programmer

  • 16 The objective of database management systems include:
    1. Data Integrity
    2. Data Security
    3. Privacy
    4. All

  • 17 A database containing all students in a class would store basic data of students in:
    1. File
    2. Record
    3. Field
    4. Cell

  • 18 An item of information within a record (e.g. Name for Student) is called:
    1. File
    2. Field
    3. Record
    4. Database

  • 19 Keeping data in files requires that all records in a file should have the same:
    1. Contents
    2. Structure
    3. Standards
    4. None

  • 20 A collection of related fields is:
    1. File
    2. Record
    3. Database
    4. None

  • 21 Which purpose of DBMS offer simultaneous access to many users for data in databases?
    1. Integrity
    2. Concurrency
    3. Recovery
    4. Backup

  • 22 "Provide one application to access many databases" best describe which purpose of DBMS?
    1. View
    2. Security
    3. Access
    4. Integrity

  • 23 The second generation of database systems was:
    1. Relational
    2. Hierarchical and Object Oriented
    3. Extended Relational
    4. Network

  • 24 The first generation of database systems was:
    1. Relational
    2. Extended Relational
    3. Hierarchical and Network
    4. Object-Oriented

  • 25 Which of the following cannot be done by a DBMS?
    1. increase data
    2. retrieve data
    3. provide security
    4. store data

  • 26 Which of the following deals with data only in DBMS?
    1. DDL
    2. DCL
    3. DML
    4. None

  • 27 Which of the following is not a function of the DBMS?
    1. controlling data access
    2. Loosing data integrity
    3. managing concurrency control
    4. restoring a database

  • 28 Which of the following provides a systematic method of creating, updating, storing, and retrieving data in a database?
    1. Operating Systems
    2. Database Management Systems
    3. Management Information Systems
    4. Integrated Development Environment Softwares

  • ×

    Hidden Questions!

    Some MCQs are not visible. Usually teachers hides the visibility if they are few in number. Subject Expert recommends them to have more than 70+ questions against the topic and make them public.

Contact Us

support@subexpert.com
Write to Us View Help
Subject Expert Logo

Subject Expert

Learn and Evaluate

Follow Us
© 2020 - Subject Expert