Blog

****BONUS****   What will you take away from this class that you can apply to your career?

A nurse is preparing to administer amoxicillin 30 mg/kg/day divided equally every 12 hr to a toddler who weighs 33 lbs. Available is amoxicillin 200 mg/5 mL suspension. How many mL should the nurse administer per dose? (Round the answer to the nearest tenth)

A 27-year-old male with a T4 spinal cord injury presents to the emergency department with a sudden onset of pounding headache, facial flushing, and a blood pressure of 198/110 mmHg. He appears anxious and diaphoretic above the level of injury, and reports feeling “strange.” He is currently using an indwelling urinary catheter. Clinical Findings: Heart rate: 54 bpm Respirations: 16/min Temperature: 98.9°F (37.2°C) Skin: Flushed upper body, cool lower extremities Urinary catheter tubing appears kinked Bowel sounds present, abdomen slightly distended Select all the actions the nurse should take

The RAISE statement is used to trigger an exception manually.

PL/SQL supports both procedural and SQL statements in the same block.

Which of the following examples declares an INDEX BY table of record?

Which constraint(s) can be defined at the table level?

Package Specification dept_pack was created by the following code: CREATE OR REPLACE PACKAGE dept_pack IS        PROCEDURE ins_dept(p_deptno IN NUMBER);       FUNCTION get_dept(p_deptno IN NUMBER) RETURN VARCHAR2;END dept_pack; Which of the following is incorrect syntax for invoking the package subprograms?

You can only have one exception handler in a PL/SQL block.

What is the parameter mode for p_name in the query_demo procedure in the following PL/SQL block? DECLARE  p_name  persons.name%TYPE;    p_sal   persons.salary%TYPE;BEGIN  query_demo(178, p_name, p_sal);  DBMS_OUTPUT.PUT_LINE(‘Name: ‘ || p_name);  DBMS_OUTPUT.PUT_LINE(‘Salary: ‘ || p_sal);END;