Oracle 1Z0-149 Online Practice Questions and Exam Preparation

Oracle 1Z0-149 Online Questions & Answers

• Question 11:

  Examine this row of data from the EMPLOYEES table:

  

  Now, examine this block of code which executes successfully:

  

  What is the value of v_commission?

  A. 5000
  B. 15000
  C. 2500
  D. 10000
  C. 2500

• Question 12:

  Which three are true regarding code based access control (CBAC)? (Choose three.)

  A. In a multitenant environment, the DELEGATE option of CBAC cannot be used.
  B. CBAC roles can be granted to a program unit only if they are directly granted to its owner.
  C. CBAC roles can be granted to a program unit only if they are the predefined roles automatically defined by the standard scripts as part of database creation.
  D. You can use CBAC to attach database roles to a PL/SQL function or procedure only.
  E. In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.
  F. You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.
  G. CBAC cannot be used to secure definer's rights.
  B. CBAC roles can be granted to a program unit only if they are directly granted to its owner.
  E. In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.
  F. You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.

• Question 13:

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

  ---

  Explanation/Reference:

• Question 14:

  In one of your databases, table HR.EMPLOYEES includes the columns FIRST_NAME and EMPLOYEE_ID.

  A row exists with EMPLOYEE_ID 201.

  Examine these packages created by user HR:

  

  EXECUTE privilege is granted to user SH, on the HR.API and HR.HELPER packages.

  Which two will execute successfully? (Choose two.)

  A. Call HR.HELPER.H1 from the HR schema.
  B. Call HR.HELPER.H1 from the SH schema.
  C. Call HR.API.P1 from the HR schema.
  D. Call HR.API.P1 from the SH schema.
  E. Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.
  B. Call HR.HELPER.H1 from the SH schema.
  D. Call HR.API.P1 from the SH schema.

• Question 15:

  Which two are true about lexical units? (Choose two.)

  A. Character literals are case-sensitive.
  B. Spaces can be embedded in delimiters.
  C. Identifiers include labels.
  D. A character literal with zero characters has the BOOLEAN value NULL.
  E. All user-defined identifiers must start with an alphabet.
  A. Character literals are case-sensitive.
  E. All user-defined identifiers must start with an alphabet.

• Question 16:

  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
  A. printer_name#
  D. leap$year
  G. v_fname

• Question 17:

  Examine this DECLARE section:

  

  Which two lines are valid? (Choose two.)

  A. line 5
  B. line 6
  C. line 7
  D. line 4 E. line 3
  F. line 2
  A. line 5
  F. line 2

• Question 18:

  Which two are true about collections and RECORD types? (Choose two.)

  A. A variable of RECORD type can contain fields of another RECORD type or any collection type.
  B. Only associative arrays and nested tables can have elements of RECORD type.
  C. All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.
  D. Collections and RECORD types are always dense.
  E. All collections and RECORD types can be stored in table columns.
  F. VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.
  B. Only associative arrays and nested tables can have elements of RECORD type.
  F. VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.

• Question 19:

  Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)

  A. PL/SQL code can be compiled and executed based on different versions of the operating system.
  B. PL/SQL code can be compiled and executed based on different versions of Oracle.
  C. It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.
  D. Conditional compilation is disabled by default.
  E. The PL/SQL compiler can conditionally include selected parts of a program.
  B. PL/SQL code can be compiled and executed based on different versions of Oracle.
  E. The PL/SQL compiler can conditionally include selected parts of a program.

• Question 20:

  Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)

  A. Implicit cursor returns only one record.
  B. Explicit cursor can return more than one record.
  C. %Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.
  D. %Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.
  E. %Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.
  F. %Isopen is always false in Explicit Cursor.
  G. %Isopen is always false in Implicit Cursor.
  B. Explicit cursor can return more than one record.
  C. %Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.
  G. %Isopen is always false in Implicit Cursor.