Blog

A 55-year-old female patient presents to the clinic for a wellness examination. The nurse practitioner observes during the history taking portion of the examination that the patient is obese and was a gymnast when she was a young girl into her teen years. Additionally, the patient has been most recently diagnosed with hypermobility syndrome. What is this patient at risk for?

The nurse practitioner described a lesion using the following terms: elevated, superficial lesion; purulent fluid-filled vessical The nurse practitioner was describing…

The SQL INSERT statement is a synonym for the SQL UPDATE statement. That is, they do the same thing and can be used interchangeably.

Given the code that follows, $employee = array();$employee[“name”] = “John Smith”;$employee[“age”] = 29; which of these statements assigns the string “John Smith is 29” to $message?

In an SQL SELECT, the WHERE clause is used to specify the rows to retrieve.

Column Name Data Type Note food_id int This is the primary key; auto generated by DB. name var_char(128)   price float   quantity int   Write the SQL for these for four items using the table above.  The name of the table is FOOD.  Write a SELECT that returns the primary key and the name of all the foods that have a price greater than $10.00. Write an UPDATE that finds the food with the food_id equal to 42, and sets its quantity to 5. Write an INSERT that inserts the following food item: name: Oreos price: $4.99 quantity: 15 Write a DELETE that removes all foods with a quantity of 0. Do not write any PHP in your answer. Each query is 5 points.  

Column Name Data Type Note food_id int This is the primary key; auto generated by DB. name var_char(128)   price float   quantity int   PHP code searched the table above for a bunch of food, and the SELECT retrieved only the name field. The results of the search were stored in the variable $results like this: $results = $stmt->fetchAll(); There is always more than one record returned. Write code that outputs all the names found in the search as a UL element with a set of bullets, one for each name.    

What does a relational database use to uniquely identify each row in a table

Which item creates an sql statement that is the least vulnerable to an SQL injection attack?

Question 2 – SQL tblVoters VoterID Firstname Surname Class Password 12345 Lauren James 10A fluffy 1478 Patience Cash 10A 12345 2564 Brenna Hogan 10B AAA 2579 Karen James 10B abcde 2580 Quail Phillips 10C mypassword 33333 Nora Mabalene 10C sillypassword 3456 Jacqueline Duke 11A pass 4322 Colette Bryan 11A password 4343 Karen Holden 11B kittykat 456789 Rhiannon Hogan 11B hayden 456987 Genevieve Munoz 11C gen 487598 Amity Naidoo 9A XYZ123 5555 Willow Fernandez 9A 123XYZ 5789 Genevieve James 9B nopassword 589632 Martha Teichman 9B BGHNMJK