oracle 1z0-149 practice test

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.

Examine this table in the SH schema:

User SH executes this code:

The program must terminate with a user-defined message and no rows displayed if more than one
product's price is 1000.
With which option must “---placeholder” be replaced?
A.

B.

C.

D.

E.

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

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.

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.

Which two are true about exception handling? (Choose two.)

• A. Internally defined exceptions can be handled only by the OTHERS exception handler.
• B. All declared exceptions are raised implicitly by the runtime system.
• C. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.
• D. Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.
• E. Predefined exceptions are globally declared in the standard package.

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.

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.

Sequence S and table PRODUCTS exist in your schema.
Examine the table description:

Now, examine this block of code:

Which two lines each result in a compilation error? (Choose two.)

• A. line 1
• B. line 6
• C. line 8
• D. line 2
• E. line 3
• F. line 7

For which three SYSTEM EVENTS can triggers be created? (Choose three.)

• A. DDL
• B. AFTER AUDIT
• C. BEFORE ANALYZE
• D. SHUTDOWN
• E. SERVERERROR
• F. STARTUP
• G. BEFORE GRANT