NSCT – Introduction to Database Systems MCQs 20 min Score: 0 Attempted: 0/20 Subscribe 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 deviceShow All Answers 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
