多选题In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）Aaverage row sizeBlast analyzed dateCsize of table in bytesDsize of table in database blocksEnumber of free blocks in the free listFnumber of extents present in the table
多选题
In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）
A
average row size
B
last analyzed date
C
size of table in bytes
D
size of table in database blocks
E
number of free blocks in the free list
F
number of extents present in the table
参考解析
解析：
暂无解析
相关考题：
You have two databases， FINDB and PAYDB， on single operating system and using Optimal Flexible architecture （OFA）. FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the following error： ORA-01081： cannot start - already running ORACLE - shut it down first Which environmental variable would you set before starting up the PAYDB database to overcome this error？（）A、ORA_PATHB、ORACLE_SIDC、ORACLE_BASED、ORACLE_HOMEE、LD_LIBRARY_PATH
You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：RMAN REPORT NEED BACKUP days 3；What would be the output of this command？（）A、 a list of files that require a backup within three daysB、 a list of files that have not been backed up for three daysC、 a list of files that RMAN recommends be backed up only once in every three days， based on low volatilityD、 a list of files for which a backup has already been performed and may need a backup after three days
You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）A、Database ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent
In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5：00 p.m. CALC_STAT updates the optimizer statistics for the objects owned by the APPS schema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task. Which component of Oracle Scheduler must you define to achieve this？（）A、WindowB、ProgramC、Job classD、Window group
You work as a database administrator for Certkiller .com. You want to administer your database servers，which are running on different host machines，using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）A、Application Server ControlB、Oracle Management ServiceC、Oracle Enterprise Manager RepositoryD、Oracle Enterprise Manager Database Control
You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）A、Average row sizeB、Last analyzed dateC、Size of table in bytesD、Size of table in database blocksE、Number of free blocks in the free listF、Number of extents present in the table.
You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement： SQLALTER DATABASE OPEN RESETLOGS； Which of the following options is true about using the RESETLOGS option？（）A、 The log sequence is reset to 0.B、 All the online redo logs are deleted.C、 All the archived redo logs from a previous incarnation become useless.D、 The full database backup taken from a previous incarnation can be used in future.E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.
You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）A、The Oracle kernel will be placed in this location.B、The Oracle software will be placed in this location.C、The server parameter file （SPFILE） will be placed in this location.D、The database files will be placed in this location， if not specified explicitly.E、The location will be considered for the base of Oracle Managed Files （OMF）.F、The location will be considered for the base of Optimal Flexible Architecture （OFA）.
You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces？（）A、SQL*PlusB、iSQL*PlusC、Management ServerD、Management RepositoryE、Oracle Enterprise Manager 10g Database Control
If you create your database using Oracle Managed Files （OMF）， what is true？（）A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures. B、You must define directories for two online redo log groups and three copies of the control file. C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.
As soon as you discover that you have lost an online redo log， if the database is still functioning， what should be your first action？（） A、 Shut down the databaseB、 Clear the online redo logC、 Back up the databaseD、 Checkpoint the databaseE、 Call Oracle support
You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）A、 INSTANCE_TYPEB、 DB_UNIQUE_NAMEC、 ASM_DISKSTRINGD、 ASM_POWER_LIMIT
You work as a database administrator at Certkiller .com. In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task.Which component of Oracle Scheduler must you define to achieve this？（）A、 WindowB、 ProgramC、 Job classD、 Window group
Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）A、 V$DATABASEB、 V$UNDOSTATC、 V$FLASHBACK_DATABASE_LOGD、 V$FLASHBACK_DATABASE_STAT
You work as a database administrator for Supportcenter.cn. In your production database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task？（）A、You must have started the database instance in restricted mode.B、You must have started the database instance inNORMALmode.C、You must have started the database instance with server parameter file.D、You must have started the database instance but must not have mounted.E、You must have started the database instance but must not have opened.
多选题You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）AAverage row sizeBLast analyzed dateCSize of table in bytesDSize of table in database blocksENumber of free blocks in the free listFNumber of extents present in the table.
多选题In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）Aaverage row sizeBlast analyzed dateCsize of table in bytesDsize of table in database blocksEnumber of free blocks in the free listFnumber of extents present in the table
单选题You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）AThe Oracle kernel will be placed in this location.BThe Oracle software will be placed in this location.CThe server parameter file （SPFILE） will be placed in this location.DThe database files will be placed in this location， if not specified explicitly.EThe location will be considered for the base of Oracle Managed Files （OMF）.FThe location will be considered for the base of Optimal Flexible Architecture （OFA）.
单选题In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5：00 p.m. CALC_STAT updates the optimizer statistics for the objects owned by the APPS schema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task. Which component of Oracle Scheduler must you define to achieve this？（）AWindowBProgramCJob classDWindow group
多选题Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the database PROD. While setting up the connect string using Oracle Enterprise Manager 10g Database Control， which two options would you select to balance the connection load across all the listener processes？（）AUse only the first address.BTry one address，selected at random.CTry each address，in order，until one succeeds.DTry each address，randomly，until one succeeds.
单选题While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）Aconfigure the database to run in ARCHIVELOG modeBconfigure the Flash Recovery Area to enable automatic database backupCschedule the database backup using DBMS_JOB package after creating the databaseDschedule the database backup using Recovery Manager （RMAN）commands after creating the databaseEschedule the database backup using Database Configuration Assistant （DBCA）while creating the database
单选题You are maintaining your database in Oracle10g. You are required to view the list of files that have not been backed up for the last seven days. Which RMAN command will you use？（）A LIST commandB CROSSCHECK commandC REPORT commandD SHOW command
单选题You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）Ause the external table populationBuse the Oracle Data Pump export and import utilityCuse the conventional path data load of SQL*Loader utilityDuse the direct path data load of Oracle export and import utility
多选题You work as a database administrator for Supportcenter.cn. You want to administer your database servers， which are running on different host machines， using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）AApplication Server ControlBOracle Management ServiceCOracle Enterprise Manager RepositoryDOracle Enterprise Manager Database Control
单选题You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true？（）A You must have change tracking enabled in your databaseB Your database must be running in NOARCHIVELOG modeC To back up a tablespace，it must be in backup modeD To back up a tablespace，it must first be taken offline
单选题You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database： RMAN REPORT NEED BACKUP days 3; What would be the output of this command？（）Aa list of files that require a backup within three daysBa list of files that have not been backed up for three daysCa list of files that RMAN recommends be backed up only once in every three days， based on low volatilityDa list of files for which a backup has already been performed and may need a backup after three days
单选题You work as a database administrator at Certkiller .com. In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task.Which component of Oracle Scheduler must you define to achieve this？（）A WindowB ProgramC Job classD Window group
单选题As soon as you discover that you have lost an online redo log， if the database is still functioning， what should be your first action？（）A Shut down the databaseB Clear the online redo logC Back up the databaseD Checkpoint the databaseE Call Oracle support