Question 26

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 27

    The collection col contains all episodes for all seasons for a TV show.
    Examine this document which has an example of the details for each episode:

    Which query returns all expisode names from the first season?
  • Question 28

    Examine this event's metadata:

    Now examine this command:
    DROP USER 'userl'e'localhost';
    Which effect will the command have on the event?
  • Question 29

    Examine these statement which execute successfully:

    Now, examine the statements executed in the mysqi command-line client:

    What is true?
    A)

    B)

    C)

    D)
  • Question 30

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