Home

Communicator
Tools
Profile Settings
Loading, please wait ...
Open its course - Database Systems

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:
132
MCQs T/F FiB SQ
49 40 32 11
Question Type Legends

Easy

Medium

Difficult
MCQs T/F FiB Short Qs
Open its course - Database Systems

Multiple Choice Questions for Database Management System (DBMS)

  • ×

    Hidden Questions!

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

  • 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 Information about the structure and organization of data in a database is contained in:
    1. Data Dictionary
    2. Storage Manager
    3. SQL
    4. None
  • 12 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
  • 13 The objective of database management systems include:
    1. Data Integrity
    2. Data Security
    3. Privacy
    4. All
  • 14 A database containing all students in a class would store basic data of students in:
    1. File
    2. Record
    3. Field
    4. Cell
  • 15 An item of information within a record (e.g. Name for Student) is called:
    1. File
    2. Field
    3. Record
    4. Database
  • 16 Keeping data in files requires that all records in a file should have the same:
    1. Contents
    2. Structure
    3. Standards
    4. None
  • 17 A collection of related fields is:
    1. File
    2. Record
    3. Database
    4. None
  • 18 Which purpose of DBMS offer simultaneous access to many users for data in databases?
    1. Integrity
    2. Concurrency
    3. Recovery
    4. Backup
  • 19 "Provide one application to access many databases" best describe which purpose of DBMS?
    1. View
    2. Security
    3. Access
    4. Integrity
  • 20 The second generation of database systems was:
    1. Relational
    2. Hierarchical and Object Oriented
    3. Extended Relational
    4. Network
  • 21 The first generation of database systems was:
    1. Relational
    2. Extended Relational
    3. Hierarchical and Network
    4. Object-Oriented
  • 22 Which of the following cannot be done by a DBMS?
    1. increase data
    2. retrieve data
    3. provide security
    4. store data
  • 23 Which of the following deals with data only in DBMS?
    1. DDL
    2. DCL
    3. DML
    4. None
  • 24 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
  • 25 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
About Us
Who we are Privacy Policy Terms of Use
Contact Us

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

Subject Expert

Learn, Evaluate and Optimize

Products / Utilites
Attendance Mapper Industry Liason Cell (ILC) Smart Secretary
Follow Us
Facebook Switch Display Mode Enable Translation
© 2024 - Subject Expert