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 t

第1题：

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 thewall
• B、 Increase the size of sb_max
• C、 Increase the size of tcp_recvspace
• D、 Increase the size of tcp_sendspace

第2题：

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.

第3题：

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 Advisor
• B、 Segment Advisor
• C、 Undo Advisor
• D、 SQL Tuning Advisor

第4题：

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.

第5题：

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.

第6题：

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 group
• B、activate the Pending Area before creating the consumer group
• C、increase the size of the large pool to accommodate the Pending Area
• D、increase the size of the shared pool to accommodate the Pending Area
• E、increase the size of the database buffer cache to accommodate the Pending Area

第7题：

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

第8题：

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 file
• B、because of data from database buffer cache
• C、because of data from a temporary tablespace
• D、because of undo data from the undo tablespace

第9题：

第10题：

第11题：

第12题：

第13题：

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 retention
• B、add one more redo log group
• C、size the redo log files appropriately
• D、size the UNDO tablespace appropriately
• E、size the SYSTEM tablespace appropriately
• F、configure an appropriate undo retention interval
• G、change automatic undo management to manual

第14题：

Which of the following a true statements regarding the use of VLANs to segment anetwork? （）

• 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 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.

第15题：

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 files
• B、Increase the size of redo log buffer
• C、Increase the number of redo log files
• D、Place the redo log files on a separate disk
• E、Decrease the number of redo log groups to two
• F、Increate the number Log Writer （LGWR） process

第16题：

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 job
• B、Truncate the Certkiller STAFF table and run the job
• C、Delete all rows from the Certkiller STAFF table and run the job
• D、Increase the size of the USERStablespacethe and run the job
• E、Increase the size of the database default permanenttablespaceand run the job

第17题：

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 frequently
• B、increase the value of the UNDO_RETENTION initialization parameter
• C、change the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTO
• D、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 parameter
• F、increase the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter

第18题：

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 buffer
• B、increase the number of redo log groups
• C、increase the number of log writer processes
• D、increase the number of ARCn processes
• E、change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location

第19题：

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_RETENTION
• B、change the value of WORKAREA_SIZE_POLICY to AUTO
• C、increase the value of DB_RECOVERY_FILE_DEST_SIZE
• D、increase the value of CONTROL_FILE_RECORD_KEEP_TIME

第20题：

第21题：

第22题：

第23题：