网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch? （）(Choose two.)
- A、An entry is created in the alert log file and the database instance continues to function normally
- B、The log switch hangs occur for transactions until free space is available in the flash recovery area
- C、The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area
- D、The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented
参考答案
更多 “ While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch? （）(Choose two.)A、An entry is created in the alert log file and the database instance continues to function normallyB、The log switch hangs occur for transactions until free space is available in the flash recovery areaC、The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery areaD、The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented” 相关考题
考题
【程序说明】 下列输出乘法口诀的程序，要求输出的格式如下，其中数字之间有3个空格。* 1 2 3 4 5 6 7 8 91 12 2 43 3 6 94 4 8 12 165 5 10 15 20 256 6 12 18 24 30 367 7 14 21 28 35 42 478 8 16 24 32 40 48 56 649 9 18 27 36 45 54 63 72 81【程序】CLEARSET TALK OFF(5)A＝1DO WHILE A＜=9?? STR(A，4)A＝A+1ENDDOA= (6)DO WHILE A＜=9? STR(A，4)B＝1DO WHILE B＜＝AP= (7)?? STR(P，4)B=B+1ENDDOA= (8)ENDDOSET TALK ONRETURN(5)A．?“*”B．? SPACE(3) +“*”C．? SPACE (3)+*D．SPACE(3) +“*”
考题
三次动态地从右向左显示变量S内容的字幕程序:CLEARS-SPACE(80)+“热烈庆祝北京审半2008年奥运会成功!热烈呼唤!!”+SPACE(60)N-O【 】I=1DO WHILE 1160@20,0 SAY SUBSTR(S,I,80)H=INKEY(0,1，”H”)I=1+2【 】【 】ENDDO
考题
When monitoring a system using /usr/bin/vmstat with an interval， the metrics under page pi and page po represent which of the following phrases？（）A、 The pages to and from paging space per secondB、 The page intervals and page operations per secondC、 The page interrupts and page operations per secondD、 The page segments transferred between pi and po devices per second
考题
While setting up the threshold for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）A、 It would result in an error because the warning threshold cannot be more than the critical threshold.B、 The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.C、 The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.D、 Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.
考题
Network management saves time and money by automating which two tasks? （）A、Configuring changes to hardware and softwareB、Monitoring online purchasingC、Monitoring user access to storage filesD、Monitoring and troubleshooting network devices
考题
A user is reporting that access to a file server is much slower than it has been. The system administrator completes a test of the server using a system monitoring tool and compares it to the previously taken baseline. The comparison shows that there are no significant changes in the use ofsystem resources. Which of the following actions should be taken to resolve this users problem？（）A、 Add additional RAM to the users PCB、 Troubleshoot the users PCC、 Add additional RAM to the serverD、 Add additional hard drive space to the server
考题
An administrator is getting reports that a file server is responding slowly. Which of the following steps should the administrator take FIRST？（）A、Remove unnecessary files on the server to free up hard disk space.B、Defragment the server’s hard disks.C、Compare monitoring results with the server baseline.D、Add additional memory to reduce paging.
考题
When monitoring a system using vmstat with an interval， the metrics under page po represent which of the following phrases？（） A、 The number pages over the limitB、 The pages to paging space per secondC、 The number of page operations per secondD、 The number of processes waiting for page out
考题
While monitoring a system using vmstat， which of the following options most likely indicates that the system is CPU bound？（）A、 r is greater than 40B、 id is greater than 50C、 sum of id and wa equals 50D、 sum of us and sy equals 100
考题
You are creating a locally managed tablespace to meet the following requirements： All the extents should be of the same size. The data should be spread across two data files. A bitmap should be used to record the free space within the allocated extents. Which three options would you choose？（）A、set PCTFREE and PCTUSED to 50B、specify extent allocation as UniformC、specify extent allocation as AutomaticD、create the tablespace as bigfile tablespaceE、create the tablespace as smallfile tablespaceF、set segment space management to AutomaticG、use the RESIZE clause while creating the tablespace
考题
单选题While monitoring a system that is CPU bound， which of the following output is most likely to occur？（）A
AB
BC
CD
D
考题
单选题What’s the _____ of having a public open space where you can’t eat, drink or even simply hang out for a while?A
senseB
matterC
caseD
opinion
考题
单选题While performing monitoring and tuning the database， you want to view the summarized information about the warning level alerts and critical level alerts. Which section of the Oracle Enterprise manager displays the summarized information about the warning and critical level alerts？（）A
GeneralB
High AvailabilityC
Space UsageD
Diagnostic Summary
考题
单选题When monitoring a system using /usr/bin/vmstat with an interval， the metrics under page pi and page po represent which of the following phrases？（）A
The pages to and from paging space per secondB
The page intervals and page operations per secondC
The page interrupts and page operations per secondD
The page segments transferred between pi and po devices per second
考题
单选题While monitoring a system using vmstat， which of the following options most likely indicates that the system is CPU bound？（）A
r is greater than 40B
id is greater than 50C
sum of id and wa equals 50D
sum of us and sy equals 100
考题
多选题Evaluate the following command and its output: Which two statements correctly interpret the output?（）AFREE_SPACE indicates only the space that is currently unallocated.BALLOCATED_SPACE indicates only the space currently allocated and in use.CFREE_SPACE indicates only the space that is currently allocated and available for reuse.DALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.EFREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.
考题
多选题While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch？（）AAn entry is created in the alert log file and the database instance continues to function normallyBThe log switch hangs occur for transactions until free space is available in the flash recovery areaCThe Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery areaDThe database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented
考题
多选题Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1： ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）ADrop and re-create the inbox.BCoalesce the ORDERS_IND index.CCoalesce the INDEXES tablespace.DDrop and re-create the ORDERS table.ERebuild the index online and move it to another tablespace.
考题
单选题While setting up the thresholds for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）A
It would result in an error because the warning threshold cannot be more than the critical threshold.B
The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.C
The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.D
Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.
考题
单选题You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?（）A
DBMS_STATS B
DBMS_ALERT C
DBMS_SPACE D
DBMS_MONITOR E
DBMS_SERVER_ALERTF
DBMS_SPACE_ADMIN
考题
单选题When monitoring a system using vmstat with an interval， the metrics under page po represent which of the following phrases？（）A
The number pages over the limitB
The pages to paging space per secondC
The number of page operations per secondD
The number of processes waiting for page out
考题
单选题You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this？（）A
enable index monitoring and query the DBA_OBJECTS viewB
enable index monitoring and query the DBA_INDEXES viewC
enable index monitoring and query the V$OBJECT_USAGE viewD
enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
考题
单选题How did the researchers do the experiment?A
By inviting the volunteers to have a long class.B
By asking the volunteers to pay attention to a clock.C
By monitoring brain activity while volunteers are watching a picture.
考题
多选题Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1： ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）Adrop and re-create the indexBcoalesce the ORDERS_IND indexCcoalesce the INDEXES tablespaceDdrop and re-create the ORDERS tableErebuild the index online and move it to another tablespace
考题
多选题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 space and you have no more room on disk. Proactively, which two options could you use to make more space available in the flash recovery？（）AChange the RMAN archived log deletion policyBUse the RMAN CROSSCHECK command to reclaim the archived log spaceCChange the RMAN retention policy to retain backups for a shorter period of timeDUse OS command to move files from the flash recovery area to some other location
热门标签
最新试卷