Database Management System Set 34
Computer Science Engineering (CSE),
Bachelor of Science in Computer Science FY (BSc CS),
Bachelor of Science in Computer Science SY (BSc CS),
Bachelor of Science in Information Technology SY (BSc IT),
Bachelor of Computer Applications (BCA),
Bachelor of Business Administration in Computer Applications (BBA [CA]),
Bachelor of Science in Information Technology (BSc IT),
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