单选题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 TYPICAL
B
adding filters to the Automatic Database Diagnostic Monitor （ADDM）
C
enabling Automated Maintenance Task using Oracle Enterprise Manager
D
setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
参考解析
解析：
暂无解析
相关考题：
During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?（）A. The installation terminates with an error.B. The installation proceeds with the default value without warnings and errors.C. The installation proceeds with the default value but it would not be an OFA-compliant database.D. The installation proceeds with the default value but a message would be generated in the alert log 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 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 statement correctly describes network security settings in Cisco Network Assistant for the Catalyst Express 500 Switch？（）A、The LOW setting enables broadcast storm control， but has no effect on the number of devices that can connect to a switch portB、The LOW setting enables broadcast storm control and limits the number of devices that can connect to a switch port.C、The LOW setting disables broadcast storm control but limits the number of devices that can connect to a switch portD、The default network setting is "HIGH"
On switch R1 you issue the "udld enable" global command. What does this command accomplish？ （）A、 Enables all fiber-optic LAN ports for Unidirectional LINK Detection （UDLD）B、 Enables all copper media LAN ports Unidirectional Link Detection （UDLD）C、 Overrides the default UDLS setting for all portsD、 Globally enables all ports on the device for Unidirectional Link Detection （UDLS）E、 None of the other alternatives apply
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 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 three are the valid statements in relation to SQL plan baselines?（）A、The plans can be manually loaded to the SQL plan baseline.B、The plans in the SQL plan baseline are verified and accepted plans.C、The plans generated for every SQL statement are stored in the SQL plan baseline by default.D、The plan baselines are stored temporarily in the memory as long as the database instance is running.E、 For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.
An administrator is testing setting the IP address on a Linux server from command line. Which of the following commands is used to set the default gateway for the server？（）A、routeB、tracerouteC、ipconfigD、nmap
On a newly installed AIX V4 machine, which of the following default values applies to the ipforwarding network option?（）A、 The ipforwarding is off by default. B、 The ipforwarding is set on by default. C、 The value is dynamically determined at boot time by DHCP. D、 The value is equal to the setting of the directed_broadcast runtime attribute.
Which of the following options enables a user to get authenticated though a single password instead of using multiple passwords？（）A、Wallet ManagerB、RadiusC、Oracle Internet DirectoryD、None of the above
Identify four uses of the Oracle Scheduler.（）A、 enables Oracle database to schedule which processes execute on which processors in a multiple CPU environmentB、 enables Oracle database to do patches according to a DBA-defined scheduleC、 enables you to schedule the execution of jobs based on timeD、 enables you to execute jobs in a clustered environmentE、 enables you to periodically execute operating systemscript files located on the same server as the databaseF、 enables you to create a job that makes use of saved programs and schedulesG、 enables you to automate the management of the jobs that are created using the DBMS_JOB package
A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）A、The value for MINEXTENTS setting B、The value for PCTINCREASE setting C、The value for MAXEXTENTS setting D、By default, Oracle allocates six extents to all database objects
In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（） A、 Setting a nonzero value for SGA_TARGETB、 Configuring Automatic Shared Memory ManagementC、 Configuring Automatic Memory ManagementD、 Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGETE、 None of the above
When setting up the Flashback Data Archive， which of these key parameters are required？（）A、 Tablespace nameB、 Storage quotaC、 RetentionD、 Table nameE、 Create a default archive
You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）A、DB_CREATE_FILE_DEST B、DB_CREATE_ONLINE_LOG_1 C、DB_CREATE_ONLINE_LOG_2D、The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed
单选题On switch R1 you issue the "udld enable" global command. What does this command accomplish？ （）A Enables all fiber-optic LAN ports for Unidirectional LINK Detection （UDLD）B Enables all copper media LAN ports Unidirectional Link Detection （UDLD）C Overrides the default UDLS setting for all portsD Globally enables all ports on the device for Unidirectional Link Detection （UDLS）E None of the other alternatives apply
单选题In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（）A Setting a nonzero value for SGA_TARGETB Configuring Automatic Shared Memory ManagementC Configuring Automatic Memory ManagementD Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGETE None of the above
单选题You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）ADB_CREATE_FILE_DEST BDB_CREATE_ONLINE_LOG_1 CDB_CREATE_ONLINE_LOG_2DThe directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed
单选题Which setting enables the baselines by default in Oracle Database 11g?（）Asetting the STATISTICS_LEVEL parameter to TYPICALBadding filters to the Automatic Database Diagnostic Monitor (ADDM)Cenabling Automated Maintenance Task using Oracle Enterprise ManagerDsetting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
单选题A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）AThe value for MINEXTENTS setting BThe value for PCTINCREASE setting CThe value for MAXEXTENTS setting DBy default, Oracle allocates six extents to all database objects
多选题When setting up the Flashback Data Archive， which of these key parameters are required？（）ATablespace nameBStorage quotaCRetentionDTable nameECreate a default archive
单选题Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST？（） The default value is the value of the environment variable $ORACLE_HOME； if $ORACLE_HOME isn’t setA then the default is set to $ORACLE_BASE The default value is the value of the environment variable $ORACLE_BASE； if $ORACLE_BASE isn’t set，B then it is set to $ORACLE_HOMEC DIAGNOSTIC_DEST is always equal to $ORACLE_HOMED DIAGNOSTIC_DEST is always equal to $ORACLE_BASE
单选题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
单选题Note the following points describing various utilities in Oracle Database 11g： 1：It enables the high-speed transfer of data from one database to another. 2：It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3：It enables the loading of data from an external file into an Oracle database. 4：It provides a tape backup management for the Oracle ecosystem. Which point describes Oracle Secure Backup（）A1B2C3D4E1，2，and 4F1，2，3，and 4
单选题Which statement correctly describes network security settings in Cisco Network Assistant for the Catalyst Express 500 Switch？（）AThe LOW setting enables broadcast storm control， but has no effect on the number of devices that can connect to a switch portBThe LOW setting enables broadcast storm control and limits the number of devices that can connect to a switch port.CThe LOW setting disables broadcast storm control but limits the number of devices that can connect to a switch portDThe default network setting is HIGH
单选题During the installation of Oracle Database 11g，you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation？（）A The installation terminates with an error.B The installation proceeds with the default value without warnings and errors.C The installation proceeds with the default value but it would not be an OFA-compliant database.D The installation proceeds with the default value but a message would be generated in the alert log file.
多选题Which three are the valid statements in relation to SQL plan baselines?（）AThe plans can be manually loaded to the SQL plan baseline.BThe plans in the SQL plan baseline are verified and accepted plans.CThe plans generated for every SQL statement are stored in the SQL plan baseline by default.DThe plan baselines are stored temporarily in the memory as long as the database instance is running.E For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.