Database Design Questionnaire

QUESTION 1

1. If InvoiceTotal contains a value of 250.00, what will the Solution column contain when this code is executed?
   CASE
   WHEN InvoiceTotal > 500
   THEN InvoiceTotal – ROUND(InvoiceTotal * .20, 2)
   WHEN InvoiceTotal >= 250
   THEN InvoiceTotal – ROUND(InvoiceTotal * .10, 2)
   ELSE
   0
   END AS Solution
2. a.225.00
3. b.0
4. c.200.00
5. d.25

QUESTION 2

1. When you identify a column as the primary key, the column
2. a.has a clustered index created automatically for the column
3. b.is forced to contain a unique value for each row
4. c.is forced to be NOT NULL
5. d.all of the above

QUESTION 3

1. Which system function can you use to return the value of the most recently assigned identity column?a.@[removed]@[removed]@[removed]@@IDENTITY

2 points 

QUESTION 4

1. What do you use to uniquely identify each row in a table?a.
2. a primary key
3. b.a skeleton key
4. c.a foreign key
5. d.an index

QUESTION 5

1. The first character of a regular identifier can bea.
2. a letter as defined by the Unicode Standard 3.2
3. b.an underscore (_)
4. c.an at sign [removed] of the above