 A composite primary key occurs when you define more than one column as your primary key.
 A char string can be up to 8,000 characters long.
 By definition, a primary key must be unique and must have a value (which is not null).
 How can you prevent the accidental loss of an entire table? Referential integrity
 How many bytes does a single character take up if it is a varchar that supports English and most European languages? 1 byte
 How many bytes does the int data type take up? 4 bytes
 How many bytes does the money data type take up? 8 bytes
 How many clustered indexes can you have for a table? 1
 How many non-clustered indexes can you have? 999
 If you define a primary key, what level have you reached? 1NF
 What are previously written SQL statements that have been stored within a database? Stored procedures
 What are the two types of indexes? Clustered and non-clustered
 What clause is used to combine related data from multiple table sources? JOIN
 What clause would you use with the SELECT command that would pull records based on a range? BETWEEN
 What command do you use to perform a query in SQL? SELECT
 What command is used to execute a stored procedure? exec
 What command would you use to delete a table while leaving the table structure in place for future use? TRUNCATE TABLE
 What common data type is used to store decimal numbers such as 3.14 and 7.07? Float
 What common data type would be used to count objects? integer
 What data type should you use to support Japanese or Arabic text? nvarchar
 What do you call the elimination of redundant data? Normalization
 What do you perform when you want to recall specific records from a database? query
 What does VARCHAR(25) represent? You can store up to 25 variable characters.
 What is a type of attack in which malicious code is inserted into strings that are passed