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 AnswersShow All Answers 2. . DBMS stands for: (A) Data Backup Management System (B) Database Management System (C) Digital Binary Memory System (D) Data Block Monitoring SystemShow All Answers 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, DecimalShow All Answers 4. . SQL is used for: (A) Encrypting data (B) Querying and managing relational databases (C) Compressing files (D) Designing hardwareShow All Answers 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 fileShow All Answers 6. . Foreign Key is used to: (A) Compress tables (B) Encrypt data (C) Establish a link between two tables (D) Delete records automaticallyShow All Answers 7. . Normalization in databases helps to: (A) Delete old data (B) Reduce redundancy and improve data integrity (C) Increase storage only (D) Compress filesShow All Answers 8. . Denormalization is done to: (A) Compress tables (B) Delete redundant data (C) Encrypt data (D) Improve query performance by reducing joinsShow All Answers 9. . A relational database stores data in: (A) Networks (B) Files only (C) Tables with rows and columns (D) Hardware devicesShow All Answers 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, DeleteShow All Answers 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 automaticallyShow All Answers 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 increasesShow All Answers 13. . Indexing in databases is used to: (A) Compress tables (B) Encrypt files (C) Improve query performance (D) Delete old recordsShow All Answers 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 keyShow All Answers 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 tablesShow All Answers 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 ProcessShow All Answers 17. . OLAP is used for: (A) Analytical processing on large datasets for decision-making (B) Encrypting tables (C) Compressing data (D) Deleting old filesShow All Answers 18. . NoSQL databases are designed to: (A) Delete records automatically (B) Encrypt relational data (C) Compress tables (D) Handle unstructured or semi-structured dataShow All Answers 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 deletedShow All Answers 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 onlyShow All Answers
