Complete the following sentences by writing the correct word or words in the blanks provided.
1. Database objects are divided into two categories: __________________ and __________________. 2. Tables created using the __________________ statement are used to store data. 3. Constraints can define entity relationships between tables on a continual basis. They are also referred to as __________________constraints. 4. In order to use the views object to view a data set, you must use the __________________Transact-SQL statement to show data from underlying tables. 5. DDL influences __________________, whereas __________________ influences actual data stored in tables.
6. __________________are compiled Transact-SQL statements meant to perform particular actions and can accept parameters and return values, but functions always return a value and they never update data. 7. The core DDL statements are __________________ , _________________ and __________________. 8. The core DML statements are __________________ , __________________ , __________________ and __________________ 9. System views belong to __________________. 10. The FOREIGN KEY constraint is a __________________ identifier.
Circle the letter that corresponds to the best answer. 1. Which of the following is not a DDL statement? a. CREATE b. MERGE c. ALTER d. DROP 2. Which of the following is not a column constraint? a. DEFAULT b. CHECK c. RANGE d. UNIQUE 3. Which of the following can be used to improve query performance? a. PRIMARY KEY b. UNIQUE index c. CLUSTERED index d. all of the above 4. Which of the following is not a DML statement? a. REMOVE b. INSERT c. DELETE d. TRUNCATE 5. Select all the statements that are true: a. Indexes should only be created on