DBMS Finals

A request made to a database to retrieve or manipulate data using SQL is called __.

SQL Query

The SQL command to remove records from a database is __.

DELETE

A SQL query nested inside another query is known as a __.

Subquery

A subquery that returns only one row is called a __ subquery.

Single-row

To find employees in a specific department using subqueries, you would use __ in the WHERE clause.

IN

The command used to create a virtual table in SQL is __.

CREATE VIEW

A stored procedure is a named collection of SQL statements that you can __ and reuse.

call

To update an existing view, you can use the command __.

CREATE OR REPLACE VIEW

If you want to drop a stored procedure named TopCustomers, the command is __.

DROP PROCEDURE IF EXISTS TopCustomers.

To call a stored procedure, you would use the command __ followed by the procedure name.

CALL