Create Next App

Question 37 🔥

Examine this anonymous block of code:Which two statements are true about the results of executing it? (Choose two.)

Which database solution meets these requirements?

A. It will set all salaries to 0 if it executes successfully.

Highly voted

B. It will always return a compile time error because it lacks an EXCEPTION section.

Highly voted

C. It might return a run time error depending on who invokes it.

Highly voted

D. It will always automatically initialize v_raise.

Highly voted

E. It will set all salaries to NULL if it executes successfully.

Highly voted

F. It will always return a run time error because v_raise is not initialized.

Highly voted

Discussion of the question

Question 38 🔥

Examine this table definition in the SH schema.A row with PDT_ID = 1 exists. Which two blocks of code will execute successfully by user SH and give the same output? (Choose two.)

Which database solution meets these requirements?

A.

Highly voted

B.

Highly voted

C.

Highly voted

D.

Highly voted

Discussion of the question

Question 39 🔥

Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)

Which database solution meets these requirements?

Discussion of the question

Question 40 🔥

Which is true about EXIT and CONTINUE statements?

Which database solution meets these requirements?

A. They can be used in any type of loop.

Highly voted

B. They must have a WHEN condition.

Highly voted

C. They have the same effect on the execution of a loop.

Highly voted

D. They must use labels.

Highly voted

Discussion of the question

Question 41 🔥

Examine this statement which is submitted for compilation:Which three are true? (Choose three.)

Which database solution meets these requirements?

A. This is a PACKAGE specification. A PACKAGE BODY is needed to use this.

Highly voted

B. This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.

Highly voted

C. This program unit will compile successfully.

Highly voted

D. Initialization of min_bal can be done while using this packaged constant in another program.

Highly voted

E. Initialization of loan_amount can be done while using this packaged variable in another program.

Highly voted

F. This will not compile successfully because the min_bal constant must be initialized.

Highly voted

G. This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.

Highly voted

Discussion of the question

Question 42 🔥

Which statement is true about user-defined records?

Which database solution meets these requirements?

A. They can be returned from a function.

Highly voted

B. Field types must match column types.

Highly voted

C. The number of fields must match the number of columns in a table.

Highly voted

D. Field names must match selected column names.

Highly voted

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