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

A. CDB1, PDB$SEED, PDB1, and PDB2

B. CDB1 and PDB$SEED only

C. CDB1, PDB$SEED, and PDB1 only

D. CDB1, PDB1, and PDB2 only

E. PDB$SEED, PDB1, and PDB2 only

A. It has the same number of roles as CDB1.

B. It has the same common users defined as does CDB1.

C. Service PDB1 is created for remote logins to PDB1.

D. It is in mount state after creation.

E. It has no local users.

F. It has only local roles.

A. It analyzes a period of time corresponding to the last day of activity.

B. It runs automatically after each AWR snapshot.

C. It analyzes a period of time corresponding to the 12 hours of activity.

D. Results are written to the alert log.

E. A DBA can run it manually.

A. Space might be reclaimed proactively before space pressure occurs.

B. Space is always reclaimed proactively before space pressure occurs.

C. Space is always reclaimed automatically when the retention period for Flashback logs is lowered.

D. Space is only reclaimed when there is space pressure in the Fast Recovery Area. (FRA)

E. Space might be reclaimed automatically when the retention period for Flashback logs is lowered.

A. the location of Oracle Net Services configuration files

B. the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup

C. the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.

D. the maximum number of database files that can be opened by a database instance

E. default directories for temporary files used by temporary tablespaces

F. the temporary disk space used by Oracle Installer during installation

A. after losing an archived log from before the most recent backup

B. after losing all copies of the control file

C. after losing an archived log from after the most recent backup

D. after losing the SYSTEM tablespace

E. when any archived log from, before, or after the most recent backup is corrupt.

A. It replaces secure application roles.

B. It can encrypt data at the column level.

C. It stores the current and all past master keys in the keystore.

D. It uses a single master key for a database.

E. It encrypts only data on the client.

F. Master encryption keys are managed by Oracle Database Vault.

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. It can contain only one Application Container seed, which is created when the Application Container is created.

B. It can be created by cloning an existing CDB.

C. It can have local users with the same name in different PDBs.

D. It can have any number of pluggable databases (PDBs) limited only by space availability.

E. It contains predefined common roles in both the root and the seed.

F. It can be created from a non-CDB.

G. It can contain only one PDB$SEED, which is created when the CDB is created.

A. when the number of logons per second exceeds a specific value

B. when the total number of logons exceeds a specific value

C. when free space in a locally managed tablespace falls below a specified percentage

D. when a resumable statement is suspended

E. when free space in a dictionary managed tablespace falls below a specified percentage

F. when the total number of locked user account exceeds a specific value

A. The recovery catalog is synchronized from the target database control file with a full resync at the next backup.

B. The target database control file is synchronized from the recovery catalog with a partial resync at the next backup.

C. The target database control file is synchronized from the recovery catalog with a full resync at the next backup.

D. The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.

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. A new DBID is automatically created for the transported database.

B. The password file is automatically converted by RMAN.

C. Data files can be converted on the destination system.

D. Data files can be converted on the source system.

E. By default, the transported database will use Oracle Managed Files (OMF)

F. Databases can be transported between systems with different endian formats.