SDF Q4 U5

A stored procedure is a saved _____________ and can accept both input and output parameters.

• link

• query

• selection

• function

____________ are values that pass through a query.

• Parameters

• Functions

• Links

• Keys

@EmployeeID int,

@DepartmentID int output

• these are queries

• these are functions

• these are linked lists

• these are parameters

Which of the below is an input?

@EmployeeID int,

@DepartmentID int output

• @EmployeeID int

• @DepartmentID int outpu

• these are linked lists

• these are parameters

Which of the following will select everything from the table?

• SELECT ()

• SELECT *

• SELECT

• SELECT ALL

When we do an UPDATE using SQL, we are always updating __________________.

• a field, not a table

• a column

• a table, not a field

• a row of data

_____________ covers SQL keywords such as SELECT and UPDATE.

• DML

• DDL

_____________ deals more with the structure itself, using keywords such as CREATE, ALTER, and DROP.

• DML

• DDL

___________ keyword drops objects from a database.

• Remove

• Drop

• Store

• Delete

If you run a DROP statement, the data from that table will be permanently deleted if you run it.

• True

• False