Oracle 1Z0-058 問題集

質問 1：
As part of the preinstatlation process for adding two new nodes to your four-node UNIX cluster, you are in discussions with the OS administrators about the operating system Installation and setup for the two new nodes called RACNODE5 and RACNODE6.
The nodes have already been connected to the network infrastructure and the administrators are ready for the OS installation. Which two methods fulfill the installation requirements?
A. Install a new image of the OS, then configure SSH for the root user.
B. Install a cloned image of the OS that at least matches the existing node images for drivers, patches, and updates.
C. Install a new image of the OS that at least matches the existing node Images for drivers.
D. Install a new image of the OS, and create the necessary OS users and groups with any user and group IDs.
E. Install a new image of the OS, that at least matches an existing node for drivers, patches, and updates, and create the necessary OS users and groups with user and group IDs matching those on the existing nodes.
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You notice that there is a very high percentage of wait time for RAC database that has frequent insert operations.
Which two recommendations may reduce this problem?
A. using reverse key indexes
B. automatic segment space management
C. smaller extent sizes
D. uniform and large extent sizes
E. increasing sequence cache sizes
F. shorter transactions
正解：B,D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
A policy-managed RAC database that hosts the ACCOUNTS service has only three instances running rather than the usual four on a six-node cluster.
Five of the six cluster nodes are active and the sixth (RACNODE6) is down for maintenance.
You decide to check the state of the servers in the server pools to see if there are problems with the OLTP pool to which the ACCOUNTS service has been assigned.
You used the ctsctl status server -f command and see that the RACNODE3 node has STATE=VISIBLE.
What is true about this situation?
A. Neither the Cluster Ready Services Daemon (CRSD) nor the Cluster Synchronization Services Daemon (CSSD) is running on RACNODE3.
B. The Cluster Synchronization Services Daemon (CSSD) is running RACNODE3 is considered to be part of the cluster, but the Cluster Ready Services Daemon (CRSD) is currently not running.
C. The Cluster Ready Services Daemon (CRSD) is running and RACNODE3 is considered to be part of the cluster, but the Cluster Synchronization Services Daemon (CSSD) is currently not running.
D. Both the Cluster Ready Services Daemon (CRSD) and the Cluster Synchronization Services Daemon (CSSD) are running on RACNODE3, but RACNODE3 is currently being moved to another server pool.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You are managing a policy-managed Real Application Cluster (RAC) database, RACDB with Oracle Managed Files (OMF) enabled. Examine the following outputs:

You added a new server to the server pool using the following command: [oracle@gr5153 ~]$ srvctl modify srvpool -g POOL1 -i 0 -l 2 -u 4 -n gr5119 The instance on the newly added node is started by the Oracle Clusterware. Automatic Storage
Management (ASM) is used as the storage option.
Which statement is true regarding the redo log files for the instance?
A. You must create redo log groups for the newly added service.
B. Oracle Clusterware automatically creates and enables a new thread of red
C. Redo log members will not be created automatically because storage option used is ASM.
D. The newly added instance must save full online log groups tracked in the control file.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You want to check an ACFS for consistency on the Linux platform. Which command-line tool would you use to do this?
A. advmutil
B. acfsutil
C. fsck
D. asmcmd
E. fdisk
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Directory structure in ASM has a default of +<diskgroup>/<database>/<filetype>/<filename>.
The EXAMPLE tablespace was created with:
CREATE TABLESPACE EXAMPLE DATAFILE '+DATA/ORCL/oradata/example_01.dbf'
The asmcmd ls command shows:
ASMCMD>ls -l +DATA/ORCL/oradata/*
Type Redund Striped Type Sys Name
N example_01.dbf => +DATA/ORCL/DATAFILE/EXAMPLE.264.695918623
Which three statements can be verified by from the information provided?
A. The ASM system file +DATA/ORCL/DATAFILE/EXAMPLE.264.695918623 has an alias of +DATA/ORCL/oradata/example_01.dbf.
B. +DATA/ORCL/DATAFILE/EXAMPLE.264.695918623 is the name of the file in V$DBFILE in the database instance.
C. The default path indicates that the file is a data file belonging to the ORCL database.
D. The default path indicates that the file is an oradata file belonging to the ORCL database.
E. The ASM file +DATA/ORCL/oradata/example_01.dbf has an alias of +DATA/ORCL/DATAFILE/EXAMPLE.264.695918623.
F. +DATA/ORCL/oradata/example_01.dbf is the name of the file in V$DBFILE in the database instance.
正解：A,B,C
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which three statements are true about Oracle Clusterware component log files?
A. Oracle RAC uses a common unified log directory structure to store all Oracle Clusterware component log files.
B. The location of the log directory structure is <Grid_Home>/log/<hostname>.
C. The log directory structure is the same on UNIX and Linux systems, but different on Windows platforms.
D. The Clusterware and Database log files are stored under the same unified directory structure.
E. The consolidated directory structure simplifies diagnostic information collection and assists during data retrieval and problem analysis.
正解：A,B,E
解説: (Topexam メンバーにのみ表示されます)