314 REVIEW EXAM

A command that is used to modify the existing records in a table.

A student with ID = 2 transferred schools. You need to remove only that record from the STUDENT table. Which SQL statement is correct?

• DELETE FROM STUDENT WHERE ID = 2;

• DROP FROM STUDENT WHERE ID = 2;

• DELETE STUDENT WHERE ID = 2;

• DELETE FROM STUDENT ID = 2;

It is used to specify a condition while fetching the data from a single table or by joining multiple tables.

A significant feature of CRUD operations is that they enable application scalability and allow developers to efficiently handle large volumes of data.

The _________ command is used to completely delete a database and all of its objects, such as tables, indexes, views and other dependent objects.

It is a set of SQL commands to manage database security and control user access to database objects.

It refers to the set of SQL commands that can create and manipulate the structures of a database.

To simplify complex queries involving joins, you can break the query into manageable pieces by using _______ or temporary tables.

A command that is used to remove the existing records from a table.

It has a set of commands that is used to perform queries on the data and find information.