NSCT – Databases for Web Applications MCQs 20 min Score: 0 Attempted: 0/20 Subscribe 1. . A database is: (A) A JavaScript function (B) Only a web page (C) A CSS file (D) An organized collection of data that can be stored, retrieved, and managed efficientlyShow All Answers 2. . Common types of databases include: (A) Relational (SQL) and Non-relational (NoSQL) (B) HTML and CSS (C) JavaScript and Python (D) Apache and Nginx 3. . Popular relational databases include: (A) HTML, CSS, JavaScript (B) MongoDB, Firebase (C) MySQL, PostgreSQL, Oracle, SQL Server (D) React, Angular, Vue 4. . Popular NoSQL databases include: (A) MongoDB, Firebase, CouchDB, Cassandra (B) MySQL, PostgreSQL (C) HTML, CSS (D) Node.js only 5. . SQL stands for: (A) Simple Query Language (B) Structured Query Language (C) Server Query Language (D) Script Query Language 6. . A primary key in a database table: (A) Optimizes CPU (B) Styles an HTML element (C) Creates CSS grids (D) Uniquely identifies each record in a table 7. . A foreign key in a database table: (A) Establishes a relationship between two tables (B) Styles HTML elements (C) Structures CSS (D) Optimizes CPU only 8. . CRUD operations in databases include: (A) Copy, Run, Upload, Download (B) Create, Read, Update, Delete (C) Compile, Run, Upload, Debug (D) Connect, Retrieve, Update, Delete 9. . The SELECT SQL statement is used to: (A) Insert data (B) Retrieve data from a database (C) Update data (D) Delete data 10. . The INSERT SQL statement is used to: (A) Delete data (B) Retrieve data (C) Add new records to a table (D) Update data 11. . The UPDATE SQL statement is used to: (A) Modify existing records in a table (B) Add new records (C) Delete records (D) Retrieve data 12. . The DELETE SQL statement is used to: (A) Retrieve data (B) Add records (C) Remove records from a table (D) Modify records 13. . Database normalization is used to: (A) Improve CPU usage only (B) Style HTML (C) Optimize CSS (D) Organize data to reduce redundancy and improve integrity 14. . Denormalization in databases is used to: (A) Improve performance by reducing joins at the cost of some redundancy (B) Reduce CSS size (C) Structure HTML (D) Optimize CPU only 15. . An index in a database is used to: (A) Structure HTML (B) Style web pages (C) Speed up data retrieval operations (D) Optimize CPU only 16. . ACID properties in databases stand for: (A) Atomicity, Connection, Index, Data (B) Access, Connect, Insert, Delete (C) Atomicity, Consistency, Isolation, Durability (D) None of the above 17. . NoSQL databases are preferred for: (A) Structuring CSS (B) Styling HTML elements (C) Large-scale, unstructured, or rapidly changing data (D) Optimizing CPU only 18. . SQL joins are used to: (A) Combine data from two or more tables based on a related column (B) Style web pages (C) Optimize CPU only (D) Create CSS grids 19. . Types of SQL joins include: (A) HTML JOIN only (B) INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN (C) CSS JOIN only (D) JavaScript JOIN only 20. . The ultimate goal of databases for web applications is: (A) Optimize CPU only (B) Style web pages (C) Structure HTML only (D) Store, manage, and retrieve application data efficiently and securely
