최신Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 - 1z1-074무료샘플문제

A. Altering the DB_CACHE_SIZE results in an error because SGA_TARGET should be altered to 600M first.

B. SGA_TARGET is set to 600M.The other values remain unchanged in both ORCL and ORCL_PDB.

C. Altering the DB_CACHE_SIZE results in an error because it cannot be altered in a PDB.SGA_TARGET size is changed to 600 M.

D. SGA_TARGET is set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDThe other values remain unchanged in both ORCL and ORCL_PD

E. SGA_TARGET and SGA_MAX_SIZE are set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDB.SGA_TARGET and SGA_MAX_SIZE are set to (1360-600)M and DB_CACHE_SIZE to
200M in ORCL.

A. Any data in the In-Memory column store is copied in compressed columnar format to the FS_TBS tablespace.

B. All columns for all tables in the FS_TBS tablespace are loaded into the In-Memory column store.

C. Any data in the In-Memory column store is copied in uncompressed columnar format to the FS_TBS tablespace.

D. Any data in the In-Memory column store is copied in row major format to the FS_TBS tablespace.

A. An error is returned

B. TESTDBA is created will the SYSDBA privilege and the message "The result is 3" is displayed

C. The message "The result is 3" only is displayed

D. Only "3" is displayed

E. TESTDBA is created with the SYSDBA privilege only

A. If TFA is installed on any cluster node, it automatically collects diagnostic data on all other cluster nodes.

B. In Oracle 12c Release 2, TFA installation can be done only while executing root.sh.

C. It can be used to collect diagnostic data for predefined events, and can be configured to automatically collect data for other events.

D. It is used to collect diagnostic data only for ORA-600, ORA-7445, and ORA-4031 events.

E. TFA collects diagnostic data only for Oracle 12c Release 2 databases or later versions.

A. for query performance only

B. for space saving only

C. for query performance and space saving with greater bias toward space saving

D. for parallel query performance only

E. for query performance and space saving

A. It returns an error because the AUTOMATIC option must be specified.

B. It returns an error because only a single column key can be used for a list-partitioned table.

C. It creates partitions P1 and P2 where COUNTRY and CHANNEL are multi-column partition keys.

D. It returns an error because only one set of multiple values can be specified for each partition.

E. It creates partitions P1 and P2 where COUNTRY is a single column partition key and CHANNEL is a subpartition key.

A. when a user creates a new user

B. when a user queries a BEQUEATH CURRENT_USER view that references an invoker's right procedure

C. when a user performs a GRANT or REVOKE operation

D. when a user runs a procedure created with invoker's right

E. when a user runs a procedure created with definer's right

A. They may be recovered to a different schema in the same pluggable database (PDB)

B. They must be un-partitioned tables

C. They can be recovered by RMAN without an AUXILIARY instance

D. An AUXILIARY instance is started only if there is sufficient disk space

E. They may be recovered to a schema in a different PDB