Decide Fast & Get 50% Flat Discount on This 2024Friday | Limited Time Offer - Ends In COUPON CODE: 2024Friday

Home
Dumps
Oracle
1Z0-149

Practice Oracle 1Z0-149 Exam Questions

1. Page: 1/13
  Total 65 Questions
Question No 1

Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)

Choose the Choices:

PACKAGES

VARIABLES

ANONYMOUS BLOCK

TRIGGER BODY

DATABASE LINKS

A,E
Question No 2

Which three are true about functions and procedures? (Choose three.)

Choose the Choices:

The ACCESSIBLE BY clause can be used only for procedures.

In a function, every execution path must lead to a RETURN statement.

Both can have only constants as actual parameters for IN mode parameters.

Both can be invoked from within SQL statements.

In a procedure the RETURN statement cannot specify an expression.

In a function every RETURN statement must specify an expression.

B,E,F
Question No 3

Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)

Choose the Choices:

PL/SQL code can be compiled and executed based on different versions of the operating system.

PL/SQL code can be compiled and executed based on different versions of Oracle.

It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.

Conditional compilation is disabled by default.

The PL/SQL compiler can conditionally include selected parts of a program.

B,E
Question No 4

Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)

Choose the Choices:

The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.

The NOCOPY hint asks the compiler to pass the actual parameters by reference.

A deterministic function's results always depend on the state of session variables.

The NOCOPY hint asks the compiler to pass the actual parameters by value.

A function is deterministic if it always returns the same result for a specific combination of input values.

The PARALLEL_ENABLE clause can be specified for a nested function.

A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.

B,E,G
Question No 5

Which two are true about INDEX - BY tables? (Choose two.)

Choose the Choices:

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.

A,C
1. Page: 1/13
  Total 65 Questions
  
  Buy Now Latest Questions
Full Access
1Z0-149 Exam Features

In Just $79 Access Your All Questions

All Official Question Types

Interactive Web-Based Practice Test Software

No Installation or 3rd Party Software Required

Practice your Exam Questions (Free Demo)

24/7 Customer Support

Buy Now
Full Access
1Z0-149 PDF Dumps

In Just $ Access All PDF Questions

All Official Question Types

PDF Practice Questions & Answers

Printable & Portable Format

Download PDF Questions (Free Demo)

24/7 Customer Support

Buy Now