Oracle Oracle Certifications 1Z0-149 Questions & Answers

• Question 21:

  Which three are true about user-defined functions? (Choose three.)

  A. They can be used in ORDER BY and GROUP BY clauses.

  B. They can be executed as standalone commands.

  C. They must be defined with at least one parameter.

  D. They need not return any values.

  E. They can appear in the select list of a SELECT statement.

  F. Functions can call only other functions.

  G. They can be used in CONNECT BY and START WITH clauses.

  Correct Answer: AEG

• Question 22:

  SERVEROUTPUT is enabled.

  Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: D

• Question 23:

  Examine the EMPLOYEES table structure:

  

  Now, examine this code:

  

  Which statement is true about the result of executing this block?

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

  B. It will return an error at line 2.

  C. It will return an error at line 3.

  D. It will return an error at line 8.

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

  Correct Answer: A

• Question 24:

  Examine this anonymous block of code:

  

  Which two statements are true about the results of executing it? (Choose two.)

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

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

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

  D. It will always automatically initialize v_raise.

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

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

  Correct Answer: DE

• Question 25:

  Examine this statement which is submitted for compilation:

  

  Which three are true? (Choose three.)

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

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

  C. This program unit will compile successfully.

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

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

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

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

  Correct Answer: BFG

• Question 26:

  Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 27:

  Examine this statement which executes successfully:

  SQL> SET SERVEROUTPUT ON;

  Now, examine this code which is executed:

  

  What is true about the result?

  A. It returns an error in line 2.

  B. It returns an error in line 4.

  C. It returns an error in line 9.

  D. It executes and displays output.

  Correct Answer: B

• Question 28:

  The SH schema contains the PRODUCTS table with column PDT_NAME defined as VARCHAR2(10). Which two blocks of code execute successfully when invoked by user SH? (Choose two.)

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  E. Option E

  Correct Answer: AC

• Question 29:

  Examine these statements: Which is true?

  

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

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

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

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

  Correct Answer: A

• Question 30:

  Which two are true about INDEX-BY tables? (Choose two.)

  A. The index can be integer or string.

  B. The index can be integer only.

  C. INDEX-BY table types can be created in PL/SQL blocks only.

  D. INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.

  E. INDEX-BY table types can be created with the CREATE TYPE statement.

  Correct Answer: AC