Blog

Uploading Work During Assessments You are required to upload your work for each question. Failure to do so goes against our honor code and is considered academically dishonest.  Please upload your work for all questions directly into this question using the Upload/Record Media option and your external webcam.

Cheesman and Merikle’s (1984) investigations on subliminal priming suggested that  

A patient has been taking warfarin for seven days to treat a deep vein thrombosis. They are scheduled to receive their next dose of warfarin at 08:00 am. At 07:00 AM, the patient’s INR result is 2.2. What is the nurse’s best action?

A patient with a breast biopsy that is positive for cancer is to undergo a sentinel lymph node biopsy (SLNB). The nurse explains this procedure to the patient. Which of the following statements will the nurse include in the explanation?

A hospital has a patients table with columns city and patient_id. Administrators want to see how many patients are in each city. Which query is correct? SELECT city, COUNT(patient_id) FROM patients GROUP BY city SELECT COUNT(patient_id) FROM patients SELECT city, patient_id FROM patients GROUP BY city SELECT * FROM patients ORDER BY city Answer: SELECT city, COUNT(patient_id) FROM patients GROUP BY city Explanation: COUNT(patient_id) counts patients per city when grouped by city. Without grouping, COUNT only gives the overall total. Grouping with non-aggregated fields like patient_id is invalid, and ORDER BY city just sorts rows without summarizing.

A company needs to create a new table called employees with the following fields: employee_id (unique number) name (text, up to 200 characters) salary (decimal with up to 2 decimal places) Which SQL statement is correct? CREATE TABLE employees (employee_id VARCHAR(200), name INT, salary DECIMAL(10,2)); CREATE TABLE employees (employee_id INT, name VARCHAR(200), salary DECIMAL(10,2)); CREATE TABLE employees (employee_id INT, name DECIMAL(10,2), salary VARCHAR(200)); CREATE employees TABLE (employee_id INT, name VARCHAR(200), salary DECIMAL(10,2)); Answer: CREATE TABLE employees (employee_id INT, name VARCHAR(200), salary DECIMAL(10,2)); Explanation: INT is appropriate for IDs, VARCHAR(200) stores names, and DECIMAL(10,2) supports monetary values with 2 decimal places. The other options either mismatch data types or have invalid syntax.

You’re knee-deep in grain deals and cow-trading negotiations. You’re not a protector of the community in the traditional sense, but the community depends on your ability to make a killer trade route. You are a member of…

A bank keeps transaction data in transactions and account data in accounts. They run: SELECT accounts.account_id, transactions.amount FROM accounts FULL OUTER JOIN transactions ON accounts.account_id = transactions.account_id; Which statement best describes the result? Only accounts that have transactions Only transactions linked to valid accounts All accounts and all transactions, matching where possible Accounts without balances are excluded Answer: All accounts and all transactions, matching where possible Explanation: A FULL OUTER JOIN includes everything from both sides, inserting NULLs where no match exists.

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.

Which of the following is a cholinergic response?