1z0-149 Sample Questions Answers

They can be used in ORDER BY and GROUP BY clauses.

They can be executed as standalone commands.

They must be defined with at least one parameter.

They need not return any values.

They can appear in the select list of a SELECT statement.

Functions can call only other functions.

They can be used in CONNECT BY and START WITH clauses.

It returns an error in line 2.

It returns an error in line 4.

It returns an error in line 9.

It executes and displays output.

PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.

IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.

IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.

The actual parameter must be a variable when calling a subprogram with an OUT parameter.

IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.

OUT parameters returning values to calling subprograms act like constants in the called subprogram.

Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.

line 5

line 3

line 2

line 4

line 6

The index can be integer or string.

The index can be integer only.

INDEX-BY table types can be created in PL/SQL blocks only.

INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.

INDEX-BY table types can be created with the CREATE TYPE statement.

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

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

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

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

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

Neither table will have a row inserted and committed.

Both tables will have a row inserted and committed.

The transaction for the bank_activity_proc is independent of the bank_transaction_proc.

The bank_activity_proc will not compile because of the commit.

Only one table will have a row inserted and committed.

It will result in a compilation error for protected_proc because calling_proc does not exist.

It will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name.

It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.

With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.

RAW data types are always implicitly converted to a CLOB when used in a query.

Collections can be implicitly converted to records.

ROWIDS are always implicitly converted to a number when used in a query.

Comparison between character value and a number value always implicitly converts the character value to the number data type.

Implicit data type conversion can negatively impact performance.

It can be used in the declaration of object types.

It must be specified in the heading of a package specification.

The check is enforced by this clause for direct access and access through dynamic SQL.

It can be used for individual procedures and functions declared in a package specification.

It must be specified in the heading of a package body.

5000

15000

2500

10000

It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.

It will return an error at line 2.

It will return an error at line 3.

It will return an error at line 8.

It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.