1Z0-149 Online Practice Questions and Answers

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

A. Option A

B. Option B

C. Option C

D. Option D

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

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.

Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)

A. DISABLE

B. ENABLE

C. ERROR

D. ALL

E. SEVERE

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.

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.

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 three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)

A. CREATE

B. DROP

C. UPDATE

D. SELECT

E. DELETE

F. ALTER

G. INSERT

Examine these statements:

Which two are true? (Choose two.)

A. Neither table will have a row inserted and committed.

B. Both tables will have a row inserted and committed.

C. The transaction for the bank_activity_proc is independent of the bank_transaction_proc.

D. The bank_activity_proc will not compile because of the commit.

E. Only one table will have a row inserted and committed.

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