单选题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?()AThe table is partitionedBThe table name is wrong.CIt is an index-Organized table (IOT)DThe table is stored in locally managedtablespace.EThe 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?()AModify the profile assigned to the user.BModify the roles assigned to the users.CModify the object privileges assigned to the user.DModify the system privileges assigned to the users.EModify 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?()Aincrease the value of UNDO_RETENTIONBchange the value of WORKAREA_SIZE_POLICY to AUTOCincrease the value of DB_RECOVERY_FILE_DEST_SIZEDincrease 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?()Amkps paging00 hdisk0Bchpv -v r hdisk2Cchps -a n paging00Dreducevg 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?()AFrom a Group Policy object (GPO), enable the Limit profile size setting.BEnable System Protection for Local Disk (C) and set the disk space usage.CEnable disk quota management on Computer1 and configure a default quota limit.DFrom 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.()AThe PGA_AGGREGATE_TARGET parameter is set to zero.BThe STATISTICS_LEVEL parameter is setto basic.CBoth the SGA_TARGETandMEMORY_TARGET paramete rsareset.DThe 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?()AThere is not enough available space on the boot partition.BThe disk performance counters are disabled.CThe Logical Disk Manager Administrative service is disabled.DThe 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?()AThe new IOS image is too large for the router flash memory.BThe TFTP server is unreachable from the router.CThe new IOS image is not correct for this router platform.DThe IOS image on the TFTP server is corrupt.EThere 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?()ARun fsck on all filesystems using loglv00BRun the logform command against loglv00CRecreate the filesystems and restore from a backupDCreate a new jfslog and change /etc/filesystems to point to this log