网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You receive the following error： ORA-19804： cannot reclaim nnnnn bytes disk space from mmmmm limit Identify the reason for receiving the above error message？（）
A
The sort area is very small.
B
There is no more space in the Undo tablespace.
C
The flash recovery area is full.
D
The online redo log file is full.
参考答案
参考解析
解析：
暂无解析
更多 “单选题You receive the following error： ORA-19804： cannot reclaim nnnnn bytes disk space from mmmmm limit Identify the reason for receiving the above error message？（）A The sort area is very small.B There is no more space in the Undo tablespace.C The flash recovery area is full.D The online redo log file is full.” 相关考题
考题
To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message:SQL startupORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.Identify the reason the instance failed to start.（）A.The PGA_AGGREGATE_TARGET parameter is set to zero.B.The STATISTICS_LEVEL parameter is setto basic.C.Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.D.The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.
考题
You have a computer that runs Windows Vista.You run ipconfig /release from the command prompt and receive the following error message: The requested operation requires elevation.”You need to release the IP address for the computer.What should you do?（）A.AB.BC.CD.D
考题
When upgrading the IOS image, the network administrator receives the exhibited error message. What could be the cause of this error?（）A、The new IOS image is too large for the router flash memory.B、The TFTP server is unreachable from the router.C、The new IOS image is not correct for this router platform.D、The IOS image on the TFTP server is corrupt.E、There is not enough disk space on the TFTP server for the IOS image.
考题
You have a computer that runs Windows 7. Multiple users share the computer. The computer is joined to adomain. You need to prevent the users from using more than 2 GB of disk space on drive C. What should you do?（）A、From a Group Policy object （GPO）， enable the Limit profile size setting.B、Enable System Protection for Local Disk （C） and set the disk space usage.C、Enable disk quota management on Computer1 and configure a default quota limit.D、From a Group Policy object （GPO）， enable the Limit the size of the entire roaming user profile cachesetting.
考题
During a system boot, an error message appears concerning a paging space, paging00. The paging space was located on hdisk2, but the disk was removed from the system without proper software procedures. Which of the following commands should be used as the first step in the process of recovery?（）A、mkps paging00 hdisk0B、chpv -v r hdisk2C、chps -a n paging00D、reducevg rootvg hdisk2
考题
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？（）A、Change the RMAN archived log deletion policyB、Use the RMAN CROSSCHECK command to reclaim the archived log spaceC、Change the RMAN retention policy to retain backups for a shorter period of timeD、Use OS command to move files from the flash recovery area to some other location
考题
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？（）A、 Drop and re-create the inbox.B、 Coalesce the ORDERS_IND index.C、 Coalesce the INDEXES tablespace.D、 Drop and re-create the ORDERS table.E、 Rebuild the index online and move it to another tablespace.
考题
You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）A、 multiplexed control filesB、 RMAN obsolete backupsC、 multiplexed online redo log filesD、 archived redo logs that have not been copied to tape
考题
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？（）A、drop and re-create the indexB、coalesce the ORDERS_IND indexC、coalesce the INDEXES tablespaceD、drop and re-create the ORDERS tableE、rebuild the index online and move it to another tablespace
考题
An RMAN backup job fails， displaying the following error message： ORA/x7f19809： limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. What would you do to resolve the error？（）A、increase the value of UNDO_RETENTIONB、change the value of WORKAREA_SIZE_POLICY to AUTOC、increase the value of DB_RECOVERY_FILE_DEST_SIZED、increase the value of CONTROL_FILE_RECORD_KEEP_TIME
考题
You work as a database administrator for Certkiller .com. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows： ERROR at Line 1： ORA-10635： Invalid segment ortablespacetype What could be the reason？（）A、The table is partitionedB、The table name is wrong.C、It is an index-Organized table （IOT）D、The table is stored in locally managedtablespace.E、The table is stored in atablespacewhere segment space is managed manually.
考题
You receive the following error： ORA-19804： cannot reclaim nnnnn bytes disk space from mmmmm limit Identify the reason for receiving the above error message？（）A、 The sort area is very small.B、 There is no more space in the Undo tablespace.C、 The flash recovery area is full.D、 The online redo log file is full.
考题
ou 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（）A、 Change the RMAN archived log deletion policy.B、 Use the RMAN CROSSCHECK command to reclaim the archived log space.C、 Change the RMAN retention policy to retain backups for a shorter period of time.D、 Use OS command to move files from the flash recovery area to some other location.
考题
You are the network administrator for . In particular you administer a Windows 2003 server named TestKing13. You need to use Disk Management to configure a partition on TestKing13. When you attempt to access Disk Management, you receive the following error message: "Unable to connect Logical Disk Manager service." You verify that the Logical Disk Manager service is started. What is the most likely cause of the problem?（）A、There is not enough available space on the boot partition.B、The disk performance counters are disabled.C、The Logical Disk Manager Administrative service is disabled.D、The Windows 2003 Administration Tools Pack is not installed
考题
You have a computer that runs Windows XP Professional. The computer has a limited amount of free disk space. You need to identify the amount of disk space that is used to store the following：Temporary Internet Files, Files in the Recycle Bin, Downloaded program files. What should you do?（）A、From the command prompt， run chkdsk.exe.B、From the System Tools menu， run Disk Cleanup.C、From Internet Explorer， view the Internet Options.D、From System Properties， view the User Profiles settings.
考题
Some users report they cannot receive messages from some external senders.You suspect that there is some anti-spam activity blocking those messages.You need to identify what is blocking the messages.You will activate and review the logs of one of the following：（）A、Protocol loggingB、Connectivity logsC、Message trackingD、Pipeline tracing
考题
单选题You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）A
multiplexed control filesB
RMAN obsolete backupsC
multiplexed online redo log filesD
archived redo logs that have not been copied to tape
考题
单选题You work as a database administrator for Certkiller .com. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows： ERROR at Line 1： ORA-10635： Invalid segment ortablespacetype What could be the reason？（）A
The table is partitionedB
The table name is wrong.C
It is an index-Organized table （IOT）D
The table is stored in locally managedtablespace.E
The table is stored in atablespacewhere segment space is managed manually.
考题
单选题A user complains that he gets the following error message repeatedly after executing some SQL statements. The error message forces the user to log off from and log on to the database to continue his work. ORA-02392： exceeded session limit on CPU usage， you are being logged off Which action would you take to increase the session limit on CPU usage？（）A
Modify the profile assigned to the user.B
Modify the roles assigned to the users.C
Modify the object privileges assigned to the user.D
Modify the system privileges assigned to the users.E
Modify the value for the RESOURCE_LIMIT parameter in the parameter file.
考题
单选题An RMAN backup job fails， displaying the following error message： ORA/x7f19809： limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. What would you do to resolve the error？（）A
increase the value of UNDO_RETENTIONB
change the value of WORKAREA_SIZE_POLICY to AUTOC
increase the value of DB_RECOVERY_FILE_DEST_SIZED
increase the value of CONTROL_FILE_RECORD_KEEP_TIME
考题
单选题During a system boot, an error message appears concerning a paging space, paging00. The paging space was located on hdisk2, but the disk was removed from the system without proper software procedures. Which of the following commands should be used as the first step in the process of recovery?（）A
mkps paging00 hdisk0B
chpv -v r hdisk2C
chps -a n paging00D
reducevg rootvg hdisk2
考题
多选题You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）Aguarantee undo retentionBadd one more redo log groupCsize the redo log files appropriatelyDsize the UNDO tablespace appropriatelyEsize the SYSTEM tablespace appropriatelyFconfigure an appropriate undo retention intervalGchange automatic undo management to manual
考题
单选题You have a computer that runs Windows 7. Multiple users share the computer. The computer is joined to adomain. You need to prevent the users from using more than 2 GB of disk space on drive C. What should you do?（）A
From a Group Policy object （GPO）， enable the Limit profile size setting.B
Enable System Protection for Local Disk （C） and set the disk space usage.C
Enable disk quota management on Computer1 and configure a default quota limit.D
From a Group Policy object （GPO）， enable the Limit the size of the entire roaming user profile cachesetting.
考题
单选题To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. Identify the reason the instance failed to start.（）A
The PGA_AGGREGATE_TARGET parameter is set to zero.B
The STATISTICS_LEVEL parameter is setto basic.C
Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.D
The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.
考题
单选题You are the network administrator for . In particular you administer a Windows 2003 server named TestKing13. You need to use Disk Management to configure a partition on TestKing13. When you attempt to access Disk Management, you receive the following error message: "Unable to connect Logical Disk Manager service." You verify that the Logical Disk Manager service is started. What is the most likely cause of the problem?（）A
There is not enough available space on the boot partition.B
The disk performance counters are disabled.C
The Logical Disk Manager Administrative service is disabled.D
The Windows 2003 Administration Tools Pack is not installed
考题
单选题When upgrading the IOS image, the network administrator receives the exhibited error message. What could be the cause of this error?（）A
The new IOS image is too large for the router flash memory.B
The TFTP server is unreachable from the router.C
The new IOS image is not correct for this router platform.D
The IOS image on the TFTP server is corrupt.E
There is not enough disk space on the TFTP server for the IOS image.
考题
单选题During an attempt to mount filesystems on the datavg volume grou, the following error message occurs: "0506-323 Cannot get information about log device loglv00." The error is due to the fjslog used by these filesystems is located on a bad disk.Which of the following procedures should be performed to fix the error?（）A
Run fsck on all filesystems using loglv00B
Run the logform command against loglv00C
Recreate the filesystems and restore from a backupD
Create a new jfslog and change /etc/filesystems to point to this log
热门标签
最新试卷