Free Access Oracle.1Z0-909.v2022-12-19.q24 Practice Test (Page 4)

Question 11

Examine this statement and output:

What causes the error?

A.The engine is disabled.

B.The set local_infile option has not been enabled.

C.The database server is running in read-only mode.

D.The database server process does not have sufficient privilege.

E.The database client process does not have sufficient privilege.

F.The database user does not have sufficient privilege.

Question 12

Which change will prevent negative ages to be inserted into the people table?

A.ALTER TABLE people ADD COLUMN valid_age=ABS(check_age) GENERATED ALWAYS;

B.ALTER TABLE people ADD CONSTRAINT check_age CHECK (ABS(age)>=0);

C.DELIMITER //
CREATE TRIGGER age check AFTER INSERT ON people FOR EACH ROW IF NEW. age < 0 THEN SET NEW.age =0; END IF;// DELIMITER;

D.DELIMITER //
CREATE TRIGGER agecheck BEFORE INSERT ON people FOR EACH ROW IF NEW. age < 0 THEN SET NEW.age =0; END IF;// DELIMITER ;

Question 13

Your session has sqi_mode set to default.
Examine this statement which executes successfully:

Now examine this statement:

Which two changes are required to the insert statement so that it inserts the correct data?
* std_id = 10301
* firstname = Mary
* lastname = O'Hagen
* birthdate = November 26, 1997
* reg_date = the current date

A.Change " NULL " to ' NULL ' .

B.Change " NULL " to NULL.

C.Change "O'Hagen" to "O\'Hagen".

D.Change DATE () to DAY ().

E.Change date () to CURRENT_TIMESTAMP () .

F.Change "O'Hagen" to 'o\'Hagen'.

Question 14

Which two statements are true about AUTO_INCREMENT?

A.A server restart always resets the AUTO_INCREMENT value to largest value in the AUTO_INCREMENT column plus 1.

B.An AUTO_INCREMENT column must be indexed.

C.A table can have multiple AUTO_INCREMENT columns.

D.AUTO_INCREMENT values allocated to a transaction that is rolled back are not reused.

E.The decimal data type supports AUTO_INCREMENT.

Question 15

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)