Oracle 1z0-146 Exam Questions

Question 6 of 117

The database instance was started up using the automatic memory management feature. No value was set for the RESULT_CACHE_MAX_SIZE parameter.
Examine the following initialization parameter settings for your database:

MEMORY_TARGET = 500M -

RESULT_CACHE_MODE=MANUAL -
You execute a query by using the result_cache hint. Which statement is true in this scenario?

The query results are not stored because no memory is allocated for the result cache

The query results are stored and 0.5% of the memory target is allocated to the result cache

The query results are stored and 0.25% of the memory target is allocated to the result cache

The query results are not stored because the RESULT_CACHE_MODE parameter is not set to FORCE

Correct Answer: C

Question 7 of 117

Which three actions can be performed by using the DMBS_ASSERT package to prevent SQL injection? (Choose three.)

Detect a wrong user

Check input string length

Verify qualified SQL names

Validate TNS connect strings

Verify an exisitng schema name

Enclose string literals within double quotation marks

Correct Answer: C, E, F

Question 8 of 117

You designed a CardValidation.java java source file. You also have the corresponding CardValidation.class file. As part of invoking a Java class method, you executed this command at the command prompt:
Loadjava -user oe/oe CardValidation.java
Which statement is true about the command?

It loads the Java code into the database

It publishes Java methods in CardValidation.java

It loads the metadata related to the Java class file into the database

It loads the java class file into the Java pool in the database instance

Correct Answer: A

Question 9 of 117

See the Exhibit:
Exam 1z0-146: Question 9 - Image 1

Examine the strucutre of the EMPLOYEES and DEPARTMNETS tables.
See the PL/SQL block that you execute to find the average salary for employees in the 'Sales' department.
Exam 1z0-146: Question 9 - Image 2

What is the outcome?

It executes successfully and gives the correct output

It generates an error because the assocaitive array definition is not valid

It generates an error because an assocaitive array cannot be passed to a procedure in OUT mode

It generates an error because an associative array cannot be used with the SELECT INTO statement

Correct Answer: A

Question 10 of 117

Examine the following settings for a session:

Which statement would be true in this scenario?

The compiler would automatically inline subprograms

The compiler would inline the code for external subroutines

The compiler would inline the code even if the INLINE pragma is set to NO

The compiler would not inline the code unless the INLINE pragma is set to YES

Correct Answer: A