Online Access Free 1z1-909 Exam Questions

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.

Examine this statement:
DECLARE not_found CONDITION FOR SQLSTATE '02000';
In which two statements can not found be used?

• A.in a leave statement to exit a loop
• B.in an if statement
• C.in a while loop
• D.in a signal statement
• E.in a handler declaration

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

• A.CREATE TABLE fshop (id INT NOT NULL AUTOINCREMENT, product JSON, PRIMARY KEY (id)) ENGINE=InnoDB;
• B.CREATE TABLE fshop (product JSON CHECK (JSON_VALID(product) ) ) ;
• C.CREATE TABLE fshop ( product JSON, f INT' GENERATED ALWAYS AS (product->"S - id") ) ;
• D.CREATE TABLE fshop (id INT NOT NULL AUTO_ INCREMENT, product JSON, CHECK (id>0) ) ENGXNE=InnoDB;

Examine these commands which execute successfully:
mYsql> CREATE TABLE income (acct_num INT, amount DECIMAL(10,2));
mysql> CREATE TRIGGER subtotal BEFORE INSERT ON income
FOR EACH ROW SET @subtotal = subtotal + NEW.amount;
Which is true for the income table?

• A.Execution of an insert statement causes the trigger to activate.
• B.The trigger body set causes trigger activation.
• C.The trigger activates after any row in the table has been updated.
• D.The trigger activates after any row has been inserted into the table.

Examine the output:

Which explain command will obtain the output?

• A.EXPLAIN ANALYZE
• B.EXPLAIN PORMAT=JSON
• C.EXPLAIN FORMAT=TREE
• D.EXPLAIN PORMAT^TRADITIONAL
• E.EXPLAIN PARTITIONS