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. Simple Query Language
C. Standard Question List
D. Sequential Query Logic
Answer: A
Rationale: SQL is the standard language for relational databases.



2. SQL is mainly used to:

A. Manage and query databases
B. Design hardware
C. Create operating systems
D. Build networks
Answer: A
Rationale: SQL interacts with relational databases.



3. A database is a:

A. Organized collection of data
B. Random file system
C. Hardware device
D. Programming language
Answer: A
Rationale: Databases store structured data.



4. A table in SQL consists of:

,A. Rows and columns
B. Files and folders
C. Programs and scripts
D. Networks and nodes
Answer: A
Rationale: Tables are structured data sets.



5. A row in a table is also called:

A. Record
B. Field
C. Column
D. Query
Answer: A
Rationale: A single data entry.



6. A column in a table is called:

A. Field
B. Record
C. Query
D. Table
Answer: A
Rationale: Represents attribute values.



7. Primary key is used to:

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



8. Foreign key is used to:

, A. Link two tables
B. Delete data
C. Encrypt data
D. Sort data
Answer: A
Rationale: Establishes relationships.



9. SQL command SELECT is used to:

A. Retrieve data
B. Delete data
C. Insert data
D. Update structure
Answer: A
Rationale: Queries data.



10. INSERT command is used to:

A. Add new records
B. Delete records
C. Update structure
D. Drop table
Answer: A
Rationale: Adds data to table.



11. UPDATE command is used to:

A. Modify existing data
B. Delete tables
C. Create tables
D. Retrieve data
Answer: A
Rationale: Changes records.



12. DELETE command is used to: