1Z0-909 Exam Question 21
Which select statement returns true?
1Z0-909 Exam Question 22
Examine the structure of the emp table:

Examine the structure of the emp_vu1 view based on the emp table:

Now, examine this statement:
mysq1> INSERT INTO emp_vul VALUES ('Alice',20000) ;
What is true about executing the statement?

Examine the structure of the emp_vu1 view based on the emp table:

Now, examine this statement:
mysq1> INSERT INTO emp_vul VALUES ('Alice',20000) ;
What is true about executing the statement?
1Z0-909 Exam Question 23
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?
1Z0-909 Exam Question 24
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)

1Z0-909 Exam Question 25
Which two differences exist between the timestamp and date time data types?