Oracle Oracle Certifications 1Z0-149 Questions & Answers

• Question 61:

  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

  Correct Answer: C

• Question 62:

  In which type of trigger can :OLD and :NEW identifiers be used?

  A. ROW

  B. AFTER SUSPEND

  C. AFTER STATEMENT

  D. BEFORE STATEMENT

  Correct Answer: A

• Question 63:

  Examine these statements from a block of code: Which two are true? (Choose two.)

  

  A. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.

  B. Only the PRICE column can be updated in the PRODUCTS table.

  C. The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.

  D. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.

  E. An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.

  Correct Answer: AD

• Question 64:

  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.

  Correct Answer: CE

• Question 65:

  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

  Correct Answer: DEF