DBA CA 2

What does DDL stand for in SQL?

• Data Distribution Language

• Data Development Language

• Data Description Language

• Data Definition Language

Which command is used to delete all rows from a table without logging individual row deletions?

• TRUNCATE TABLE

• REMOVE TABLE

• DELETE

• DROP TABLE

What is the purpose of the COMMIT command in SQL?

• To create a new table

• To save changes permanently

• To undo changes

• To modify existing data

Which SQL command is used to retrieve data from a database?

• SELECT

• UPDATE

• INSERT

• DELETE

What is a primary key in a database?

• A key that allows duplicate values

• A unique identifier for a record

• A key used for foreign key relationships

• A key that can be null

Which of the following is NOT a type of SQL JOIN?

• INNER JOIN

• CROSS JOIN

• LEFT JOINER

• OUTER JOIN

What does the acronym TCL stand for in SQL?

• Table Control Language

• Table Command Language

• Transaction Control Language

• Transaction Command Language

Which SQL command is used to modify existing records in a table?

• ALTER

• CHANGE

• MODIFY

• UPDATE

What is the purpose of the GRANT command in SQL?

• To revoke permissions

• To provide access rights to users

• To create a new user

• To delete a user

Which of the following is a valid SQL function for string manipulation?

• AVG

• SUM

• COUNT

• CONCAT