최신Oracle Upgrade to Oracle Database 12c - 1Z0-060무료샘플문제

A. Second normal form

B. Third normal form

C. Fourth normal form

D. First normal form

A. Oracle Database Vault

B. Oracle Label Security

C. Oracle Data Pump

D. Oracle Recovery Manager (RMAN)

E. Oracle Real Application Security

A. System privileges apply only to the PDB in which they are used.

B. The granter of system privileges must possess the set container privilege.

C. Common users connected to a PDB can exercise privileges across other PDBs.

D. System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.

E. Local users cannot use local system privileges on the schema of a common user.

A. Local indexes must be rebuilt manually after moving the partitions.

B. The partitions can be compressed in the same tablespaces.

C. The partitions can be compressed in the new tablespaces.

D. Global indexes must be rebuilt manually after moving the partitions.

E. The partitions can be moved online to new tablespaces.

A. It can detect corrupt block change tracking files.

B. It can detect corruptpfiles.

C. It checks the database for interblock corruptions.

D. It can detect corruptspfiles.

E. It checks the database for intrablock corruptions.

A. The CDB must be in the nomount stage.

B. The CDB must be open.

C. Alt existing PDBs must be closed.

D. The CDB must be in the mount stage.

A. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

B. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.

C. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.

D. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

E. Data is never redacted for the EMP_V.SAL column.

A. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

B. The change tracking file must always be backed up when you perform a full database backup.

C. Block change tracking will always reduce I/O performed during cumulative incremental backups.

D. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.

E. More than one database block may be read by an incremental backup for a change made to a single block.

A. Instance recovery is always performed at the CDB level.

B. Different PDBs can have different default block sizes.

C. A PDB can have a private temp tablespace.

D. PDBs can share the sysaux tablespace.

E. Each pluggable database (PDB) has its own set of background processes.

F. PDBs share a common system tablespace.

G. Log switches occur only at the multitenant container database (CDB) level.

A. 2, 3, 4, 1

B. 4, 1, 3, 2

C. 3, 2, 1, 4

D. 3, 2, 4, 1

A. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.

B. Increase the database buffer cache size.

C. Configure the RECYCLE bufferpool and alter the table with the corresponding storage clause.

D. Configure Automatic Memory Management-

E. Configure Automata Shared Memory Management.

A. PGA size can grow automatically beyond 500 MB.

B. Memory is dynamically re-allocated between SGA and PGA as needed.

C. Only the components of SGA are managed automatically.

D. The value of the memory_target parameter cannot be changed dynamically.

A. It executes successfully. The modification to add the default value takes effect only from subsequent insertions to the table.

B. It produces an error because the data type for the column is not specified.

C. It produces an error because column definitions cannot be altered to add default values.

D. It executes successfully and all the rows that have a null value for the country column will be updated with the value 'USA'.

A. Increasing the value of the JOB_QUEUE_PROCESSES parameter

B. Increasing the priority of the scheduler window to which the job belongs

C. Increasing the job's relative priority within the Job class to which it belongs

D. increasing resource allocation for the consumer group mapped to the job class in the resource manager plan associated with the scheduler window

E. Moving the job to an existing higher priority scheduler window with the same schedule and duration