DBMS 1

SQL stands for...?

Which SQL statement is used to remove a table from the database?

• DELETE

• DROP

• REMOVE

• TRUNCATE

What is the purpose of the GROUP BY clause in an SQL SELECT statement?

• • To specify which columns to retrieve

• To specify conditions for selecting rows

• To order the result set

• To group rows based on a specified column

Which SQL function is used to concatenate two or more strings?

• CONCATENATE()

• SUBSTRING()

• CONCAT()

• STRING()

Which of the following is NOT a component of an E-R Diagram (ERD)?

• Entity

• Attribute

• Table

• Relationship

ERD stands for...?

CRUD stands for...?

Which SQL statement is used to add a new record to a database?

• ADD

• CREATE

• UPDATE

• INSERT

Which SQL statement is used to update existing records in a table?

• ADD

• CREATE

• UPDATE

• INSERT

What does the SQL function MAX() do?

• Finds the average value of a column

• Retrieves the maximum value from a column

• Counts the number of rows in a column

• Deletes duplicate rows from a table