Oracle 1Z0-060 dumps - 100% Pass Guarantee!

An Automatic Database Diagnostic Monitor (ADDM) finding in your production database reports that the shared pool is inadequately sized. You diagnose that this is due to the different kinds of workloads and this occurs only during peak hours. The following are the parameter settings for the database instance: You want to balance the memory between the System Global Area (SGA) components depending on the workload.

Which option would solve this problem?

A. setting the PGA_AGGREGATE_TARGET parameter to 200M and the SGA_MAX_SIZE parameter to 400M

B. setting the MEMORY_TARGET and SGA_MAX_SIZE parameters to 400M

C. setting the SGA_TARGET parameter to 300M

D. setting the SGA_MAX_SIZE parameter to 400M

Examine the current values for the following parameters in your database instance:

SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M

You issue the following command to increase the value of DB_8K_CACHE_SIZE:

SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;

Which statement is true?

A. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.

B. It succeeds only if memory is available from the autotuned components if SGA.

C. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.

D. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

Examine the following query output:

You issue the following command to import tables into the hr schema:

$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y

Which statement is true?

A. All database operations performed by the impdp command are logged.

B. Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.

C. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.

D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

You configure your database Instance to support shared server connections.

Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?

A. User session data

B. Stack space

C. Private SQL area

D. Location of the runtime area for DML and DDL Statements

E. Location of a part of the runtime area for SELECT statements

Which two statement are true about the installation modes in Oracle Database 12c? (Choose two.)

A. In silent mode installation, you can validate the parameter values on installation screens for which you have provided information in the response file.

B. In interactive mode, parameter values are read from a response file and can be changed during installation.

C. Response file mode is useful when you require multiple Oracle Homes with variation in some of the installation parameters for each home.

D. In response file mode, you can include responses for some or all prompts.