WorksheetsDatabase Management System Quiz
Total questions: 17
Worksheet time: 9mins
What does DBMS stand for?
Database Management System
Data Base Management System
Database Management Software
Data Management System
Which of the following is NOT a function of a DBMS?
Data printing
Data analysis
Data storage
Data retrieval
What is the main aim of a DBMS?
To create data
To supply a way to store and retrieve information
To analyze data
To delete data
Which of the following is an example of data?
Second month sale= Rs. 34200
Rs. 25500
First month sale= Rs. 25500
Rose Bakery and Café
What is a database?
A programming language
A type of software
A collection of related data
A collection of unrelated data
Which of the following is a popular DBMS package?
HTML
MySQL
Java
Python
What is one advantage of using a DBMS over a flat file system?
More data redundancy
High security features
Lower cost
Less data consistency
What does knowledge refer to in the context of data and information?
Raw facts
Refined information
Unorganized data
Useful use of information
Which of the following is a disadvantage of DBMS?
Data independence
Data integrity
Complexity
Efficient data access
What is the role of a Database Administrator (DBA)?
To write application programs
To maintain control over the database system
To access the database from the terminal
To develop special database applications
Which of the following is NOT a type of database user?
Database Managers
End-users
Application Programmers
Sophisticated Users
What does DDL stand for?
Data Definition Language
Data Development Language
Data Description Language
Data Distribution Language
Which command is used to read records from a table in DML?
SELECT
UPDATE
INSERT
DELETE
What is the purpose of the COMMIT command in TCL?
To persist changes made by DML commands
To create a new table
To rollback changes
To delete records
Which of the following is a function of the DBA?
Developing software applications
Creating user accounts
Writing SQL queries
Designing user interfaces
What is the primary focus of Data Control Language (DCL)?
Data storage
User access control
Data definition
Data manipulation
Which of the following is an example of a Data Manipulation Language (DML) command?
CREATE
ALTER
DROP
SELECT
