NEW
Font size
WorksheetsDatabase Management Systems Unit I Quiz
Total questions: 20
Worksheet time: 10mins
What is the primary purpose of a Database Management System (DBMS)?
Store and retrieve data
Print reports
Play multimedia files
Create graphics
Which of the following is an example of a Database-System Application?
Word Processor
Web Browser
Inventory Management System
Photo Editing Software
What is the main advantage of using a relational database?
Faster data entry
Improved data security
Reduced data redundancy
Easier data visualization
In the context of a database, what is a "view"?
A graphical representation of data
A virtual table based on the result of a SELECT query
A data input form
A backup copy of the database
Which database language is commonly used for querying relational databases?
HTML
CSS
SQL
Java
What is the purpose of the database design phase?
Enter data into the database
Create a backup of the database
Organize and structure data for efficient storage and retrieval
Delete unnecessary records from the database
What is the role of transaction management in a database system?
Manage user authentication
Ensure data consistency and integrity
Design database tables
Optimize query performance
Data mining is primarily concerned with:
Storing and retrieving data
Analyzing and discovering patterns in large datasets
Creating graphical representations of data
Securing data from unauthorized access
What is the function of a Database Administrator (DBA)?
Develop software applications
Design database tables
Manage and maintain the database system
Write SQL queries
Which of the following is a key component of database architecture?
Keyboard
Monitor
Storage device
Database server
What is the history of the first commercially available relational database management system (RDBMS)?
Oracle
MySQL
IBM DB2
Microsoft SQL Server
What term is used to describe the users who interact with the database without directly dealing with its internal structure?
Database Administrators
End Users
Developers
System Analysts
What is the purpose of normalization in database design?
Increase data redundancy
Improve data integrity
Slow down data retrieval
Decrease database security
Which database language is used for defining and manipulating the structure of the database?
SQL
Java
C++
Python
In the context of a database, what is ACID?
A chemical compound
A set of properties that guarantee database transactions are processed reliably
A database programming language
A data visualization tool
What is the purpose of a data warehouse?
Store data for day-to-day operations
Support decision-making processes by providing a consolidated view of historical data
Manage data access permissions
Perform real-time data analysis
Which of the following is NOT a type of database architecture?
Client-Server
Hierarchical
Flat-file
Parallel
What is the primary goal of data storage in a database system?
Minimize data redundancy
Maximize data security
Minimize query performance
Maximize data entry speed
What is the main function of a query language in a database system?
Define the structure of the database
Insert new records into the database
Retrieve and manipulate data
Delete the entire database
Which of the following is an example of a non-relational database?
MySQL
MongoDB
PostgreSQL
Oracle
