Free Oracle 1Z0-909 Exam Questions

Become Oracle Certified with updated 1Z0-909 exam questions and correct answers

Page: 1 / 13

Total 65 Questions | Updated On: Jan 16, 2025

Add To Cart

Question 1

Examine these statement which execute successfully:

Now, examine this desired output:

Which two queries will produce the out?

A :

B :

C :

D :

E :

Answer: B,C

Question 2

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

A : DELIMITER //CREATE TRIGGER agecheck BEFORE INSERT ON people FOR EACH ROW IF NEW. age < 0THENSET NEW.age =0; END IF;//DELIMITER ;

B : TER TABLE people ADD COLUMN valid_age=ABS(check_age) GENERATED ALWAYS;

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

D : TER TABLE people ADD CONSTRAINT check_age CHECK (ABS(age)>=0);

Answer: D

Question 3

You must write a statement that combines the first_name and last_name columns from the

employees table as "last_name, first_name."

Which two statements will do this?

A : LECT last_name + ', ' + first_name FROM employees;

B : LECT CONCAT_WS(', ',last_name,first_name) FROM employees;

C : LECT GROUP_CONCAT(last_name, first_name) FROM employees;

D : LECT last_name, ‘ , ',first_name FROM employees;

E : LECT CONCAT(last name,', ',first_name) FROM employees;

Answer: A,B

Question 4

Examine this statement:

DECLARE not_found CONDITION FOR SQLSTATE '02000';

In which two statements can not found be used?

A : a leave statement to exit a loop

B : an if statement

C : a while loop

D : a handler declaration

E : a signal statement

Answer: A,C

Question 5

Examine the output:

Which explain command will obtain the output?

A : PLAIN ANALYZE

B : PLAIN PARTITIONS

C : PLAIN FORMAT=TREE

D : PLAIN PORMAT^TRADITIONAL

E : PLAIN PORMAT=JSON

Answer: A

Page: 1 / 13

Total 65 Questions | Updated On: Jan 16, 2025

Add To Cart