1Z0-083試験無料問題集「Oracle Database Administration II 認定」

A. PDB1 is always limited to 40% of the available system resources regardless of demand.

B. PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.

C. Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.

D. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.

E. PDB3 can use all available parallel execution processes at times.

F. Any PDB not specified in the plan will be unable to execute statements in parallel.

A. Flashback logs are maintained in the Flash Recovery Area.

B. Flashback logs are not archived.

C. Flashback logs are maintained in redo log files.

D. Flashback logs need to be cleared manually after you disable Flashback Database.

E. Flashback logs are used to maintain Flashback Database related errors.

A. They can be written only to disk.

B. They can be written to media.

C. They can be created by using the RMAN CONFIGURE command to specify duplexing before taking a backup.

D. They can be created only by using the COPIES option of a BACKUP command.

E. They must be written to media.

A. They can introduce new features.

B. They can be applied in a rolling fashion for Clusterware and the databases.

C. A base release is not needed to install patchsets.

D. They are only released quarterly.

E. Installing a patchset is considered an "upgrade".

F. They are installed via OPatch or OPatchAuto.

A. You can use it to create image copies for database files.

B. You can use it to create image copies for entire file systems.

C. You can use it to create backup sets for database files.

D. You can use it to create proxy copies for database files.

E. You can use it to create proxy copies for entire file systems.

A. to generate an XML metadata file that describes a non-CDB Oracle 12c database so that it can be plugged in as a PDB

B. to determine whether an XML file describes a PDB that can be plugged into the CDB in which you run the procedure

C. to generate an XML metadata file that describes the current plugged-in PDB

D. to generate an XML metadata file from any unplugged PDB

E. to generate a . pdb archive file for any PDB in the current CDB

A. The sudo password can be specified in a response file.

B. The root password cannot be specified in a response file.

C. orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.

D. The sudo password must be specified in a response file.

E. root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.

F. root.sh can be executed automatically by the Database installer only by using sudo credentials.

A. after losing an UNDO tablespace that is in use

B. after losing a SYSAUX tablespace data file

C. after losing all copies of the control file

D. after losing all members of an INACTIVE online redo log group

E. after losing all members of the CURRENT online redo log group

A. SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows.

B. SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows.

C. It will return an error because EMP is not empty in APP_ROOT.

D. It will return an error because EMP.SAL is empty in APP_ROOT.

E. It will return an error because the SYNC operation is not allowed when constraints are added to common objects.

A. 1, 3, 4, 5

B. 2, 4, 5

C. 2, 4, 5, 6

D. 1, 2, 4, 5

E. 1, 2, 3, 4, 5, 6

A. RMAN can recover a table after a DDL operation has altered the table structure.

B. RMAN can recover tables in the SYSTEM tablespace.

C. RMAN can recover tables in the SYSAUX tablespace.

D. RMAN can recover tables in a standby database.

E. RMAN always uses an auxiliary instance.

F. RMAN can recover tables owned by the SYS user.

G. RMAN can recover tables owed by the SYSTEM user.

A. PDB$SEED is in READ ONLY state.

B. PDB1 and PDB2 are in MOUNT state.

C. CDB$ROOT is in MOUNT state.

D. PDB1 and PDB2 are in READ ONLY state.

E. Redo logs are opened.

A. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-ENDblock.

B. Unified auditing can be automatically synchronized to all application PDBs in an application container.

C. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.

D. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.

E. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-ENDblock.

F. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-ENDblock.

G. Application-common TSDP policies are always container specific.

A. The source PDB can be in MOUNT or OPEN state.

B. A backup of the PDB must exist, taken using the BACKUP command with the To PLATFORM clause.

C. The source PDB must not be an application root.

D. The source and target platforms must have the same endianess.

E. Automatic conversion of endianess occurs.

F. The source PDB must be in MOUNT state.