Oracle Oracle Certifications 1Z0-149 Questions & Answers

• Question 1:

  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.

  Correct Answer: BEG

• Question 2:

  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

  Correct Answer: B

• Question 3:

  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.

  Correct Answer: A

• Question 4:

  SERVEROUTPUT is enabled.

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

  

  A. Option

  B. Option

  C. Option

  D. Option

  Correct Answer: D

• Question 5:

  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.

  Correct Answer: BD

• Question 6:

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

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: AB

• Question 7:

  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

  Correct Answer: A

• Question 8:

  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.

  Correct Answer: C

• Question 9:

  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.

  Correct Answer: D

• Question 10:

  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

  Correct Answer: ADG