A university stores student information in a table called students. The registrar wants to list students who are not from New York. Which query should be used? SELECT * FROM students WHERE city = ‘New York’ SELECT * FROM students WHERE NOT city = ‘New York’ SELECT * FROM students WHERE city ‘New York’ SELECT * FROM students WHERE city != ‘New York’ Answer: SELECT * FROM students WHERE NOT city = ‘New York’ Explanation: Using NOT before the condition excludes records that match New York. and != are valid alternatives in some SQL dialects, but NOT is the most universally clear and correct given the teaching context. Simply using = would only return New York, not exclude it.

The nurse is caring for a 7-year-old admitted this morning with Diabetic Ketoacidosis (DKA) and a new diagnosis of Type 1 Diabetes Mellitus. The patient’s mother has been crying some today and has asked some of the same questions multiple times. The nurse recognizes her response as…

An online shop has a products table. The name field is required for every product. Which constraint should be applied? DEFAULT NOT NULL UNIQUE PRIMARY KEY Answer: NOT NULL Explanation: The NOT NULL constraint ensures the field must always contain a value. UNIQUE prevents duplicates but still allows blanks, PRIMARY KEY applies to identifiers, and DEFAULT provides a preset value but does not enforce presence.

The balancing equation is expressed as: 

An HR team has an employees table and a departments table. They want a list of all employees, showing their department name if available. SELECT employees.name, departments.dept_name FROM employees LEFT JOIN departments ON employees.dept_id = departments.dept_id; What happens to employees without a department assignment? They are excluded They appear, but dept_name is NULL They appear, and SQL auto-fills dept_name as “Unassigned” They appear multiple times, one for each department Answer: They appear, but dept_name is NULL Explanation: A LEFT JOIN ensures all employees show up, even those without matching departments, with NULLs for missing data.

A sales manager wants to know the total revenue from the orders table, which has a column called order_amount. Which SQL function should they use? SELECT COUNT(order_amount) FROM orders SELECT SUM(order_amount) FROM orders SELECT AVG(order_amount) FROM orders SELECT MAX(order_amount) FROM orders Answer: SELECT SUM(order_amount) FROM orders Explanation: SUM adds up all the values in a column, which is what’s needed for total revenue. COUNT would only return how many orders exist, AVG would give the average order size, and MAX would only show the largest single order.

A nurse preparing to administer an antibiotic in Epic notices a red exclamation point (!) next to the order in the MAR. What is the nurse’s best action?  

In an early study of classical conditioning, a baby called “Little Albert” learned to fear a rat after its presence was paired with a loud noise.  Albert’s fear of the rat, then, is the _________.

Select all of the examples of an adrenergic reponses.

Nanocrystals, due to their unique size-dependent properties, have diverse and expanding applications in fields like