网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（）
A
recovery catalog
B
Oracle Enterprise Manager Repository
C
Automatic Workload Repository （AWR）
D
Oracle 10g Enterprise Manager Grid Control
E
Automatic Database Diagnostic Monitor （ADDM）
参考答案
参考解析
解析：
暂无解析
更多 “单选题In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（）A recovery catalogB Oracle Enterprise Manager RepositoryC Automatic Workload Repository （AWR）D Oracle 10g Enterprise Manager Grid ControlE Automatic Database Diagnostic Monitor （ADDM）” 相关考题
考题
As shown in the diagram, in－memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?()
A. CKPTB. SMONC. MMOND. DBWR
考题
Which setting enables the baselines by default in Oracle Database 11g?()
A. setting the STATISTICS_LEVEL parameter to TYPICALB. adding filters to the Automatic Database Diagnostic Monitor (ADDM)C. enabling Automated Maintenance Task using Oracle Enterprise ManagerD. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
考题
Which Oracle Database component is audited by default if the unified Auditing option is enabled?()
A. Oracle Data PumpB. Oracle Recovery Manager (RMAN)C. Oracle Label SecurityD. Oracle Database VaultE. Oracle Real Application Security
考题
Which Oracle Database component is audited by default if the unified Auditing option is enabled?（）A、Oracle Data PumpB、Oracle Recovery Manager (RMAN)C、Oracle Label SecurityD、Oracle Database VaultE、Oracle Real Application Security
考题
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）A、 Flashback logs are not archived.B、 Flashback logs are maintained in redo log files.C、 Flashback logs are maintained in the Flash Recovery Area.D、 Flashback logs are used to maintain Flashback Database related errors.E、 Flashback logs need to be cleared manually after you disable Flashback Database.
考题
You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that coordinates the sizing of the memory components？（） A、 MMANB、 PMONC、 MMOND、 MMNL
考题
SQ L*Loader is a utility that can perform which two tasks？（）A、Load data from a disk， tape， or named pipes.B、Load data into an Oracle database using DML statements.C、Extract， reorganize， and insert data within an Oracle database.D、Load data from external files into tables in an Oracle database.E、Load data into an Oracle database using operating system commands.F、Load data directly from a non-Oracle database to an Oracle database.
考题
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？（）A、Application Server ControlB、Oracle Management ServiceC、Oracle Enterprise Manager RepositoryD、Oracle Enterprise Manager Database Control
考题
In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（）A、 Recovery catalogB、 Oracle Enterprise Manager RepositoryC、 Automatic Workload Repository （AWR）D、 Oracle 10g Enterprise Manager Grid ControlE、 Automatic Database Diagnostic Monitor （ADDM）
考题
While planning to manage more than one database in your system， you perform the following activities： 1. Organize different categories of files into independent subdirectories. 2. Use consistent naming convention for database files. 3. Separate administrative information pertaining to each database. Which option corresponds to the type of activities performed by you？（）A、Oracle Managed FilesB、Oracle Grid ArchitectureC、Optimal Flexible ArchitectureD、Oracle database architecture
考题
Which setting enables the baselines by default in Oracle Database 11g？（） A、 setting the STATISTICS_LEVEL parameter to TYPICALB、 adding filters to the Automatic Database Diagnostic Monitor （ADDM）C、 enabling Automated Maintenance Task using Oracle Enterprise ManagerD、 setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
考题
You have three databases， FINDB， PAYDB and ADMINDB， located in Sydney， Tokyo and Singapore respectively. You want to perform administrative tasks which include starting up and shutting down the databases， creating and managing tablespaces and database users， and taking regular backups， for all of the three databases from London. Which component must be enabled and running on each host machine to achieve your objective？（）A、Oracle Management AgentB、Enterprise Manager with Grid ControlC、Enterprise Manager with Database ControlD、Operating System Socket for incoming requestsE、Real Application Cluster （RAC） with three instancesF、Enterprise Manager with Generic Database Management
考题
In an Oracle 10g database， the in/x7fmemory statistics are gathered at regular intervals and used to perform growth/x7ftrend analysis and capacity planning of the database. Which component stores these statistics？（）A、recovery catalogB、Oracle Enterprise Manager RepositoryC、Automatic Workload Repository （AWR）D、Oracle 10g Enterprise Manager Grid ControlE、Automatic Database Diagnostic Monitor （ADDM）
考题
Examine this command: SQL exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?（）A、Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.B、Statistics collection is not done for the CUSTOMERS table when database stats are gathered.C、Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.D、Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.E、Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
考题
As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?（）A、CKPTB、SMONC、MMOND、DBWR
考题
You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）A、 target databaseB、 auxiliary databaseC、 third-party databaseD、 recovery catalog database
考题
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 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 want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）A、control fileB、password fileC、listener controller fileD、control file and password file
考题
单选题Which setting enables the baselines by default in Oracle Database 11g？（）A
setting the STATISTICS_LEVEL parameter to TYPICALB
adding filters to the Automatic Database Diagnostic Monitor （ADDM）C
enabling Automated Maintenance Task using Oracle Enterprise ManagerD
setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
考题
单选题Which setting enables the baselines by default in Oracle Database 11g?（）A
setting the STATISTICS_LEVEL parameter to TYPICALB
adding filters to the Automatic Database Diagnostic Monitor (ADDM)C
enabling Automated Maintenance Task using Oracle Enterprise ManagerD
setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
考题
单选题You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that coordinates the sizing of the memory components？（）A
MMANB
PMONC
MMOND
MMNL
考题
单选题In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（）A
Recovery catalogB
Oracle Enterprise Manager RepositoryC
Automatic Workload Repository （AWR）D
Oracle 10g Enterprise Manager Grid ControlE
Automatic Database Diagnostic Monitor （ADDM）
考题
单选题In an Oracle 10g database， the in/x7fmemory statistics are gathered at regular intervals and used to perform growth/x7ftrend analysis and capacity planning of the database. Which component stores these statistics？（）A
recovery catalogB
Oracle Enterprise Manager RepositoryC
Automatic Workload Repository （AWR）D
Oracle 10g Enterprise Manager Grid ControlE
Automatic Database Diagnostic Monitor （ADDM）
考题
单选题As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?（）A
CKPTB
SMONC
MMOND
DBWR
考题
单选题You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）A
control fileB
password fileC
listener controller fileD
control file and password file
考题
单选题You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）A
target databaseB
auxiliary databaseC
third-party databaseD
recovery catalog database
考题
多选题You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）AFlashback logs are not archived.BFlashback logs are maintained in redo log files.CFlashback logs are maintained in the Flash Recovery Area.DFlashback logs are used to maintain Flashback Database related errors.EFlashback logs need to be cleared manually after you disable Flashback Database.
热门标签
最新试卷