Oracle Database Administration II 認定 1Z0-083 試験問題 (Q198-Q203):
質問 # 198 Which three are true about Database Point-in-Time Recovery?
A. The database must be open resetlogs after Database Point-in-Time Recovery.
B. The target point for the recovery must be specified as a time or System Change Number (SCN).
C. The database must be in mount state when performing Database Point-in-Time Recovery.
D. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
E. The database must have flashback database on to perform Database Point-in-Time Recovery.
F. The database must be in archivelog mode.
正解:A、B、F 質問 # 199 A container database called CDB1 is OMF-enabled. PDBFILENAMECONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1: CREATE PLUGGABLE DATABASE pdb1 USING '/u01/app/oracle/oradata/pdb1.xml' SOURCEFILENAMECONVERT = ('/u01/app/oracle/oradata/', '/u02/app/oracle/oradata/'); Which two are true? (Choose two.)
A. DBMSPDB.CHECKPLUG_COMPATIBILITY must be run in CDB1 before executing the command.
B. /u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.
C. PDB1 must be dropped from CDB1.
D. PDBFILENAME_CONVERT must be set before executing the command.
E. PDB1 data files already exist in the correct location.
正解:C、E 質問 # 200 choose two Which two are true about RMAN image copies?
A. They can be encrypted using Transparent Data Encryption (TDE).
B. They can be used as a level 1 incremental backup.
C. They are the only backup option available for databases in NOARCHIVELOG mode.
D. They can only be written to disk.
E. They can be used as a level 0 incremental backup.
正解:D、E 質問 # 201 Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)
A. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
B. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.
C. A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
D. The RMAN SHOW ALL command displays only settings with nondefault values.
E. A target database's persistent RMAN configuration settings are always stored in the target's control file
F. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.
G. A DBA must specify either a redundancy retention policy or a recovery window retention policy.
正解:B、E、F 質問 # 202 Which two are true about the Oracle database tuning methodology?
A. SQL statements should always be tuned before tuning any file systems.
B. The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
C. The alert log should be used to find the database and instance areas most in need of tuning.
D. Tuning activities should stop once agreed service levels for performance have been met.
E. The database instance memory should always be tuned before tuning any file systems.
F. Tuning activities should stop once the user is satisfied with performance.