Exit demo 1Z0-149 Oracle Database Program with PL/SQL PDF format · free preview

Oracle 1Z0-149 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/1z0-149.html

Question 1
Multiple choice

Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)

A.

The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.

B.

The NOCOPY hint asks the compiler to pass the actual parameters by reference.

C.

A deterministic function's results always depend on the state of session variables.

D.

The NOCOPY hint asks the compiler to pass the actual parameters by value.

E.

A function is deterministic if it always returns the same result for a specific combination of input values.

F.

The PARALLEL_ENABLE clause can be specified for a nested function.

G.

A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.

Question 2
Single choice

Examine these statements and output:

The procedure is created successfully.

User ora2 has password ora2 in pdb1.

Which script will execute successfully?

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Question 3
Single choice

Which is true about EXIT and CONTINUE statements?

A.

They can be used in any type of loop.

B.

They must have a WHEN condition.

C.

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

D.

They must use labels.

Question 4
Single choice

SERVEROUTPUT is enabled.

Which code block will display the values from 1 to 10 in descending order?

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Question 5
Multiple choice

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.)

A.

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

B.

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

C.

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

D.

In line 1, add the default parameter DEFAULT 2000.

E.

In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.

F.

In line 2, add the default parameter DEFAULT 2000.

Question 6
Multiple choice

Which two blocks of code display a numerical zero? (Choose two.)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Question 7
Single choice

Which is the correct method to implement a local subprogram in an anonymous block?

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Question 8
Single choice

Which statement is true about user-defined records?

A.

They can be returned from a function.

B.

Field types must match column types.

C.

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

D.

Field names must match selected column names.

Question 9
Single choice

Examine this code:

ALTER SESSION SET plsql_warnings='ENABLE:ALL';

/

You compile this function:

What happens when the function is created with PLSQL_WARNINGS set to 'ENABLE: ALL'?

A.

It fails compilation.

B.

There are no compilation warnings or errors.

C.

A severe compilation warning is generated.

D.

A performance compilation warning is generated.

E.

An information compilation warning is generated.

Question 10
Multiple choice

Which three are valid PL/SQL variable names? (Choose three.)

A.

printer_name#

B.

1to7number

C.

yesterday's_date

D.

leap$year

E.

Number_of_days_between_March_and_April

F.

#printer_name

G.

v_fname

Showing 10 of 65 questions · Unlock the full set