Author: Anonymous

Choose the best answer… Which of the following is unlikely to be part of a client/server system that exclusively uses SQL Server?

TRUE or FALSE… If you define a column as an identity column then a number is generated for that column whenever a row is added to the table.

Choose the best answer… What enforces referential integrity between tables?

–SECTION 3– This section contains 3 questions, in total are worth 45 points. They are related to each other. The questions are meant to test your basic SQL abilities (advanced DDL statements and understanding underlying data structures given set of business requirements). You must write your responses in the boxes provided.

Choose the best answer… Which of the following statements is true?

Fill in the blank… In SSMS, if a statement returns data, that data is displayed in the ___________ tab (or window).

Include a new column in a table… You were tasked with updating an existing table called InvoiceLineItems to include a new column that allows Purchasing Specialists in the Finance department to track the number of each item that was purchased. If a receipt does not have the number of an item purchased, they want it to default to a count of one and therefore it cannot be less than a count of one. Write a SQL statement that includes this new column and supports the end result the Purchasing Specialist is looking for. Choose the appropriate data types and column conditions (HINT: You will need more than one constraint).

Choose the best answer… By default, what kind of index does the CREATE INDEX statement make?

Select all that apply… Which of the following values can be stored in a column that is defined as DECIMAL(6,2)?

Select all that apply… Which data types should you use to store a sub-total spent on a grocery receipt?