Create Next App

Exam contains 65 questions

Page 3 of 11

Question 13 🔥

Examine this table in the SH schema:Now, examine this code:Which two changes are required to ensure that PDT_REPORT executes successfully? (Choose two.)

Which database solution meets these requirements?

A. In line 1, change IN OUT mode to IN mode.

Highly voted

B. In line 2, change IN OUT mode to IN mode.

Highly voted

C. In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.

Highly voted

D. In line 1, add the default parameter DEFAULT 2000.

Highly voted

E. In line 6, replace P_PDT_PRICE parameter name with CUR_PRIC

Highly voted

F. In line 2, add the default parameter DEFAULT 2000.

Highly voted

Discussion of the question

Question 14 🔥

User ORA41 executes these statements successfully:Now, examine this statement which is executed successfully by user ORA61 after a successful login:EXECUTE ora41.update_emp_proc(100,25000);Which two are true? (Choose two.)

Which database solution meets these requirements?

A. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA41.

Highly voted

B. No update happens even though the procedure executes successfully.

Highly voted

C. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.

Highly voted

D. The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.

Highly voted

E. ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.

Highly voted

Discussion of the question

Question 15 🔥

Which two are true about exception handling? (Choose two.)

Which database solution meets these requirements?

A. Internally defined exceptions can be handled only by the OTHERS exception handler.

Highly voted

B. All declared exceptions are raised implicitly by the runtime system.

Highly voted

C. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.

Highly voted

D. Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.

Highly voted

E. Predefined exceptions are globally declared in the standard package.

Highly voted

Discussion of the question

Question 16 🔥

Examine these statements:Which is true?

Which database solution meets these requirements?

A. It will result in a compilation error for protected_proc because calling_proc does not exist.

Highly voted

B. It will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name.

Highly voted

C. It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.

Highly voted

D. With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.

Highly voted

Discussion of the question

Question 17 🔥

Examine the EMPLOYEES table structure:Now, examine this code:Which statement is true about the result of executing this block?

Which database solution meets these requirements?

A. It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.

Highly voted

B. It will return an error at line 2.

Highly voted

C. It will return an error at line 3.

Highly voted

D. It will return an error at line 8.

Highly voted

E. It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.

Highly voted

Discussion of the question

Question 18 🔥

Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)

Which database solution meets these requirements?

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_149

Exam contains 65 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us