Database Management System (DBMS)

Open its course - Database Systems

Database Management System (DBMS)

Topic Questions: 132
MCQs	T/F	FiB	SQ
49 25 24	40 18 22	32 9 23	11 6 5

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. We 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
- View Answer
2 ______ enables end users and application programmers to share data among multiple applications.
1. DBMS
2. data
3. information
4. database
- View Answer
3 DBMS provide which one of the following language?
1. DDL
2. DML
3. DCL
4. all of them
- View Answer
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
- View Answer
5 Which purpose of DBMS restrict access to the data?
1. Views
2. Layers
3. Integrity
4. Security
- View Answer
6 The first generation of database system was:
1. Hierarchical and Network
2. Relational
3. Extended Relational
4. non of them
- View Answer
7 Which of the following has many users, large transactions and static historical data?
1. OLTP
2. OLAP
3. DBMS
4. SQL
- View Answer
8 Which of the following helps in exploring the multi-dimensional data?
1. OLTP
2. OLAP
3. DBMS
4. SQL
- View Answer
9 Which of the following is used for retrieval, update, or insertion of isolated facts?
1. DBMS
2. Databases
3. OLTP
4. OLAP
- View Answer
10 Which of the following is advantage from DBMS
1. Has complexity
2. More Size
3. They are costly
4. Provides security
- View Answer
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
- View Answer
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
- View Answer
13 The objective of database management systems include:
1. Data Integrity
2. Data Security
3. Privacy
4. All
- View Answer
14 A database containing all students in a class would store basic data of students in:
1. File
2. Record
3. Field
4. Cell
- View Answer
15 An item of information within a record (e.g. Name for Student) is called:
1. File
2. Field
3. Record
4. Database
- View Answer
16 Keeping data in files requires that all records in a file should have the same:
1. Contents
2. Structure
3. Standards
4. None
- View Answer
17 A collection of related fields is:
1. File
2. Record
3. Database
4. None
- View Answer
18 Which purpose of DBMS offer simultaneous access to many users for data in databases?
1. Integrity
2. Concurrency
3. Recovery
4. Backup
- View Answer
19 "Provide one application to access many databases" best describe which purpose of DBMS?
1. View
2. Security
3. Access
4. Integrity
- View Answer
20 The second generation of database systems was:
1. Relational
2. Hierarchical and Object Oriented
3. Extended Relational
4. Network
- View Answer
21 The first generation of database systems was:
1. Relational
2. Extended Relational
3. Hierarchical and Network
4. Object-Oriented
- View Answer
22 Which of the following cannot be done by a DBMS?
1. increase data
2. retrieve data
3. provide security
4. store data
- View Answer
23 Which of the following deals with data only in DBMS?
1. DDL
2. DCL
3. DML
4. None
- View Answer
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
- View Answer
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
- View Answer

Programs

Database Management System (DBMS)

Multiple Choice Questions for Database Management System (DBMS)

Hidden Questions!

Subject Expert

Learning Experience Platform