1z0-063 試験問題を無料オンラインアクセス

When is the UNDO_RETENTION parameter value ignored by a transaction?

• A.when there are multiple undotablespaces available in a database
• B.when Flashback Database is enabled
• C.when the undo tablespace is of a fixed size and retention guarantee is not enabled
• D.when the data file of the undo tablespace is autoextensible

Which three statements are true about automated maintenance tasks? (Choose three.)

• A.A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.
• B.A maintenance window is automatically extended until all the maintenance tasks defined are completed.
• C.Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor.
• D.They run at predefined time intervals that are intended to occur during a period of low system loads.
• E.An Oracle Scheduler job is created for each maintenance tasks that is scheduled to run in a maintenance window.

LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory (OID).
SSL has been configured for the database and OID and the password file has been configured for the database.
User scott with sysdba privilege tries to connect remotely using this command:
$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name.
Which authentication method will be attempted first?

• A.authentication by using the Oracle Internet Directory
• B.authentication by password file
• C.authentication by using certificates over SSL
• D.authentication by using the local OS of the database server

A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance? (Choose three.)

• A.Configure large pool if not already done.
• B.Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
• C.Always use RMAN compression for tape backups rather than the compression provided by media manager.
• D.Set the backup_tape_io_slaves parameter to true.
• E.Remove the rate parameter, if specified, in the allocate channel command.
• F.Always use synchronous I/O for the database.

One of your database suffered an instance failure.
At the next startup, from which point in the redo logs does instance recovery begin?

• A.from a point corresponding to the most recent successful transaction commit
• B.from a point corresponding to the most recent log switch checkpoint
• C.from a point corresponding to the most recent log instance checkpoint
• D.from a point corresponding to the most recent checkpoint of any kind
• E.from a point corresponding to the most recent incremental checkpoint