Performing SQL Operations with Native Dynamic SQL - questions and answers

Performing SQL Operations with Native Dynamic SQL - questions and answers

1) The DBMS_SQL package should be used in which of the following situations?

A) There is an unknown number of input or output variables, such as the number of column values returned by a query, that are used in a dynamic SQL statement.
B) The dynamic code is too large to fit inside a 32K bytes VARCHAR2 variable.
C) Both A & B
D) NOne of the above
View Answer / Hide Answer


2) By using which clause, the mode is OUT, so you cannot specify a parameter mode for output bind arguments?

A) USING Clause
B) RETURNING INTO Clause
C) Both A & B
D) None of the above
View Answer / Hide Answer


3) You can use the BULK COLLECT INTO clause with the FETCH statement to store values from each column of a cursor in a separate collection.

A) True
B) False
View Answer / Hide Answer


4) When building up a single SQL statement in a string, do not include any semicolon at the end.

A) Yes
B) No
View Answer / Hide Answer


5) A function called from SQL statements must obey certain rules meant to control side effects.

A) True
B) False
View Answer / Hide Answer


6) You can use the RETURNING BULK COLLECT INTO clause with the EXECUTE IMMEDIATE statement to store the results of which statements in a set of collections?

A) INSERT
B) UPDATE
C) DELETE
D) All mentioned above
View Answer / Hide Answer


7) You can use the BULK COLLECT INTO clause with the EXECUTE IMMEDIATE statement to store values from each column of a query's result set in a separate collection.

A) Yes
B) No
View Answer / Hide Answer


8) Dynamic SQL enables you to build SQL statements dynamically at runtime.

A) True
B) False
View Answer / Hide Answer


9) To process most dynamic SQL statements, you use the EXECUTE IMMEDIATE statement. To process a multi-row query (SELECT statement), which of these statements would you use?

A) OPEN-FOR
B) FETCH
C) CLOSE
D) All mentioned above
View Answer / Hide Answer