STRUCTURED QUERY LANGUAGE (SQL) EXAMINATION QUESTIONS AND CORRECT ANSWER WITH EXPLANATION GRADED A+ STUDY GUIDE

STRUCTURED QUERY LANGUAGE (SQL) EXAMINATION
QUESTIONS AND CORRECT ANSWER WITH
EXPLANATION GRADED A+ STUDY GUIDE SOUTHERN
NEW HAMPSHIRE UNIVERSITY
1. SQL stands for:
A. Structured Query Language
B. System Query Logic
C. Simple Question Language
D. Sequential Query Level
Answer: A
Rationale: SQL is Structured Query Language.

2. SQL is used to:
A. Manage databases
B. Design hardware
C. Build operating systems
D. Create images
Answer: A
Rationale: SQL manages relational databases.

3. SQL is classified as:
A. Declarative language
B. Machine language
C. Assembly language
D. Low-level language
Answer: A
Rationale: It specifies what to do, not how.

4. SQL works mainly with:
A. Relational databases
B. Operating systems
C. Graphics software
D. Networks only
Answer: A
Rationale: SQL is for relational DBMS.

,5. A table in SQL is also called:
A. Relation
B. File system
C. Object
D. Program
Answer: A
Rationale: Table = relation.

6. A row in SQL table is:
A. Tuple
B. Attribute
C. Column
D. Schema
Answer: A
Rationale: Row = record.

7. A column in SQL table is:
A. Attribute
B. Tuple
C. Record
D. Index
Answer: A
Rationale: Column = field.

8. Primary key is used to:
A. Uniquely identify records
B. Duplicate records
C. Sort data only
D. Delete tables
Answer: A
Rationale: Ensures uniqueness.

9. Foreign key is used to:
A. Link tables
B. Delete tables
C. Create database
D. Encrypt data
Answer: A
Rationale: Establish relationships.

, 10. SQL SELECT command is used to:
A. Retrieve data
B. Insert data
C. Delete database
D. Create OS
Answer: A
Rationale: Data retrieval.

11. INSERT command is used to:
A. Add new records
B. Delete records
C. Update OS
D. Create index
Answer: A
Rationale: Inserts data.

12. UPDATE command is used to:
A. Modify existing data
B. Delete database
C. Create table
D. Drop schema
Answer: A
Rationale: Changes data.

13. DELETE command is used to:
A. Remove records
B. Add records
C. Retrieve data
D. Backup data
Answer: A
Rationale: Deletes rows.

14. CREATE command is used to:
A. Create database objects
B. Delete tables
C. Update records
D. Retrieve data
Answer: A
Rationale: Defines structure.