Question 21
Examine these commands and output:


Which is true about the execution of the insert statement?


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?

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)


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?

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)?
