Question 1
Examine these statements which execute successfully:

Now, examine this query:

What is the result?

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?

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


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

Which query returns the expected results?
A)

B)

C)

D)

