Database Management System Quiz

What does a Database Management System (DBMS) do?

• Handles physical storage of data

• Manages and organizes data efficiently

• Only allows data retrieval

• Only handles hardware storage issues

What is an example of a real-time DBMS application?

• Searching files in Windows Explorer

• A library management system

• Storing text files in a folder

• Writing code in a text editor

Which is NOT a feature of DBMS?

• Data redundancy

• Data security

• Backup and recovery

• Scalability

What does DDL stand for in SQL?

• Data Development Language

• Data Definition Language

• Data Description Language

• Data Deployment Language

Which of the following is NOT a DML operation?

• INSERT

• DELETE

• UPDATE

• CREATE

What is the purpose of the WHERE clause in SQL?

• To modify table structures

• To filter rows based on a condition

• To group rows

• To sort the result set

What type of user interacts with a database indirectly through an application?

• Naive User

• Database Administrator

• Application Developer

• System Analyst

Which is an advantage of a DBMS?

• Increased data duplication

• Difficult access control

• Centralized data management

• No security mechanisms

What is a view in a database?

• A stored procedure

• A virtual table

• A physical table

• A type of index

Which of the following is NOT a type of database user?

• End User

• Network Administrator

• System Analyst

• Database Designer