网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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


参考答案

参考解析
解析: 暂无解析
更多 “单选题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” 相关考题
考题 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?()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

考题 单选题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

考题 单选题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

考题 多选题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()A 1B 2C 3D 4E 1,2,and 4F 1,2,3,and 4

考题 单选题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

考题 单选题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.