Quiz

data

John Robinson 6 questions

Take the quiz

Questions in this quiz (6)

1You use DDL to create, modify, and delete the ___________________________ of a database.
1. Aobjects
2. Ba
2The CREATE DATABASE statement creates two files on the hard drive of the server: a data file and a/an _______________________________________ file.
1. Alog
2. Bmap
3When you use the CREATE TABLE statement to create a table, you can also define the attributes and _________________________ for the columns of the table.
1. Aconstraints
2. Bo
4Unless you specify otherwise, the CREATE INDEX statement creates a/an ______________________________ index for the specified column or columns.
1. Anonclustered
2. Ba
5An index can improve performance when SQL Server does a/an _________________ or a join based on a specific value in the indexed column.
1. Asearch
2. Ba
6A _____________ is a type of nonclustered index that includes a WHERE clause.
1. Afiltered index
2. Bf