Question 16
The continent column in the country table contains no null values.
Examine this output:
A)
B)
C)
D)
Examine this output:
A)
B)
C)
D)
Question 17
Examine the employee table structure:
Which set of statements immediately returns empname for a given emp_id by using a parameterized prepare statement?
A)
D)
Which set of statements immediately returns empname for a given emp_id by using a parameterized prepare statement?
A)
D)
Question 18
Examine this table definition:
The table must always remain a valid document store collection. What restriction does this impose on any added column?
The table must always remain a valid document store collection. What restriction does this impose on any added column?
Question 19
Which two statements are true about AUTO_INCREMENT?
Question 20
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?