Question 21

Examine these commands and output:


Which is true about the execution of the insert statement?
  • Question 22

    Examine this statement that execute successfully in an interactive session:

    The user running this session now goes to lunch for an hour.
    Now, examine these statements executed independently in separate sessions while Session 0 is still active:

    How many of them will complete while Session 0 is still active?
  • Question 23

    Examine this statement and output:

    Which will provide the same level of detail when the error is encountered within a stored routine?
    A)

    B)

    C)

    D)
  • Question 24

    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?
  • Question 25

    What is an advantage of using mysqli in PHP programs rather than using PHP Data Objects (PDO)?