STRUCTURED QUERY LANGUAGE (SQL) EXAMINATION
QUESTIONS AND CORRECT ANSWER WITH
EXPLANATION GRADED A+ STUDY GUIDE SOUTHERN
NEW HAMPSHIRE UNIVERSITY
1. SQL stands for:
A. Simple Query Language
B. Structured Query Language
C. Standard Query Logic
D. Sequential Query Language
Answer: B
Rationale: SQL is the standard language for relational databases.
2. SQL is mainly used for:
A. Graphic design
B. Managing and querying databases
C. Networking
D. Operating systems
Answer: B
Rationale: SQL handles database operations.
3. The command used to retrieve data is:
A. INSERT
B. SELECT
C. UPDATE
D. DELETE
Answer: B
Rationale: SELECT is used for querying data.
4. The command used to add data is:
A. INSERT
B. SELECT
C. DROP
D. ALTER
Answer: A
Rationale: INSERT adds new records.
,5. The command used to modify data is:
A. UPDATE
B. SELECT
C. CREATE
D. DROP
Answer: A
Rationale: UPDATE changes existing data.
6. The command used to remove data is:
A. DELETE
B. SELECT
C. INSERT
D. CREATE
Answer: A
Rationale: DELETE removes records.
7. CREATE TABLE is used to:
A. Delete table
B. Create a new table
C. Update table
D. Query table
Answer: B
Rationale: Defines a new table structure.
8. DROP TABLE is used to:
A. Remove table permanently
B. Add table
C. Update table
D. View table
Answer: A
Rationale: Deletes table completely.
9. ALTER TABLE is used to:
A. Delete database
B. Modify table structure
C. Query data
D. Insert data
Answer: B
Rationale: Changes table design.
, 10. TRUNCATE removes:
A. Database
B. All rows in a table
C. Only one row
D. Columns only
Answer: B
Rationale: Deletes all records quickly.
11. WHERE clause is used to:
A. Sort data
B. Filter records
C. Join tables
D. Create tables
Answer: B
Rationale: Applies conditions.
12. ORDER BY is used to:
A. Filter data
B. Sort results
C. Delete data
D. Insert data
Answer: B
Rationale: Sorts query output.
13. GROUP BY is used to:
A. Delete groups
B. Aggregate data
C. Insert records
D. Join tables
Answer: B
Rationale: Groups rows for aggregation.
14. HAVING clause is used to:
A. Filter groups
B. Filter tables
C. Create tables
D. Insert data
Answer: A
Rationale: Filters grouped results.
QUESTIONS AND CORRECT ANSWER WITH
EXPLANATION GRADED A+ STUDY GUIDE SOUTHERN
NEW HAMPSHIRE UNIVERSITY
1. SQL stands for:
A. Simple Query Language
B. Structured Query Language
C. Standard Query Logic
D. Sequential Query Language
Answer: B
Rationale: SQL is the standard language for relational databases.
2. SQL is mainly used for:
A. Graphic design
B. Managing and querying databases
C. Networking
D. Operating systems
Answer: B
Rationale: SQL handles database operations.
3. The command used to retrieve data is:
A. INSERT
B. SELECT
C. UPDATE
D. DELETE
Answer: B
Rationale: SELECT is used for querying data.
4. The command used to add data is:
A. INSERT
B. SELECT
C. DROP
D. ALTER
Answer: A
Rationale: INSERT adds new records.
,5. The command used to modify data is:
A. UPDATE
B. SELECT
C. CREATE
D. DROP
Answer: A
Rationale: UPDATE changes existing data.
6. The command used to remove data is:
A. DELETE
B. SELECT
C. INSERT
D. CREATE
Answer: A
Rationale: DELETE removes records.
7. CREATE TABLE is used to:
A. Delete table
B. Create a new table
C. Update table
D. Query table
Answer: B
Rationale: Defines a new table structure.
8. DROP TABLE is used to:
A. Remove table permanently
B. Add table
C. Update table
D. View table
Answer: A
Rationale: Deletes table completely.
9. ALTER TABLE is used to:
A. Delete database
B. Modify table structure
C. Query data
D. Insert data
Answer: B
Rationale: Changes table design.
, 10. TRUNCATE removes:
A. Database
B. All rows in a table
C. Only one row
D. Columns only
Answer: B
Rationale: Deletes all records quickly.
11. WHERE clause is used to:
A. Sort data
B. Filter records
C. Join tables
D. Create tables
Answer: B
Rationale: Applies conditions.
12. ORDER BY is used to:
A. Filter data
B. Sort results
C. Delete data
D. Insert data
Answer: B
Rationale: Sorts query output.
13. GROUP BY is used to:
A. Delete groups
B. Aggregate data
C. Insert records
D. Join tables
Answer: B
Rationale: Groups rows for aggregation.
14. HAVING clause is used to:
A. Filter groups
B. Filter tables
C. Create tables
D. Insert data
Answer: A
Rationale: Filters grouped results.
