It is a busy day at the pharmacy and the technician is running behind at Drop off. She is having troubles reading a doctor’s handwriting and does not call to verify the prescription. The wrong drug was selected. What error has happened? Select one:

A child resistant container is defined as one that cannot be opened by _____ of children but can be opened by _____ of adults. Select one:

For water based oral formulations the BUD is _______________ when stored at controlled cold temperatures. Select one:

When a technician receives an order a process known as ____________ allows the technician to update the stock to reflect any changes received in the shipment. Select one:

Which of the following mechanisms restricts gene expression (i.e. transcription) to only one of the two copies in a diploid organism ?

The next six (6) questions use the Adventure database shown below and sample data appropriately dispersed throughout the questions. For each question you have to select a single best answer.

The window function in the SQL code does which of the following?

Which of the following completes the CREATE TABLE statement for the Trade table? CREATE TABLE Trade (   TradeNo CHAR(4),   CustNo  _______,   EmpNo   _______,   AssetNo CHAR(2) NOT NULL,   Qty     INTEGER,   Price   DOUBLE,   TDate   DATE NOT NULL   Type    VARCHAR(10) NOT NULL,   Status  VARCHAR(10) NOT NULL,   CONSTRAINT PKTrade PRIMARY KEY (TradeNo)   CONSTRAINT FKCustomer FOREIGN KEY (CustNo) REFERENCES Customer (CustNo)   CONSTRAINT FKAsset FOREIGN KEY (AssetNo) REFERENCES _____ (AssetNo)   CONSTRAINT FKEmployee FOREIGN KEY (____) REFERENCES Employee (____))

Which of the following queries will show customer names and the number of bookings for customers with at least 2 bookings?    

The foreign key(s) that can accept null values without violating referential integrity is (are)