VCEdump

1Z0-149 Oracle Database Program with PL/SQL

PDF question preview Back to product

Reading controls

Reader tools

Free demo

10 of 65 questions

Purchase the full version to unlock every question and answer.

View the full question set

Preview tools

Try Web TestEngine

Question formats

Single choice3

Multiple choice7

Oracle · 1Z0-149

Free 1Z0-149 Exam Dumps Preview

Preview real exam questions, verified answers and available explanations before choosing a study plan.

Question 1

Multiple choice

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.

Reveal answer details Close answer details

Correct answersA, D

Question 2

Single choice

Which is true about counter variables in a FOR loop?

A
It must explicitly be declared.
B
It can be modified in the body of the loop.
C
It cannot be NULL.
D
It is accessible outside the body of the loop.

Reveal answer details Close answer details

Correct answerC

Question 3

Multiple choice

Examine this anonymous block of code:

Which two statements are true about the results of executing it? (Choose two.)

A
It will set all salaries to 0 if it executes successfully.
B
It will always return a compile time error because it lacks an EXCEPTION section.
C
It might return a run time error depending on who invokes it.
D
It will always automatically initialize v_raise.
E
It will set all salaries to NULL if it executes successfully.
F
It will always return a run time error because v_raise is not initialized.

Reveal answer details Close answer details

Correct answersD, E

Question 4

Multiple choice

Examine this table definition in the SH schema.

A row with PDT_ID = 1 exists.

Which two blocks of code will execute successfully by user SH and give the same output? (Choose two.)

A
Option A
B
Option B
C
Option C
D
Option D

Reveal answer details Close answer details

Correct answersC, D

Question 5

Single choice

Which is true about EXIT and CONTINUE statements?

A
They can be used in any type of loop.
B
They must have a WHEN condition.
C
They have the same effect on the execution of a loop.
D
They must use labels.

Reveal answer details Close answer details

Correct answerA

Question 6

Multiple choice

Which two are true about using the ACCESSIBLE BY clause? (Choose two.)

A
It can be used in the declaration of object types.
B
It must be specified in the heading of a package specification.
C
The check is enforced by this clause for direct access and access through dynamic SQL.
D
It can be used for individual procedures and functions declared in a package specification.
E
It must be specified in the heading of a package body.

Reveal answer details Close answer details

Correct answersA, D

Explanation

https://docs.oracle.com/database/122/LNPLS/ACCESSIBLE-BY-clause.htm

Question 7

Multiple choice

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

Reveal answer details Close answer details

Correct answersA, B

Question 8

Single choice

SERVEROUTPUT is enabled.

Which code block will display the values from 1 to 10 in descending order?

A
Option A
B
Option B
C
Option C
D
Option D

Reveal answer details Close answer details

Correct answerD

Question 9

Multiple choice

The SH schema contains the PRODUCTS table with column PDT_NAME defined as VARCHAR2(10).

Which two blocks of code execute successfully when invoked by user SH? (Choose two.)

A
Option A
B
Option B
C
Option C
D
Option D
E
Option E

Reveal answer details Close answer details

Correct answersA, C

Question 10

Multiple choice

Which three are true about DDL triggers? (Choose three.)

A
They cannot include the WHEN clause.
B
They must be created in an enabled state.
C
They can be fired when a table is truncated.
D
They fire only when a DDL statement is executed by the owner of the trigger.
E
They can be fired either before or after a DDL statement executes.
F
They can be fired when a privilege is granted to a user.
G
They must be created in a disabled state.

Reveal answer details Close answer details

Correct answersC, D, E

VOL	TYPE	QUESTIONS
1	Single choice	3
2	Multiple choice	7

Free 1Z0-149 Exam Dumps Preview

Oracle Database Program with PL/SQL

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10