QUESTION: 45

What are four reasons to use a macro? (Choose four.)

To limit access to data
To enforce locking choices
To reduce parsing overhead
To ensure consistency of SQL code
To create several secondary indexes on a table
To pass a table name dynamically as a parameter

Answer(s): A,B,C,D

Assume the following stored procedure partial definition:
CREATE PROCEDURE test_set (IN a INT, INOUT b INT, OUT c INT) Which three statements would be valid constructs within the stored procedure? (Choose three.)

SET c = b + a
SET b = c + 1
SET b = b + 1
SET c = b + 1

Answer(s): A,C,D

Reveal Solution Next Question

QUESTION: 47

Assume the following stored procedure is defined and executed as follows: CREATE PROCEDURE test_set (IN V1 INT, INOUT V2 INT, OUT V3 INT) BEGIN
SET V3 = V1 + 2; SET V2 = V2 * V2
END;
CALL call_test1 (4, 5, V3);
What are the output values for V2 and V3?

25, 6
16, 5
16, 7
25, 7

Answer(s): A

Reveal Solution Next Question

QUESTION: 48

What are three characteristics of derived tables? (Choose three.)

They are local to the query.
They may be defined with DDL.
There is no Data Dictionary involvement.
They are materialized in temporary space.
Spool rows are discarded when the query finishes.

Answer(s): A,C,E

Reveal Solution Next Question

Free NR0-016 Exam Braindumps (page: 13)

QUESTION: 45

QUESTION: 46

QUESTION: 47

QUESTION: 48

NR0-016 Discussions & Posts