Oracle 1Z0-149 Quiz 1 Topic 11 Questions 1-5

Question: 1

Examine these statements:

q1_1Z0-149

Which is true?

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

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

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

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

Show Answer

Question: 2

SERVEROUTPUT is enabled.

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

A.

q2_1Z0-149

B.

q2_1Z0-149

C.

q2_1Z0-149

D.

q2_1Z0-149

AOption A

BOption B

COption C

DOption D

Show Answer

Question: 3

Which two are true about implicit data type conversion? (Choose two.)

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

BCollections can be implicitly converted to records.

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

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

EImplicit data type conversion can negatively impact performance.

Show Answer

Question: 4

Which block of code displays the error message ''Incorrect price value''?

A.

q4_1Z0-149

B.

q4_1Z0-149

C.

q4_1Z0-149

D.

q4_1Z0-149

AOption A

BOption B

COption C

DOption D

Show Answer

Question: 5

Examine these statements issued by user SH which execute successfully:

q5_1Z0-149

DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /

Now, examine this anonymous block executed by SH:

q5_1Z0-149

Which is true about the anonymous block?

AIt will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.

BIt will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.

CIt will fail at lines 6 and 7.

DIt will fail only at line 7.

Show Answer

Oracle 1Z0-149 Quiz:1 Topic:11 Questions:1-5