iostat disk1 1
iostat -d disk1 2
iostat disk2 1
iostat -d disk2 2
第1题:
YouareworkingasaDBAinanorganization.Theflashrecoveryareafilesarecreatedin’+disk1’.Youwanttocreatenewflashrecoveryareafilesinthe’+disk2’location.Thenewlocationoftheflashrecoveryareafilesshouldbewritteninthecontrolfileandthespfile.Whichcommandwillyouissuetochangethelocationoftheflashrecoveryareafiles?()
A.ALTERSYSTEMSETDB_RECOVERY_FILE_DEST=’+disk2’;
B.ALTERSYSTEMSETDB_RECOVER_FILE_DEST=’+disk2’SCOPE=BOTH;
C.ALTERSYSTEMSETDB_CREATE_FILE_DEST=’+disk2’;
D.ALTERSYSTEMSETDB_CREATE_ONLINE_LOG_DEST_n=’+disk2’;
第2题:
A.iostatdisk11
B.iostat-ddisk12
C.iostatdisk21
D.iostat-ddisk22
第3题:
All of the following types of statistics are reported by the iostat command tool EXCEPT:().
第4题:
Which of the following commands should be used to observe the number of system calls per second? ()
第5题:
If a system administrator wants to show only a disk report for disk2, at two second intervals, what is the correct command to run?()
第6题:
Which of the following commands should be used to determine which disk of a system is experiencing a disk I/O performance problem?()
第7题:
You are working as a DBA in an organization. The flash recovery area files are created in ’+disk1’. You want to create new flash recovery area files in the ’+disk2’ location. The new location of the flash recovery area files should be written in the control file and the spfile.Which command will you issue to change the location of the flash recovery area files?()
第8题:
You have just added three new hard disks to your Windows 2000 Professional computer. You want to configure all of the disks as two drives. You want the two drives to be as equal in size as possible. You want to configure the non-system drive for the best optimal performance. What should you do?()
第9题:
when all the control files are missing and only a binary backup of the current control file exists
when a multiplexed copy of the current control file is missing
when all the control files are missing and only an ASCII representation of the binary control file exists
when the SPFILE is missing
第10题:
sar
iostat
svmon
vmstat
第11题:
Extend the system volume onto disk1. Create a single, stripe volume from disk2 and disk3.
Extend the system volume onto disk2. Create a single, stripe volume from disk1 and disk2
Extend the system volume onto disk1. Create a single, spanned volume from disk2 and disk3.
Extend the system volume onto disk1. Create a single, spanned volume from disk1 and disk2.
Create a single, stripe volume from disk1, disk2, and disk3.
Create a single spanned volume from disk1, disk2, and disk3.
第12题:
ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo01b.log’ TO GROUP 1;
ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo01b.log’ TO GROUP 1;
ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo02b.log’ TO GROUP 2;
ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo02b.log’ TO GROUP 2;
ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo3b.log’ TO GROUP 3;
ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo3b.log’ TO GROUP3;
第13题:
Inwhichsituationwillyourunthescriptcontainingthefollowingstatement?()
CREATECONTROLFILEREUSEDATABASESALESNORESETLOGSARCHIVELOG
MAXLOGFILES20
MAXLOGMEMBERS3
MAXDATAFILES30
MAXINSTANCES10
MAXLOGHISTORY1200
LOGFILE
GROUP1(
’/disk1/prod/orders/db/log1a.dbf’,
’/disk2/prod/orders/db/log1b.dbf’
)SIZE100K
GROUP2(
’/disk1/prod/orders/db/log2a.dbf’,
’/disk2/prod/orders/db/log2b.dbf’
)SIZE100K,
DATAFILE
’/disk1/prod/orders/db/database1.dbf’,
’/disk2/prod/orders/db/file1.dbf’;
第14题:
A.添加一个磁盘,创建一个新的RAID-5卷
B.用disk1和disk2创建一个带区卷
C.用disk1和disk2创建一个镜像卷
D.用disk1和disk2创建一个跨区卷
第15题:
Examine the RMAN command: SWITCH DATAFILE ’/DISK3/user_data01.dbf’; Which command do you need to issue before you issue the above command, so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’? ()
第16题:
Which of the following metrics provided by the iostat report is used to initially determine if a disk is I/O bound?()
第17题:
Which of the following phrases is TRUE regarding monitoring disk I/O with iostat?()
第18题:
In which situation will you run the script containing the following statement?() CREATE CONTROLFILE REUSE DATABASE SALES NORESETLOGS ARCHIVELOG MAXLOGFILES 20 MAXLOGMEMBERS 3 MAXDATAFILES 30 MAXINSTANCES 10 MAXLOGHISTORY 1200 LOGFILE GROUP 1 ( ’/disk1/prod/orders/db/log1a.dbf’, ’/disk2/prod/orders/db/log1b.dbf’ )SIZE 100K GROUP 2 ( ’/disk1/prod/orders/db/log2a.dbf’, ’/disk2/prod/orders/db/log2b.dbf’ ) SIZE 100K, DATAFILE ’/disk1/prod/orders/db/database1.dbf’, ’/disk2/prod/orders/db/file1.dbf ’;
第19题:
You have the following online redo log configuration: Group Member 1 ’/disk1/oradata/redo01a.log’ 2 ’/disk2/oradata/redo02a.log’ 3 ’/disk3/oradata/redo03a.log’ You decide to multiplex the online redo log groups for recovery of redo log files in case of any disaster. Which two statements will you NOT issue to multiplex the online redo log files?()
第20题:
CPU
Memory
Paging space
Disk capacityX
第21题:
Extend the system volume onto disk1. Create a single, stripe volume from disk2 and disk3.
Extend the system volume onto disk2. Create a single, stripe volume from disk1 and disk2.
Extend the system volume onto disk1. Create a single, spanned volume from disk2 and disk3.
Extend the system volume onto disk1. Create a single, spanned volume from disk1 and disk2.
Create a single, stripe volume from disk1, disk2, and disk3.
Create a single spanned volume from disk1, disk2, and disk3.
第22题:
iostat disk1 1
iostat -d disk1 2
iostat disk2 1
iostat -d disk2 2
第23题:
The iostat can only be run as the root user
There could be zero percent I/O wait and still be an I/O bottleneck
Any I/O wait time displayed in output of iostat is an indication of severe I/O bottlenecks
Running iostat without any arguments/parameters is sufficient for resolving I/O bottlenecks
第24题:
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ’+disk2’ ;
ALTER SYSTEM SET DB_RECOVER_FILE_DEST = ’+disk2’ SCOPE = BOTH;
ALTER SYSTEM SET DB_CREATE_FILE_DEST = ’+disk2’;
ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_n = ’+disk2’;