A user receives the following error while executing a query： ORA/x7f01555：snapshot too old Which two options can be the solutions to avoid such errors in future？（）A、increase the size of redo log filesB、increase the size of the undo tablespaceC、increase the size of the Database Buffer CacheD、increase the size of the default temporary tablespaceE、enable the retention guarantee for the undo tablespace
A user receives the following error while executing a query： ORA/x7f01555：snapshot too old Which two options can be the solutions to avoid such errors in future？（）
- A、increase the size of redo log files
- B、increase the size of the undo tablespace
- C、increase the size of the Database Buffer Cache
- D、increase the size of the default temporary tablespace
- E、enable the retention guarantee for the undo tablespace
相关考题：
Ezonexam has implemented the use of VLANs in their network. Which of the following are considered to be a benefit of VLANs? (Choose three)A. They increase the size of collision domains.B. They allow logical grouping of users by function.C. They can enhance network security,D. The increase the size of broadcast domains while decreasing the number of the broadcast domains.E. The increase the number of broadcast domains while decreasing the size of the broadcast domains.F. They simplify switch administration.
Which of the following a true statements regarding the use of VLANs to segment a network? (Select three)A. They increase the size of collision domainsB. They allow logical grouping of users by function.C. They can enhance network security.D. They increase the size of the broadcast domain while decreasing the number of collision domains.E. They increase the number of broadcast domains while decreasing the size of the broadcast domains.F. They simplify switch administration.
Which of the following are benefits of VLANs?() A. They increase the size of collision domains.B. They allow logical grouping of users by function.C. They can enhance network security.D. They increase the size of broadcast domains while decreasing the number of collision domains.E. They increase the number of broadcast domains while decreasing the size of the broadcast domains.F. They simplify switch administration.
A TCP/IP application receives files from a remote machine. The application reads 32 kilobytes of data at a time to the socket， but has not issued a system call to set the window size. Which of the following procedures should be performed on the personal machine to increase the throughput of the application？（）A、 Increase the size of thewallB、 Increase the size of sb_maxC、 Increase the size of tcp_recvspaceD、 Increase the size of tcp_sendspace
A TCP/IP application is transferring files from a personal machine to a remote machine. The application writes 32 kilobytes of data at a time to the socket， but has not issued a system call to set the window size. Which of the following procedures should be performed on the personal machine to increase the throughput of the application？（）A、 Increase the size of thewallB、 Increase the size of sb_maxC、 Increase the size of tcp_recvspaceD、 Increase the size of tcp_sendspace
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？（）A、guarantee undo retentionB、add one more redo log groupC、size the redo log files appropriatelyD、size the UNDO tablespace appropriatelyE、size the SYSTEM tablespace appropriatelyF、configure an appropriate undo retention intervalG、change automatic undo management to manual
Which of the following are benefits of VLANs?（）A、They increase the size of collision domains.B、They allow logical grouping of users by function.C、They can enhance network security,D、The increase the size of broadcast domains while decreasing the number of the broadcast domains.E、The increase the number of broadcast domains while decreasing the size of the broadcast domains.F、They simplify switch administration.
Which of the following a true statements regarding the use of VLANs to segment anetwork? （）A、They increase the size of collision domainsB、They allow logical grouping of users by function.C、They can enhance network security.D、They increase the size of the broadcast domain while decreasing the number of collision domains.E、They increase the number of broadcast domains while decreasing the size of the broadcast domains.F、They simplify switch administration.
While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）A、 Memory AdvisorB、 Segment AdvisorC、 Undo AdvisorD、 SQL Tuning Advisor
You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation. Which two actions would you take to gain performance？（）A、Increase the size of redo log filesB、Increase the size of redo log bufferC、Increase the number of redo log filesD、Place the redo log files on a separate diskE、Decrease the number of redo log groups to twoF、Increate the number Log Writer （LGWR） process
You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue（）A、Disable automatic checkpoint tuning.B、Check the size of the redo log file size and increase the size if it is small.C、Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor. D、Decrease the number of redo log members if there are more than one redo log members available in each redo log group.
You work as a database administrator for Certkiller .com. While loading data into the Certkiller STAFF table using Oracle Enterprise Manager 10g Database Control， you find the status of the job as failed. On further investigation， you find the following error message in the output log： ORA-01653 unable to extend table HR. Certkiller STAFF by 8 intablespaceUSERS Which task would you perform to load the data successfully without affecting the users who are accessing the table？（）A、Restart the database instance and run the jobB、Truncate the Certkiller STAFF table and run the jobC、Delete all rows from the Certkiller STAFF table and run the jobD、Increase the size of the USERStablespacethe and run the jobE、Increase the size of the database default permanenttablespaceand run the job
You work as a database administrator for Supportcenter.cn. You received the following error while working on your database： ORA-01555： snapshot too old ，In which situation would you receive such an error？（）A、You performed rollback after commit.B、If a log switch occurs in your database.C、Thearchiverfails to generate an archived log file.D、Instance recovery fails to find one of the redo log files.E、A long-running query is unable to get read-consistent image.F、If you perform manual undo management operations in auto mode.
An RMAN backup job fails， displaying the following error： ORA/x7f19809： limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in future？（）A、take the backup of the flash recovery area less frequentlyB、increase the value of the UNDO_RETENTION initialization parameterC、change the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTOD、change the backup retention policy to retain the backups for a smaller period of time E、increase the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameterF、increase the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter
You want to create a consumer group， GROUP1， and you execute the following command in the command/x7fline interface： SQL EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =’group1’， COMMENT = ’New Group’）; This command errors out displaying the following message： ERROR at line 1： ORA/x7f29371： pending area is not active ORA/x7f06512： at "SYS.DBMS_RMIN"， line 115 ORA/x7f06512： at "SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA/x7f06512： at line 1 What action would you take to overcome this error？（）A、create the Pending Area before creating the consumer groupB、activate the Pending Area before creating the consumer groupC、increase the size of the large pool to accommodate the Pending AreaD、increase the size of the shared pool to accommodate the Pending AreaE、increase the size of the database buffer cache to accommodate the Pending Area
In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members. Which two actions would you take to improve the performance of the database server？ （）A、increase the size of the redo log bufferB、increase the number of redo log groupsC、increase the number of log writer processesD、increase the number of ARCn processesE、change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location
You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one. Which is it?（）A、Size of redo logs B、Number of datafiles C、LOG_CHECKPOINT_INTERVAL D、LOG_CHECKPOINT_TIMEOUT
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
The user SCOTT executes the following command successfully to increase the salary values in one of his sessions： SQL UPDATE emp SET sal=sal*1.15 WHERE deptno=20； Before SCOTT ends the transaction， user HR who has the privileges on EMP table executes a query to fetch the salary details but finds the old salary values instead of the increased values. Why does HR still see the old data？（）A、because of redo data from redo log fileB、because of data from database buffer cacheC、because of data from a temporary tablespaceD、because of undo data from the undo tablespace
单选题While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）A Memory AdvisorB Segment AdvisorC Undo AdvisorD SQL Tuning Advisor
单选题You work as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old In which situation would you receive such an error？（）AYou performed rollback after commit.BIf a log switch occurs in your database.CThearchiverfails to generate an archived log file.DInstance recovery fails to find one of the redo log files.EA long-running query is unable to get read-consistent image.FIf you perform manual undo management operations in auto mode.
单选题You want to create a consumer group， GROUP1， and you execute the following command in the command-line interface： SQL EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =’group1’， COMMENT = ’New Group’）； This command errors out displaying the following message： ERROR at line 1： ORA-29371： pending area is not active ORA-06512： at "SYS.DBMS_RMIN"， line 115 ORA-06512： at "SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA-06512： at line 1 What action would you take to overcome this error？（）A activate the Pending Area before creating the consumer groupB create the Pending Area before creating the consumer groupC increase the size of the database buffer cache to accommodate the Pending AreaD increase the size of the shared pool to accommodate the Pending AreaE increase the size of the large pool to accommodate the Pending Area
多选题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
单选题A TCP/IP application is transferring files from a personal machine to a remote machine. The application writes 32 kilobytes of data at a time to the socket， but has not issued a system call to set the window size. Which of the following procedures should be performed on the personal machine to increase the throughput of the application？（）A Increase the size of thewallB Increase the size of sb_maxC Increase the size of tcp_recvspaceD Increase the size of tcp_sendspace
多选题Which three pieces of information are considered while deciding the size of the undo tablespace in your database？（）Athe size of an undo blockBthe size of the redo log filesCundo blocks generated per secondDthe size of the database buffer cacheEthe value of the UNDO_RETENTION parameter
多选题A user receives the following error while executing a query： ORA/x7f01555：snapshot too old Which two options can be the solutions to avoid such errors in future？（）Aincrease the size of redo log filesBincrease the size of the undo tablespaceCincrease the size of the Database Buffer CacheDincrease the size of the default temporary tablespaceEenable the retention guarantee for the undo tablespace
单选题A TCP/IP application receives files from a remote machine. The application reads 32 kilobytes of data at a time to the socket， but has not issued a system call to set the window size. Which of the following procedures should be performed on the personal machine to increase the throughput of the application？（）A Increase the size of thewallB Increase the size of sb_maxC Increase the size of tcp_recvspaceD Increase the size of tcp_sendspace