Blog

In a database that has data for current projects in an organization, there is a table ProjectLeads with data on project leaders and another table Projects, with data on all current projects (Please see a few sample rows from each of these tables below). A project leader can lead multiple projects at the same time, but a project has only one leader. Each project is owned by a department and one department can have multiple projects, thereby multiple leaders. You are asked to get the department wise total salary paid to all project leaders. Which of the following queries will get you the accurate values for the total salary paid by each department across all their project leaders. The result should have the Department and the Total Salary. ProjectLeads   Projects (Hint: Remember this is a one to many join and the Salary is on the one side)  A.   B.   C. 

For the clients with difficulty swallowing medications, it is appropriate to do which of the following?

Doctor orders cefaclor (Ceclor) 500 mg q. 8 h x 10 days.  How many tablets should be delivered from the pharmacy for the entire course of treatment?

 For the Z-track technique of injection, the tissue is supported by:

Anticoagulants are given to:

Which of the following classification of drugs is used to induce vomiting?

Glyburide (Diabeta) is an oral:

The chief effect upon the hear with the use of Digalen, digitoxin, digoxin, and other digitalis preparations is to:

Which of the following is true regarding prednisone (Delasone) administration?

The physicians’ orders meperidine (Demerol) 35 mg.  The container label reads Demerol 50 mg/ml.  What will you give?