Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Pass the Oracle Database PL/SQL Developer Certified Professional 1z0-149 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.
Exam 1z0-149 Premium Access

View all detail and faqs for the 1z0-149 exam

Go to Exam

827 Students Passed

92% Average Score

92% Same Questions
Viewing page 2 out of 2 pages
Viewing questions 11-20 out of questions
Questions # 11:

Sequence S and table PRODUCTS exist in your schema.

Examine the table description:

Question # 11

Now, examine this block of code:

Question # 11

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

Options:

A.

line 1

B.

line 6

C.

line 8

D.

line 2

E.

line 3

F.

line 7

Questions # 12:

SERVEROUTPUT is enabled.

Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?

Options:

A.

B.

C.

D.

Questions # 13:

Which three are true about anonymous blocks and subprograms? (Choose three.)

Options:

A.

Named subprograms cannot be called from other packages.

B.

PROCEDURE subprograms can accept parameters.

C.

A FUNCTION subprogram must return one or more values.

D.

Anonymous blocks cannot use packaged variables.

E.

Named subprograms are stored in the database server.

F.

Anonymous blocks must always start with the Declare keyword.

G.

FUNCTION subprograms must be called and passed through one or more parameters.

Questions # 14:

Examine these statements from a block of code:

Question # 14

Which two are true? (Choose two.)

Options:

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.

Questions # 15:

Which three are true about the procedure overloading feature? (Choose three.)

Options:

A.

Each procedure can be a nested subprogram.

B.

Each procedure's formal parameters can differ in data type or name.

C.

Each procedure must use named notation to specify the corresponding actual parameters.

D.

Each procedure's formal parameters must differ in name.

E.

Each procedure can be a packaged subprogram.

F.

Each procedure must use positional notation to specify the corresponding actual parameters.

G.

Each procedure can be a standalone subprogram.

Questions # 16:

Examine this DECLARE section:

Question # 16

Which line will cause an error upon execution?

Options:

A.

line 5

B.

line 3

C.

line 2

D.

line 4

E.

line 6

Questions # 17:

Which two are true about named notations in a PL/SQL subprogram? (Choose two.)

Options:

A.

The actual parameters must be specified in the same order as the formal parameters are declared.

B.

Specifying actual parameters in the wrong order results in the subprogram terminating with an exception.

C.

Only trailing optional parameters can be omitted in the invocation call.

D.

The subprogram invocations must be changed when the formal parameter list acquires new required parameters.

E.

Any optional parameters can be omitted in the invocation call.

Questions # 18:

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.)

Options:

A.

B.

C.

D.

E.

Questions # 19:

Which three are true about user-defined functions? (Choose three.)

Options:

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.

Viewing page 2 out of 2 pages
Viewing questions 11-20 out of questions
TOP CODES

TOP CODES

Top selling exam codes in the certification world, popular, in demand and updated to help you pass on the first try.

2V0-11.25
ADM-201
Agentforce-Specialist
CMMC-CCP
Data-Cloud-Consultant
PDI
PSE-Strata-Pro-24
Secure-Software-Design
Sharing-and-Visibility-Architect
Workday-Pro-Integrations
ZDTA