1z1-062 無料問題集「Oracle Database 12c: Installation and Administration」

（A）It writes when it receives a signal from the checkpoint process (CKPT).

（B）It writes after the Database Writer process writes dirty buffers to disk.

（C）It writes when a user commits a transaction.

（D）It writes concurrently to all members of multiplexed redo log groups.

（A）It divides files into extents and allows an extent to span disks.

（B）It mounts databases and diskgroups to make ASM files available to database instances.

（C）It mirrors data at the allocation unit (AU) level across failure groups within a normal or high redundancy diskgroup.

（D）It spreads files proportionally across all disks in a diskgroup, aiming to ensure that all the disks in a diskgroup have the same I/O load.

（E）It automatically places each disk from an external redundancy diskgroup in its own failure group.

（A）to update the recovery catalog or control file if archived log files are deleted with operating system commands

（B）to synchronize logical backup records with physical files in backup storage

（C）to update information about backups that are deleted, corrupted, or inaccessible in a recovery catalog or control file

（D）to validate the database backup

（E）to check the obsolete backups that can be deleted from the file system

（A）The target remote database must be on a different host form the originating scheduler database host.

（B）A private database link must be created from the originating database to the target remote database.

（C）The target remote database on which the job is scheduled must be Oracle Database 11g Release 2 or later.

（D）The remote database job must run as a user that is valid on the target remote database.

（A）Use Database Resource Manager to automatically kill the sessions that are idle and are blocking other sessions.

（B）Increase the maximum number of ITL slots for segments on which a blocking user performs a transaction.

（C）Decrease the IDLE_TIME resource limit in the profiles assigned to blocking users.

（D）Decrease the SESSIONS_PER_USER limit in the profiles assigned to blocking users.

（E）Set a limit in the proles of blocking users to control the number of data blocks that can be accessed in a session.

（A）SQL Access Advisor with a SQL tuning set

（B）Automatic Database Diagnostic Monitor (ADDM) report

（C）SQL Access Advisor with a hypothetical workload

（D）SQL Performance Analyzer

（E）SQL Tuning Advisor

（A）All redo log entries in the current log are applied to data files until the checkpoint position is reached.

（B）All current, online, and archived redo logs are required to complete instance recovery.

（C）All redo log entries in the current and active logs are applied to data files to reconstruct changes made after the most recent checkpoint.

（D）All current, active, and inactive redo logs are required to complete instance recovery.

（A）Run utlrp.sql to recompile stored PL/SQL and Java code and check the DBA_REGISTRY view.

（B）Run catuppst.sql to perform revalidation actions

（C）Run utluiobj.sql to filter out objects that were invalidated by the upgrade process.

（D）Run preupgrd.sql and then execute the generated "fix-up" scripts to resolve status issues.

（A）It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.

（B）It executes successfully but neither tablespace nor the data file is created.

（C）It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.

（D）It falls and reports an error because there can be only one undo tablespace in a CDB.

（E）It executes successfully and creates an UNDO tablespace in HR_PDB.

（A）RMAN backups that are obsolete

（B）user-managed backups of data files and control files

（C）flashback logs

（D）Archived redo log files that have multiple copies in a different archive location

（A）The initialization parameter REMOTE_OS_AUTHENT must be set to TRUE on your database.

（B）Database links to remote databases must be created.

（C）The local database must be set up to run remote external jobs.

（D）The remote system's scheduler agent must be registered with your database.

（E）The remote system must have a running Oracle Database instance and a scheduler agent installed.

（A）Perform a direct upgrade by running the Database Upgrade Assistant (DBUA).

（B）Install the Oracle Database 12c software, create a new Oracle 12c database, and then use the Oracle Data Pump to import data from the source Oracle 9i database to the target Oracle 12c database.

（C）Upgrade your current database to Oracle Database release 10.2.0.5, and then upgrade to Oracle Database
12c.

（D）Perform a rolling upgrade.

（E）Perform a direct upgrade by manually running the catctl.pl and catupgrd.sql scripts before issuing the STARTUPUPGRADE command.

（A）Database Writer (DBWn) processes write checkpoint information to datafile headers and the control file

（B）Frequent thread checkpoints can degrade database performance

（C）It reduces the recovery time from instance failures

（D）Thread checkpoints ensure that all dirty buffers are written to data files during a normal shutdown

（E）Incremental checkpoints write some dirty buffers to the datafiles and unwritten redo to the online redo logs.

（A）The PGA_AGGREGATE_TARGET parameter is set to zero.

（B）The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.

（C）Both the SGA_TARGET and MEMORY_TARGET parameters are set.

（D）The STATISTICS_LEVEL parameter is set to BASIC.

（A）Password complexity checking is enforced for user HR.

（B）User HR is permitted to create more than three concurrent sessions.

（C）User HR sessions will terminate after ten minutes of continuous inactivity.

（D）The password complexity will not enforce on the HR account.

（E）The HR account will get locked by Oracle after ten consecutive failed login attempts.

（F）The HR account will be locked after three consecutive failed login attempts.

（A）It requires at least four AWR snapshots for analysis.

（B）It runs after each AWR snapshot is created and it requires at least two snapshots for analysis.

（C）It always compares the latest snapshot with the baseline snapshot for analysis.

（D）It measures database performance by analyzing the wait time and CPU time of all non-idle user sessions.

（E）It calls other advisors if required, but does not provide recommendations about the advisors to be used.

（A）Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
OCP.EXAM_RESULTS; connected as SYSTEM.

（B）Recover the table using traditional Tablespace Point In Time Recovery.

（C）Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
EXAM_RESULTS; connected as the OCP user.

（D）Recover the table using Automated Tablespace Point In Time Recovery.

（E）Recovery the table using Database Point In Time Recovery.