Which of the following Oracle features utilize the undo tablespace？（） 

相似题目

• A user receives the following error while executing a query： ORA­01555：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

  查看最佳答案

• You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）

  A . When the instance is started  B . When the database is mounted  C . When the database is opened  D . When the database is closed

  查看最佳答案

• You issued the following command at the UNIX environment：   % setenv ORA_SDTZ ’OZ_TZ’   What will be the impact of issuing the above command？（）  

  A .  The operating system local time zone will be set for a user session using the operating system environment variable. B .  The database local time zone will be set for a user session using the operating system environment variable. C .  The operating system local time zone will be set for the database using the operating system environment D .  The database local time zone will be set for the database using the operating system environment variable.

  查看最佳答案

• Which is the packaging strategy of iDataPlex of the following？（）

  A . Fourteen servers per rack likeBladeCenter B . Two servers per rack for optimal cooling cost C . One server per rack for optimal cooling and energy efficiency D . Four servers per rack （twoexach half high） for optimal cooling

  查看最佳答案

• An RMAN backup job fails， displaying the following error：  ORA­19809： 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

  查看最佳答案

• 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

  查看最佳答案

• 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

  查看最佳答案

• You received the following error：   ORA-01578： ORACLE data block corrupted   （file # %s， block # %s）   Which file will you check to view additional information regarding the cause of this error？（）

  A . the alert log file and the trace files B .  the redo log files C .  the control file D .  the change tracking file

  查看最佳答案

• 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？（）

  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.

  查看最佳答案

• You have created a password file using the following command：   ORAPWD file=d：\oracle\ora9i\orapwU01 password=change_on_install entries=3   Which of the following is true about this password file？（）

  A .  If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges. B .  If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges. C .  If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then the SYSDBA and SYSOPER privileges can be granted to other users as long as space in the password file is D .  If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then the SYSDBAand SYSOPER privileges can be granted to other users as long as space in the password file is available.

  查看最佳答案

• The enableModifiedFlag enables which of the following？（）

  A . User initiated edit document command B . Silent navigation from an edited page C . User initiated save command D . Removal of a locked for editing statu

  查看最佳答案

• 1.Which of the following is the symptom of decidophobia?

  查看最佳答案

• 2.Which of the following is the finding of the psychologists

  查看最佳答案

• Which of the following has the meaning of the joint?

  查看最佳答案

• Which of the following is the way of expressing purpose?

  查看最佳答案

• Which of the following has the meaning of the joint?

  查看最佳答案

• Which of the following people were members of the Beatles?

  查看最佳答案

• Which of the following adopts the figure of speech － pun?

  查看最佳答案

• Which of the following best describes the organization of the passage?

  查看最佳答案

• Which of the following is NOT the symbol of America?

  查看最佳答案

• Which of the following are the purposes of punishment?

  查看最佳答案

• Which of the following are the tourist attractions of Nepal?

  查看最佳答案

• 3.Which of the following is the cause of decidophobia?

  查看最佳答案

• Which of the following is the best title of the passage？

  A．Fingerprints and Their Use B．Policemen and Fingerprints C．Fingerprints Are Useful Evidence D．Fingerprints Identify Criminals without Mistake

  查看最佳答案

• Which of the following is the proper title of the passage（）

  A．Heart Disease B．Depression and Fatality Rate C．Depression D．Depression Hurts the Heart

  查看最佳答案