Author: Anonymous

Choose the best answer… Which of the following casts a decimal column named InvoiceAmount to the VARCHAR type?

Choose the best answer… Which data type is only used to store whole numbers?

The following is a formula for 200 triple estrogen capsules. Calculate the quantity of Estradiol (in grams ) required to prepare 10,000 such capsules. Estriol                                           400mgEstron                                           50 mgEstradiol                                       50 mgPolyethylene glycol 1450           40 gPolyethylene glycol 3350           40 g

Change Databases… Write a SQL statement that changes the current database from  UofA_DB  to  ASU_DB Also, make sure you end the batch.

Dopamine hydrochloride injection is available in 5-mL ampules containing 40mg of dopamine hydrochloride per milliliter. The injection must be diluted before administration. If a physician wishes to use sodium chloride injection as the diluent and wants a dilution containing 0.8% w/v of dopamine hydrochloride, how much sodium chloride injection (in milliliters) should be added to 5 mL of the injection?

Fill in the blank… A relational database consists of one or more _______?

How much U-100 insulin zinc suspension (in milliliters) should be used to obtain 15 units of insulin?

Choose the best answer… In SSMS, what tool would you use to modify a column in a table if you do not want to script a statement?

–SECTION 2– This section contains 2 questions, each worth 5 points. The questions are meant to test your basic SQL abilities (simple DDL statements, establishing or changing underlying data structures, expected results/output, etc.). You must write your responses in the boxes provided.

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