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 efficiently
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