Database Management System (DBMS) Questions and Answers | DBMS MCQs

1. DBMS is a collection of queries
2. DBMS is a high-level language
3. DBMS is a programming language
4. DBMS stores, modifies and retrieves data

Answer: DBMS stores, modifies and retrieves data

1. Minimum Duplication and Redundancy of Data
2. High Level of Security
3. Single-user Access only
4. Support ACID Property

Answer: Single-user Access only

1. Create
2. Update
3. Delete
4. Merge

Answer: Create

1. Queries
2. Domains
3. Relations
4. All of the above

Answer: Domains

1. Delete
2. Update
3. Insert
4. None of the above

Answer: Delete

1. Translators
2. Programs
3. Keys
4. Language activity

Answer: Programs

1. Transaction Control Language (TCL)
2. Data Control Language (DCL)
3. Data Definition Language (DDL)
4. Data Manipulation Language (DML)

Answer: Data Manipulation Language (DML)

1. Relation set
2. Tuples
3. Entity set
4. Entity Relation model

Answer: Entity set

1. Microphone
2. High speed, large capacity disk to store data
3. High-resolution video display
4. Printer

Answer: High speed, large capacity disk to store data

1. DML(Data Manipulation Language)
2. DDL(Data Definition Language)
3. Query
4. Relational Schema

Answer: DML(Data Manipulation Language)

SELECT *  
FROM instructor  
ORDER BY salary ____, name ___;

1. Ascending, Descending
2. Asc, Desc
3. Desc, Asc
4. All of the above

Answer: Desc, Asc

1. 8GB
2. 4GB
3. 4TB
4. None of the above

Answer: 4GB

1. Data Management
2. Data Mining
3. Data Warehouse
4. Both B and C

Answer: Data Warehouse

1. Directory
2. Sub Data
3. Warehouse
4. Meta Data

Answer: Meta Data

1. Rows & Columns
2. Fields
3. Database
4. Records

Answer: Records

1. Degree
2. Tuples
3. Entity
4. All of the above

Answer: All of the above

1. Create
2. Alter
3. Delete
4. All of the above

Answer: Delete

1. Specialization
2. Generalization
3. Aggregation
4. None of the above

Answer: Generalization

1. Entity
2. Row
3. Column
4. Both B & C

Answer: Column

1. Abort state
2. Partially committed state
3. Committed state
4. Active state

Answer: Partially committed state

1. Savepoint
2. Rollback
3. Commit
4. Both A & B

Answer: Rollback

1. Standard query language
2. Sequential query language
3. Structured query language
4. Server-side query language

Answer: Structured query language

1. Delete
2. Drop
3. Remove
4. All of the above

Answer: Drop

1. Join dependency
2. Domain-key
3. Multivalued dependency
4. Functional dependency

Answer: Join dependency

1. examination of each pair of physical blocks occurs
2. examination of a specified pair of physical blocks occurs
3. examination of the first pair of physical blocks occurs
4. none of the above

Answer: examination of each pair of physical blocks occurs

1. External node
2. Leaf node
3. Internal node
4. Final node

Answer: Internal node

1. down the tree, back up
2. up the tree, back down
3. down the tree, releases
4. up the tree, releases

Answer: down the tree, back up

1. Redo logs
2. Primary Logs
3. Undo Logs
4. All of the above

Answer: Primary Logs

1. Dominant
2. Owner
3. Child
4. All of the above

Answer: Child

1. DML(Data Manipulation Language)
2. Query
3. Relational Schema
4. DDL(Data Definition Language)

Answer: DDL(Data Definition Language)

1. Data and the DBMS
2. Application and SQL
3. Database application and the database
4. The user and the software

Answer: Database application and the database

1. Collection of Records
2. Collection of Keys
3. Collection of Tables
4. Collection of Fields

Answer: Collection of Tables

1. Data
2. Data Languages
3. Data Manager
4. All of the above

Answer: All of the above

1. Managing stored data
2. Manipulating data
3. Security for stored data
4. Analysing code

Answer: Analysing code

1. No-backup for the data stored
2. User interface provided
3. Lack of Authentication
4. Store data in multiple locations

Answer: User interface provided

1. Hierarchical
2. Network
3. Distributed
4. Decentralized

Answer: Decentralized

1. Organized collection of information that cannot be accessed, updated, and managed
2. Collection of data or information without organizing
3. Organized collection of data or information that can be accessed, updated, and managed
4. Organized collection of data that cannot be updated

Answer: Organized collection of data or information that can be accessed, updated, and managed

1. Edgar Frank Codd
2. Charles Bachman
3. Charles Babbage
4. Sharon B. Codd

Answer: Charles Bachman

1. MySQL
2. Microsoft Acess
3. IBM DB2
4. Google

Answer: Google

1. Storing data
2. Providing multi-users access control
3. Data Integrity
4. All of the above

Answer: All of the above

1. TCL (Transaction Control Language)
2. DCL (Data Control Language)
3. DDL (Data Definition Langauge)
4. DML (Data Manipulation Langauge)

Answer: DML (Data Manipulation Langauge)

1. It is a type of system software
2. It is a kind of application software
3. It is a kind of general software
4. Both A and C

Answer: It is a type of system software

1. New Technology File System
2. New Tree File System
3. New Table type File System
4. Both A and C

Answer: New Technology File System

1. Data redundancy
2. Data recovery tool
3. Data mining
4. Both B and C

Answer: Data mining

1. Conceptual Level
2. Physical Level
3. File Level
4. Logical Level

Answer: Physical Level

1. Entity
2. Column
3. Cardinality
4. None of the above

Answer: Cardinality

1. Ternary Control Language
2. Transmission Control Language
3. Transaction Central Language
4. Transaction Control Language

Answer: Transaction Control Language

1. Data file diagram
2. Data flow document
3. Data flow diagram
4. None of the above

Answer: Data flow diagram

1. db_setupadmin
2. db_securityadmin
3. db_accessadmin
4. db_sysadmin

Answer: db_accessadmin

1. Response
2. Challenge-response
3. Manipulation
4. Readable

Answer: Challenge-response

1. Intel 4004
2. Intel 639
3. Intel 308
4. Motorola 33

Answer: Intel 4004

1. Independence
2. Instance of the database
3. Schema
4. Data domain

Answer: Instance of the database

1. ALTER SYS LOGFILES
2. ALTER SYSTEM SWITCH LOGS
3. ALTER SYSTEM LOG
4. ALTER SYSTEM SWITCH LOGFILE

Answer: ALTER SYSTEM SWITCH LOGFILE

1. O(n2)
2. O(n log n)
3. O(n)
4. O(log n)

Answer: O(n)

1. Image
2. Text
3. Table
4. Graph

Answer: Table

1. Hyper data
2. Tera data
3. Meta data
4. Relations

Answer: Meta data

1. Data of Binary Management System
2. Database Management System
3. Database Management Service
4. Data Backup Management System

Answer: Database Management System

1. Referential
2. Primary
3. Referencing
4. Specific

Answer: Referential

1. File Allocation Tree
2. File Allocation Table
3. File Allocation Graph
4. All of the above

Answer: File Allocation Table

1. Data Repository
2. Data Inconsistency
3. Data Mining
4. Data Redundancy

Answer: Data Redundancy