1. . A database is:
(A) A collection of organized data that can be easily accessed, managed, and updated
(B) A set of programs
(C) A type of software virus
(D) A hardware device
2. . DBMS stands for:
(A) Data Backup Management System
(B) Database Management System
(C) Digital Binary Memory System
(D) Data Block Monitoring System
3. . Which of the following is a type of database model?
(A) Hierarchical, Network, Relational, Object-oriented
(B) Linear, Circular, Triangular
(C) TCP/IP, HTTP, FTP
(D) Binary, Hexadecimal, Decimal
4. . SQL is used for:
(A) Encrypting data
(B) Querying and managing relational databases
(C) Compressing files
(D) Designing hardware
5. . Primary Key in a table is:
(A) A unique identifier for each record
(B) A password for the database
(C) A backup key
(D) A compressed file
6. . Foreign Key is used to:
(A) Compress tables
(B) Encrypt data
(C) Establish a link between two tables
(D) Delete records automatically
7. . Normalization in databases helps to:
(A) Delete old data
(B) Reduce redundancy and improve data integrity
(C) Increase storage only
(D) Compress files
8. . Denormalization is done to:
(A) Compress tables
(B) Delete redundant data
(C) Encrypt data
(D) Improve query performance by reducing joins
9. . A relational database stores data in:
(A) Networks
(B) Files only
(C) Tables with rows and columns
(D) Hardware devices
10. . ACID properties of a database include:
(A) Atomicity, Consistency, Isolation, Durability
(B) Accuracy, Compression, Indexing, Data
(C) Access, Control, Integrity, Deployment
(D) Analyze, Create, Insert, Delete
11. . Transaction in a database is:
(A) Encrypting a table
(B) A sequence of operations performed as a single logical unit
(C) Compressing logs
(D) Deleting old records automatically
12. . Data integrity ensures:
(A) Files are compressed
(B) Data is deleted automatically
(C) Accuracy and consistency of data over its lifecycle
(D) Database speed increases
13. . Indexing in databases is used to:
(A) Compress tables
(B) Encrypt files
(C) Improve query performance
(D) Delete old records
14. . A view in SQL is:
(A) A virtual table based on a query
(B) A physical backup of a table
(C) A compressed version of a table
(D) A foreign key
15. . Data warehouse is used for:
(A) Deleting old data
(B) Encrypting database files
(C) Storing and analyzing large amounts of historical data
(D) Compressing tables
16. . OLTP stands for:
(A) Online Transaction Processing, used for managing day-to-day transactional data
(B) Offline Table Linking Protocol
(C) Object Layer Transfer Protocol
(D) Online Table Logging Process
17. . OLAP is used for:
(A) Analytical processing on large datasets for decision-making
(B) Encrypting tables
(C) Compressing data
(D) Deleting old files
18. . NoSQL databases are designed to:
(A) Delete records automatically
(B) Encrypt relational data
(C) Compress tables
(D) Handle unstructured or semi-structured data
19. . Backup and recovery in databases ensure:
(A) Database speed is increased
(B) Files are compressed automatically
(C) Data is safe and can be restored in case of failure
(D) Old records are deleted
20. . The main goal of Database Systems is to:
(A) Delete old files automatically
(B) Store, manage, and retrieve data efficiently while maintaining integrity and security
(C) Compress logs
(D) Increase CPU speed only