Quiz  /  Database Management System MCQ Questions and Answers

  • 1. 
    A Database Management System (DBMS) is

  • Collection of interrelated data
  • Collection of programs to access data
  • Collection of data describing one particular enterprise
  • All of the above

  • 2. 
    Which of the following is not a level of data abstraction?

  • Physical Level
  • Critical Level
  • Logical Level
  • View Level

  • 3. 
    Disadvantages of File systems to store data is:

  • Data redundancy and inconsistency
  • Difficulty in accessing data
  • Data isolation
  • All of the above

  • 4. 
    In an Entity-Relationship Diagram Rectangles represents

  • Entity sets
  • Attributes
  • Database
  • Tables

  • 5. 
    Which of the following is not a Storage Manager Component?

  • Transaction Manager
  • Logical Manager
  • Buffer Manager
  • File Manager

  • 6. 
    Data Manipulation Language enables users to

  • Retrieval of information stored in database
  • Insertion of new information into the database
  • Deletion of information from the database
  • All of the above

  • 7. 
    Which of the following is not an Schema?

  • Database Schema
  • Physical Schema
  • Critical Schema
  • Logical Schema

  • 8. 
    Which of the following is Database Language?

  • Data Definition Language
  • Data Manipulation Language
  • Query Language
  • All of the above

  • 9. 
    Which of the following in not a function of DBA?

  • Network Maintenance
  • Routine Maintenance
  • Schema Definition
  • Authorization for data access

  • 10. 
    Which of the following is a Data Model?

  • Entity-Relationship model
  • Relational data model
  • Object-Based data model
  • All of the above

  • 11. 
    Which of the following represents a relationship among a set of values.

  • A Row
  • A Table
  • A Field
  • A Column

  • 12. 
    Column header is refer as

  • Table
  • Relation
  • Attributes
  • Domain

  • 13. 
    A Relation is a

  • Subset of a Cartesian product of a list of attributes
  • Subset of a Cartesian product of a list of domains
  • Subset of a Cartesian product of a list of tuple
  • Subset of a Cartesian product of a list of relations

  • 14. 
    In mathematical term Table is referred as

  • Relation
  • Attribute
  • Tuple
  • Domain

  • 15. 
    In mathematical term Row is referred as

  • Relation
  • Attribute
  • Tuple
  • Domain

  • 16. 
    _______ allow us to identify uniquely a tuple in the relation.

  • Super key
  • Domain
  • Attribute
  • Schema

  • 17. 
    Minimal Super keys are called

  • Schema keys
  • Candidate keys
  • Domain keys
  • Attribute keys

  • 18. 
    Which of the following is not Modification of the Database

  • Deletion
  • Insertion
  • Sorting
  • Updating

  • 19. 
    Which of the following is Relation-algebra Operation

  • Select
  • Union
  • Rename
  • All of the above

  • 20. 
    Which of the following in not Outer join?

  • Left outer join
  • Right outer join
  • Full outer join
  • All of the above
Report Question
warning
access_time
  Time