Database Domain #4 Lesson 1 Quiz

University:
American Baptist College
Course:
CIT370 | Database Design and Processing
Academic year:

2024
Views:

252

Pages:

1
Author:

Muthia M.

Fillin the Blanks 1. When working with queries, one can insert _____ into an entity. [INSERT INTO… SELECT] Answer: DATA 2. An INSERT INTO statement with a SELECT statement will copy records from one table to an _____ table. [INSERT INTO…SELECT] Answer: EXISTING 3. To insert values into a table, one does not use a _____ statement. [INSERT INTO… VALUES] Answer: SELECT 4. The columns that will receive data are put in _____. [INSERT INTO…VALUES] Answer: PARENTHESES 5. The _____ statement defines the column and value to be updated within an update statement. [Update Data in a Single Table] Answer: SET 6. The _____ clause in an UPDATE statement defines what is being updated. [Update Data in a Single Table] Answer: WHERE 7. The DELETE keyword does not delete an object such as a _____. [Delete Data from a Single Table] Answer: TABLE 8. Before running a DELETE statement, one should run a _____ statement on the table to be changed. [Delete Data from a Single Table] Answer: SELECT 9. The TRUNCATE TABLE statement _____ a table. [Truncate Table] Answer: ALL RECORDS FROM