Oracle 1Z0-058 問題集

質問 1：
Which three statements are true about ASM performance and scalability?
A. Multiple databases that use a separate diskgroup for each database make the best use of space.
B. A database needs a separate diskgroup for each major tablespace, redo logs, and fast recovery area.
C. Disks in a diskgroup should match in speed and capacity for best performance.
D. Disks in a diskgroup may be of varying speed and capacity without affecting performance.
E. Multiple databases that use the same diskgroup make the best use of space.
F. A database seldom needs more than two diskgroups: one for data and the other for a fast recovery area.
正解：C,E,F
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You plan to use Enterprise Manager to locate and stage patches to your Oracle Home.
The software library has been configured to be downloaded to /u01/app/oracle and your "My Oracle Support" credentials have been entered.
You want to start the provisioning daemon in order to use the deployment procedure manager to view, edit, monitor, and run deployment procedures.
How would you start the provisioning daemon?
A. using srvctl start paf
B. using crsctl start paf
C. using emctl start paf
D. using pafctl start
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which two actions in a warehousing RAC database may cause concurrent cross-instance calls leading to I/O contention?
A. select statements referring to non-partitioned tables
B. insert statements where each instance inserts into different partitions of a partitioned table
C. drop table statements
D. truncate table statements
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which three programs or utilities can be used to convert a single-instance database to a Real Application Cluster database?
A. the RCONFIG utility
B. DBCA
C. the CRSCTLl utility
D. Enterprise Manager
E. the SRVCTL utility
正解：A,B,D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
The Global Cache Block Access Latency chart shows high elapsed times. What are two possible causes for this?
A. badly written SQL statements
B. slow or faulty interconnect
C. storage network bottlenecks
D. a large number of requested blocks not cached in any instance
正解：A,B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
When creating an Oracle Cluster database using DBCA the "Memory size (SGA and PGA)" field is
supplied on value of 2000 MB. Identify the default block Size used for the database.
A. 8 KB
B. 16 KB
C. 32 KB
D. 2 KB
E. 4 KB
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 7：
An ASM diskgroup that contains database tablespaces with six disks and normal redundancy is nearing 90% capacity. You want to add additional capacity to the diskgroup. A set of six additional disks has been made available, and appears as CANDIDATE disks in the V$ASM_DISK view.
What steps are required to increase the diskgroup capacity?
A. Set the rebalance power limit (or allow it to default).
Add the disks to the diskgroup.
B. Shut down the database instances using the diskgroup.
Add the disks to the diskgroup.
Start the database instances using the diskgroup.
C. Export the database objects.
Drop the diskgroup.
Create a new diskgroup.
Import the database objects.
D. Shut down all database instances and ASM instances.
Back up the ASM diskgroup.
Start the ASM instances.
Add the disks to the diskgroup.
Issue a rebalance command.
Start the database instances.
正解：A
解説: (Topexam メンバーにのみ表示されます)