Oracle 1Z0-149 Online Practice Questions and Exam Preparation

Oracle 1Z0-149 Online Questions & Answers

• Question 41:

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

  A. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA41.
  B. No update happens even though the procedure executes successfully.
  C. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.
  D. The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.
  E. ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.
  C. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.
  D. The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.

• Question 42:

  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.
  B. In line 2, change IN OUT mode to IN mode.
  D. In line 1, add the default parameter DEFAULT 2000.

• Question 43:

  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.
  B. It returns an error in line 4.

• Question 44:

  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
  C. Option C

  ---

  Explanation/Reference:

• Question 45:

  Which three PL/SQL-only data types can be used in queries and native dynamic SQL issued from PL/SQL in the server? (Choose three.)

  A. a record declared in an anonymous block
  B. a record declared in a procedure
  C. an associative array indexed by PLS_INTEGER
  D. a record declared in a package specification
  E. a predefined PL/SQL-only data type like BOOLEAN
  F. an associative array indexed by VARCHAR2
  C. an associative array indexed by PLS_INTEGER
  D. a record declared in a package specification
  F. an associative array indexed by VARCHAR2

• Question 46:

  Examine the structure of the ora1.depts table:

  

  Now, examine these statements issued by user ora1 which execute successfully:

  Create or replace view dep_vu as select * from depts;

  Alter table depts add dep_email varchar2(20);

  Finally, examine this block of code executed by user ora1:

  

  Which is true?

  A. DEP_VU must be manually recompiled to successfully run this code.
  B. It will run successfully producing a result of 4.
  C. It will result in an error because table depts has been altered.
  D. It will run successfully producing a result of 5.
  B. It will run successfully producing a result of 4.

• Question 47:

  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.
  A. It will result in a compilation error for protected_proc because calling_proc does not exist.

• Question 48:

  Examine this code:

  

  What will be the outcome?

  A. It will execute successfully and will display the user-defined error message.
  B. It will result in an error as the range of the error code can only be from "-20000 to - 20999."
  C. It will result in an error as the range of the error code can only be from "-1000 to -2000."
  D. It will result in an error as the range of the error code can only be from "-2000 to -2999."
  B. It will result in an error as the range of the error code can only be from "-20000 to - 20999."

• Question 49:

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

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  C. Option C
  D. Option D

  ---

  Explanation/Reference:

• Question 50:

  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.
  A. It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.