Decide Fast & Get 50% Flat Discount | Limited Time Offer - Ends In 0d 00h 00m 00s Coupon code: SAVE50

Master Oracle 1Z0-909 Exam with Reliable Practice Questions

Page: 1 out of Viewing questions 1-5 out of 65 questions
Last exam update: Nov 12,2024
Upgrade to Premium
Question 1

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)


Correct : A


Options Selected by Other Users:
Mark Question:

Start a Discussions

Submit Your Answer:
0 / 1500
Question 2

The variables c and d are declared as integer types.

Examine these initialization statements with placeholder value , which execute successfully:

Now, examine this loop which executes successfully:

Which loop results in the same value of d for all valid values of ?

A)

B)

C)


Correct : A


Options Selected by Other Users:
Mark Question:

Start a Discussions

Submit Your Answer:
0 / 1500
Question 3

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


Correct : A, D


Options Selected by Other Users:
Mark Question:

Start a Discussions

Submit Your Answer:
0 / 1500
Question 4

Examine this statement:

DECLARE not_found CONDITION FOR SQLSTATE '02000';

In which two statements can not found be used?


Correct : C, E


Options Selected by Other Users:
Mark Question:

Start a Discussions

Submit Your Answer:
0 / 1500
Question 5

Which statement is true about the show errors command?


Correct : A


Options Selected by Other Users:
Mark Question:

Start a Discussions

Submit Your Answer:
0 / 1500