Question 1

Examine these statements which execute successfully:

Now, examine this query:

What is the result?
  • Question 2

    Examine these MySQL Shell statements:

    What is the true about the attempts to add document to the collection?
  • Question 3

    The employee table includes these columns:
    e_id INT, e_name VARCHAR (45), dept_id INT salart INT
    You must create a stored function, getMaxSalary(), which returns the maximum salary paid for a given department id.
    Which statement will create the function?
  • Question 4

    You must enforce data integrity for data Inserted in a JSON column.
    Which statement successfully creates a constraint in a 3SON column?
  • Question 5

    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)