On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 34

Q1 | Which is incorporated to create an appropriate physical database that is transformed by a logical datamodel:
  • SDL
  • VDL
  • Both
  • None
Q2 | In which end is really just any application that runs on top of the DBMS and acts as a user interface:
  • Back end
  • Front end
  • Both
  • None
Q3 | Data are stored in________ as database:
  • Data files
  • Data dictionary
  • Database
  • Data administrator
Q4 | ACID properties of transactions are
  • Atomicity
  • Consistency
  • Isolation
  • Durability
Q5 | DA stands for:
  • Data administrator
  • Database active
  • Define application
  • All of these
Q6 | Which is the person responsible for overall control f the database system:
  • DDL
  • DBMS
  • DBA
  • SDL
Q7 | DBA stands for:
  • Database maintenance
  • Database administrator
  • Database backup
  • Database designer
Q8 | Transaction is an action used to perform some manipulation on data stored in the____:
  • Memory
  • Record
  • Database
  • All of these
Q9 | The data in the database at a particular moment in time is called a ________________
  • Database state
  • Valid state
  • Initial state
  • Empty state
Q10 | Which is a DBMS keeps back-up copies of the database:
  • Backup
  • Recovery
  • Both
  • None
Q11 | In which the database can be restored up to the last consistent state after the system failure:
  • Backup
  • Recovery
  • Both
  • None
Q12 | How many levels of abstraction in DBMS:
  • 2
  • 3
  • 4
  • 5
Q13 | Which are the three levels of abstraction:
  • Physical
  • Logical
  • External
  • All of these
Q14 | How many types of data independence:
  • 1
  • 2
  • 3
  • 4
Q15 | Which are the types of data independence:
  • Physical
  • Logical
  • Both
  • All of these
Q16 | Which is the transformation of requests and results between different levels of abstraction:
  • Evaluation
  • Mapping
  • Compiler
  • Precompiler
Q17 | Which mapping exists between the conceptual and internal levels:
  • Conceptual
  • Internal
  • Both
  • None
Q18 | Which mapping exists between the external and conceptual levels:
  • Conceptual
  • External
  • Both
  • None
Q19 | The related and interconnected software components of a DBMS are described by the _______:
  • Logical architecture
  • Physical architecture
  • Both
  • None
Q20 | Which are the types of physical DBMS architecture can be split :
  • Back end
  • Front end
  • Both
  • None
Q21 | The DML is called:
  • Sublanguages
  • Host languages
  • VDL
  • DDL
Q22 | The overall description of a database is called______:
  • Data definition
  • Data manipulation
  • Data integrity
  • Database schema
Q23 | Which is proper subset designed to support ‘views’ belonging to different classes of users in order tohid or protect information:
  • Schema
  • Subschema
  • Non-schema
  • None-subschema
Q24 | A data dictionary is a repository that manages _____:
  • Database
  • Memory
  • Metadata
  • All of these
Q25 | A tuple is a(n):
  • column of a table
  • two dimensional table
  • row of a table
  • key of a table