Question 21

Examine the output:

Which explain command will obtain the output?
  • Question 22

    Examine the contents of these tables:

    Now examine the expected results for a user with privileges to access the table:

    Which query returns the expected results?
    A)

    B)

    C)

    D)
  • Question 23

    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 24

    Examine these statements and output:

    Now, examine this command:
    Mysql> ROLLBACK;
    What is true about the effect of the command?
  • Question 25

    Examine the layout of the my_values table.

    Examine the data in the my_value3 table.

    Examine this statement:

    A)

    B)


    D)