Your database is5GB and contain satablenamed Sales History.Salesinformationisfrequentlyinsertedandupdated.Youdiscoverthatexcessivepagesplittingisoccurring.Youneed toreducetheoccurr enceofpagesplittinginthe Sales History table.Whichcodesegmentshouldyou use？（）

相似题目

• Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）

  A . only the control file, the current SPFILE, and data files B . only the current SPFILE and data files if autobackup is disabled C . only the data files and the archived redo logs D . the control file, current SPFILE file, data files, and archived redo log

  查看最佳答案

• Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command：  LSNRCTL> STOP  What happens to the sessions that are presently connected to the database instance（）

  A . The sessions are able to perform only queries. B . The sessions are not affected and continue to function normally. C . The sessions are terminated and the active transactions are rolled back. D . The sessions are not allowed to perform any operations till the listener is started.

  查看最佳答案

• You work as a database administrator for Certkiller .com. The UNDO_RETENTION parameter in your database is set to 1000 and undoretention is not guaranteed. Which statement regarding retention of undo data is correct？（）

  A . Undo data becomes obsolete after 1，000 seconds. B . Undo data gets refreshed after 1，000 seconds. C . Undo data will be stored permanently after 1，000 seconds. D . Committed undo data would be retained for 1，000 seconds if free undo space is available. E . Undo data will be retained in the UNDOtablespacefor 1，000 seconds， then it gets movedmovedto the TEMPORARYtablespaceto provide read consistency.

  查看最佳答案

• Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER byissuing the following command:lsnrctl > STOPWhat happens to the sessions that are presently connected to the database Instance?（）

  A . They are able to perform only queries. B . They are not affected and continue to function normally. C . They are terminated and the active transactions are rolled back. D . They are not allowed to perform any operations until the listener LISTENER is started

  查看最佳答案

• You want to create an RMAN recovery catalog in the RC01 database to help you manage the databases named DB01 and DB02. You need to create a recovery catalog owner in which of your databases？（）

  A . RCO1 only. B . DB01 only. C . DB02 only. D . DB01 and DB02 only. E . DB01，DB02，and RC01.

  查看最佳答案

• You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？ （）

  A . This operation resets the SCN for the database. B . This operation creates a new incarnation of the database. C . This operation moves all the redo log files to a different location. D . This operation deletes the old redo log files and creates new redo log files. E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

  查看最佳答案

• You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？ （）

  A .  This operation resets the SCN for the database. B .  This operation creates a new incarnation of the database. C .  This operation moves all the redo log files to a different location. D .  This operation deletes the old redo log files and creates new redo log files. E .  This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）

  A . All control files are opened B . All redo files are opened C . The password file is opened D . The parameter file is opened E . All online data files are opened

  查看最佳答案

• In your database， UNDO_RETENTION has been set to 600 sec and UNDO tablespace is configured for RETENTION GUARANTEE. Which statement regarding RETENTION GUARANTEE is true？ （）

  A . Undo data is retained until the next full database backup. B . No committed undo data will be overwritten for 10 minutes. C . Committed undo data will be kept forever if not overwritten within 600 seconds. D . Guarantees that requested undo information are available until the instance is shut down.

  查看最佳答案

• You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）

  A . SYSTEM  B . OUTLN  C . INTERNAL  D . SYS

  查看最佳答案

• You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files（）

  A . Archiving will be disabled because the destination for the redo log files is missing. B . The database instance will shut down and the error details will be logged in the alert log file. C . Archiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly. D . Archiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.

  查看最佳答案

• In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation. How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?（）

  A . It collects data from SGA and compares it with a preserved snapshot. B . It collects data from SGA, analyzes it, and provides a report. C . It collects data from SGA and compares it with the latest snapshot. D . It collects data from both SGA and PGA, analyzes it, and provides a report

  查看最佳答案

• You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）

  A . One tablespace has only one datafile B . Many tablespaces can share one datafile C . One tablespace can have many datafiles D . One datafile can contain many tablespace

  查看最佳答案

• Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.Which two RMAN commands may be; used to back up only the PDB1 pluggable database?（）

  A . BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container B . BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container C . BACKUP DATABASE while connected to the PDB1 container D . BACKUP DATABASE while connected to the boot container E . BACKUP PLUGGABLE database PDB1 while connected to PDB2

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？（）

  A . Hot backup B . Online backup C . consistent backup D . incremental backup E . inconsistent backu

  查看最佳答案

• The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）

  A . Undo data becomes obsolete after 1，000 seconds. B . Undo data gets refreshed after every 1，000 seconds. C . Undo data will be stored permanently after 1，000 seconds. D . Committed undo data would be retained for 1，000 seconds if free undo space is available. E . Undo data will be retained in the UNDO tablespace for 1，000 seconds，then it gets moved to the TEMPORARY tablespace to provide read consistency.

  查看最佳答案

• You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）

  A . Enable the flash recovery area and specify it as the archived redo log destination. B . Disable the flash recovery area and start the database instance in ARCHIVELOG mode. C . Enable the flash recovery area but do not specify it as the archived redo log destination. D . Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.

  查看最佳答案

• Your database is running in ARCHIVELOG mode， and the database is open. You execute an RMAN backup and specify the KEEP clause.  Which components are backed up when this option is specified？（）  

  A .  only the control file， the current SPFILE， and data files B .  only the current SPFILE and data files if autobackup is disabled C .  only the data files and the archived redo logs D .  the control file，current SPFILE file，data files，and archived redo log

  查看最佳答案

• You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）

  A . Hot backup B . Online backup C . consistent backup D . incremental backup E . inconsistent backu

  查看最佳答案

• Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command：   RESTORE CONTROLFILE FROM AUTOBACKUP；   Which of the following statements is true？（） 

  A .  The command restores only the missing control file. B .  The command restores all the control files. C .  The command fails because the database is running. D .  This is the correct way to address this problem. E .  This is not the correct way to address this problem.

  查看最佳答案

• You are using Oracle Database 10g. You performed an  incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？（）

  A . This operation resets the SCN for the database. B . This operation creates a new incarnation of the database. C . This operation moves all the redo log files to a different location. D . This operation deletes the old redo log files and creates new redo log files. E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

  查看最佳答案

• If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）  

  A .  Complete database recovery. B .  Incomplete database recovery. C .  Approximate database recovery. D .  Archived database recovery. E .  The database could not be recovered with RMAN.

  查看最佳答案

• Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）

  A . User process B . Server process C . System Monitor (SMON) D . Process Monitor (PMON) E . Checkpoint process (CKPT)

  查看最佳答案

• You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set？（）

  A .  Enable the flash recovery area and specify it as the archived redo log destination. B .  Disable the flash recovery area and start the database instance in ARCHIVELOG mode. C .  Enable the flash recovery area but do not specify it as the archived redo log destination.  D .  Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.

  查看最佳答案