Question 1

You must write a statement that combines the first_name and last_name columns from the employees table as "last_name, first_name." Which two statements will do this?
  • Question 2

    How does InnoDB choose deadlock victims in MySQL?
  • Question 3

    You must reclaim memory used by a prepared statement named prep. Which two achieve this?
  • Question 4

    Examine the Test.php script which is numbered for clarity, and its output:

    PHP Fatal error: Uncaught Error: call to underined function mysqli_connect () in Test.php:2 Which action will fix this error?
  • Question 5

    Examine these statements issued from Session 1 which execute successfully:

    Now, examine these statements issued from Session 2 which execute successfully:
    Session 2>
    BEGIN;
    UPDATE band SET song=CONCAT ("Here Comes the ", song) WHERE song LIKE ' %Sun ; Which two are true?