Oracle 1Z0-149 Online Practice Questions and Exam Preparation

Oracle 1Z0-149 Online Questions & Answers

• Question 1:

  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
  D. SHUTDOWN
  E. SERVERERROR
  F. STARTUP

• Question 2:

  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.
  C. The transaction for the bank_activity_proc is independent of the bank_transaction_proc.
  E. Only one table will have a row inserted and committed.

• Question 3:

  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.
  A. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.
  D. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.

• Question 4:

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

  A. ROW
  B. AFTER SUSPEND
  C. AFTER STATEMENT
  D. BEFORE STATEMENT
  A. ROW

• Question 5:

  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 6:

  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.
  C. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.
  E. Predefined exceptions are globally declared in the standard package.

• Question 7:

  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
  C. UPDATE
  D. SELECT
  G. INSERT

• Question 8:

  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 9:

  Which two statements are true about the RETURNING clause when used with DML? (Choose two.)

  A. When using the RETURNING INTO clause, the data returned can be only single column or expression.
  B. The RETURNING INTO clause and bulk binds may not be used together.
  C. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.
  D. The RETURNING INTO clause returns column values for rows affected by DML statements.
  E. The RETURNING clause can be used for remote or parallel deletes.
  C. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.
  E. The RETURNING clause can be used for remote or parallel deletes.

• Question 10:

  Examine this DECLARE section:

  

  Which line will cause an error upon execution?

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