1z0-034無料問題集「Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP」

質問 1

You execute these RMAN commands:
BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do?

（A）create a backup of the database and recover all corrupted blocks found in the backup

（B）perform a backup validation and list all logically and physically corrupt blocks in the database

（C）create an image copy of the database and recover all corrupted blocks found in the image copy

（D）perform a backup validation and populate the memory structure used by the vsDATABASE_BLOCK_CORRUPTION view, then recover any corrupt blocks

（E）perform a backup validation and populate the memory structure used by the vscopy_corruption view with details of any corrupt blocks found

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 2

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.
One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;
Which action should you perform immediately after using this command?

（A）You should switch the database to the NOARCHIVELOG mode

（B）You should make a backup of the database

（C）You should perform a log switch

（D）You should shut down the database instance and perform a complete database recovery

正解：B 解答を投票する

質問 3

You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in / etc. Which two statements are true regarding this oranfstab file? (Choose two.)

（A）It contains file systems that have been mounted by Direct NFS.

（B）It is globally available to all Oracle 11g databases on the machine.

（C）Its entries are specific to a single database.

（D）It contains file systems that have been mounted by the kernel NFS system.

正解：B、D 解答を投票する

質問 4

You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?

（A）Open the database in NORMAL mode

（B）Open the database in RESTRICTED mode

（C）Open the database with the RESETLOGS option

（D）Mount the database

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 5

Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)

（A）An ASM instance uses the ASMB process for rebalancing of disks within a disk group

（B）Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly

（C）An ASM instance mounts an ASM control file

（D）An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

正解：B、D 解答を投票する

質問 6

Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

（A）It can be used to control the time interval for which the access privilege is available to a user.

（B）It can be used to allow the access privilege settings for users as well as roles.

（C）It can be used to allow the access privilege settings for users but not roles.

（D）It can be used to selectively restrict the access for each user in a database to different host computers.

（E）It can be used to selectively restrict a user's access to different applications in a specific host computer.

正解：A、B、D 解答を投票する

質問 7

There was media failure and you decide to check the data files for block corruption. Which would you use to create a report on any corruptions found?

（A）the CHECK_OBJECT procedure of the DBMS_REPAIR package

（B）the RMAN REPORT command

（C）the DBNEWID utility

（D）the RMAN CROSSCHECK command

（E）the DBVERIFY utility

（F）the ANALYZE command

正解：E 解答を投票する

質問 8

The DB_BLOCK_CHECKING parameter is set to FULL.
What checks occur each time the DBWnprocess(es) writes?

（A）The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by going through the data on each block, making sure the data is self-consistent.

（B）The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through the data on each block, making sure the data is self-consistent.

（C）The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through the data on each block, making sure the data is self-consistent.

（D）The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.

（E）The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.

正解：D 解答を投票する

質問 9

You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is (jetting filled up very fast and it is running out of space. Your database flash recovery area is low on specie and you have no more room on disk.
Proactively, which two options could you use to make more space available in the flash recovery [Choose two]

（A）Change the RMAN archived log deletion policy.

（B）Use OS command to move files from the flash recovery area to some other location

（C）Use the RMAN CROSSCHECK command to reclaim the archived log space.

（D）Change the RMAN retention policy to retain backups for a shorter period of time.

正解：B、C 解答を投票する

1z0-034 無料問題集「Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP」

弊社を連絡する

関連リンク

トップ試験