35 SET EXPLAIN is turned on You code and run an SQL statemen

35. SET EXPLAIN is turned on. You code and run an SQL statement with an Optimizer directive, but do not use the correct syntax for the directive. How will you know that the syntax was incorrect? *This question is required.

a. SET EXPLAIN will cause an error message to be written to the output file

b. SET EXPLAIN will list your (invalid) directive in the DIRECTIVES FOLLOWED: section of the output

c. SET EXPLAIN will list your (invalid) directive in the DIRECTIVES NOT FOLLOWED: section of the output

d. SET EXPLAIN will not list your (invalid) directive in either the DIRECTIVES FOLLOWED: or the DIRECTIVES NOT FOLLOWED: sections of the output

36. Which of the following characters is used to distinguish an Optimizer directive in an SQL statement? *This question is required.

a. --

b. --+

c. ++

d. ++-

37. You want to select a database privilege that will provide the following:

The ability to connect to a database, create permanent and temporary tables and indexes, create stored procedures and functions, create views and synonyms, grant permissions on the objects you create and own, and drop or alter any objects that you own.

Which database level privilege will provide all of this? *This question is required.

a. SELECT

b. CONNECT

c. RESOURCE

d. DBA

Solution

35.Answer: D

36.Answer: B

37.Answer: B

All the abilities that are mentioned in the question will be provided by CONNECT database level privilege