1z1-909 Exam Question 1
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?
A)
B)
C)
D)
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?
A)
B)
C)
D)
1z1-909 Exam Question 2
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?
Examine this document which has an example of the details for each episode:
Which query returns all expisode names from the first season?
1z1-909 Exam Question 3
Examine this statement and output:
You execute this statement:
SELECT JSON_SEARCH(product,'one','IT') FROM fshop ;
What is the output?
You execute this statement:
SELECT JSON_SEARCH(product,'one','IT') FROM fshop ;
What is the output?
1z1-909 Exam Question 4
Examine these statements which execute successfully:
Which two changes will improve this query performance?
Which two changes will improve this query performance?
1z1-909 Exam Question 5
How does InnoDB choose deadlock victims in MySQL?