SQL DATABASE EXAMINATION QUESTIONS AND CORRECT ANSWER WITH EXPLANATION GRADED A+ STUDY GUIDE

SQL DATABASE EXAMINATION QUESTIONS AND
CORRECT ANSWER WITH EXPLANATION GRADED A+
STUDY GUIDE SOUTHERN NEW HAMPSHIRE UNIVERSITY

1. SQL stands for:

A. Structured Query Language
B. Simple Query Language
C. Standard Question Language
D. Sequential Query Logic
Answer: A
Rationale: SQL is used to manage relational databases.



2. SQL is mainly used for:

A. Managing databases
B. Designing hardware
C. Web browsing
D. Graphic design
Answer: A
Rationale: SQL handles data storage and retrieval.



3. A database is:

A. Organized collection of data
B. A programming language
C. A file system only
D. A hardware device
Answer: A
Rationale: Structured data storage system.



4. DBMS stands for:

,A. Database Management System
B. Data Binary Model System
C. Digital Backup Management System
D. Data Block Management System
Answer: A
Rationale: Software to manage databases.



5. A table in SQL is:

A. Collection of rows and columns
B. A file folder
C. A program
D. A server
Answer: A
Rationale: Basic database structure.



6. A row in a table is also called:

A. Record
B. Column
C. Field
D. Query
Answer: A
Rationale: One entry in a table.



7. A column is also called:

A. Field
B. Record
C. Table
D. Query
Answer: A
Rationale: Attribute of data.



8. Primary key is used to:

, A. Uniquely identify records
B. Sort data
C. Encrypt data
D. Delete data
Answer: A
Rationale: Ensures uniqueness.



9. Foreign key is used to:

A. Link tables
B. Delete tables
C. Encrypt tables
D. Sort tables
Answer: A
Rationale: Establish relationships.



10. SQL SELECT statement is used to:

A. Retrieve data
B. Delete data
C. Update data
D. Create database
Answer: A
Rationale: Query data retrieval.



11. SELECT * means:

A. Select all columns
B. Select one column
C. Delete all rows
D. Update all data
Answer: A
Rationale: Wildcard selection.



12. WHERE clause is used to: