Category: Uncategorized

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?

Fill in the blank… The three main hardware components of a client/server system are the clients, the server, and the ___________.

Choose the best answer… Which of the following statements regarding CHAR and NCHAR data types is false?

Create a Database… Write a SQL statement to make a new database named:   ASU_DB Also, make sure you end the batch.

Choose the best answer… Which of the following diagrams best represents the relationship between a table of customers and a table of orders placed by customers?   A   B   C   D

Choose the best answer… Which of the following statements is true about CONVERT and TRY_CONVERT functions?