1z0-062 試験問題を無料オンラインアクセス

Examine the following parameters for a database instance:
MEMORY_MAX_TARGET=0
MEMORY_TARGET=0
SGA_TARGET=0
PGA_AGGREGATE_TARGET=500m
Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)

• A.STREAMS_POOL_SIZE
• B.DB_KEEP_CACHE_SIZE
• C.JAVA_POOL_SIZE
• D.SORT_AREA_SIZE
• E.DB_16K_CACHE_SZIE
• F.LOG_BUFFER

Which two statements are true about a server parameter file (SPFILE)? (Choose two.)

• A.A PFILE can be used to start up a database instance even if an SPFILE exists.
• B.An SPFILE can be created only before a database instance is started.
• C.An SPFILE must reside in the ORACLE_HOME/dbs directory.
• D.An SPFILE contains only those dynamic parameters that can be changed without having to restart the database instance.
• E.An SPFILE can be created from a PFILE or from memory.

You install "Oracle Grid Infrastructure for a standalone server" on a host on which the ORCL1 and ORCL2 databases both have their instances running.
Which two statements are true? (Choose two.)

• A.The crsctl start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete.
• B.All database listeners running from the database home are automatically added to the Oracle Restart configuration.
• C.Both ORCL1 and ORCL2 are automatically added to the Oracle Restart configuration.
• D.All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.
• E.The srvctl add database command must be used to add ORCL1 and ORCL2 to the ORACLE Restart configuration.

Examine the memory-related parameters set in the SPFILE of an Oracle database:

Which statement is true?

• A.The size of the PGA cannot grow automatically beyond 500 MB.
• B.The value of the MEMORY_TARGET parameter cannot be changed dynamically.
• C.Memory is dynamically re-allocated between the SGA and PGA as needed.
• D.Only SGA components are sized automatically.

Which statement is true regarding the DEFAULT profile?

• A.The values assigned to the resource limits and password parameters in the default profile can be altered.
• B.It can be dropped and recreated.
• C.A different DEFAULT profile can be created before each user in a database.
• D.it must be explicitly assigned to the user.