单选题Which are required initialization parameters in an Oracle Shared Server environment?()ADISPATCHERS and SHARED_SERVERSBDISPATCHERS and MAX_DISPATCHERSCMAX_DISPATCHERS and MAX_SHARED_SERVERSDSHARED_SERVER_SESSIONS and DISPATCHERS
单选题
Which are required initialization parameters in an Oracle Shared Server environment?()
A
DISPATCHERS and SHARED_SERVERS
B
DISPATCHERS and MAX_DISPATCHERS
C
MAX_DISPATCHERS and MAX_SHARED_SERVERS
D
SHARED_SERVER_SESSIONS and DISPATCHERS
参考解析
解析:
暂无解析
相关考题:
Which two statements are true regarding the starting of the database instance using the following command?()SQLSTARTUP UPGRADE A. It enables all system triggers.B. It allows only SYSDBA connections.C. It ensures that all job queues remain active during the upgrade process.D. It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.
Which statement is true regarding Dynamic Service Registration?()A、Dynamic service registration requires configuration in the listener .ora file.B、Dynamic service registration can be used only with an Oracle9/instance.C、Dynamic service registration cannot register a local listener that does not use TCP/IP or port 1521.D、The PMON background process automatically registers each database instance if the necessary parameters have been set in the database initialization parameter file.
Which are required initialization parameters in an Oracle Shared Server environment?()A、DISPATCHERS and SHARED_SERVERSB、DISPATCHERS and MAX_DISPATCHERSC、MAX_DISPATCHERS and MAX_SHARED_SERVERSD、SHARED_SERVER_SESSIONS and DISPATCHERS
You are configuring for Oracle Shared Server. Which service is required? ()A、Oracle Net ServiceB、Oracle HTTP ServiceC、Oracle Paging ServiceD、Internet Directory Service
Which two statements are true regarding the starting of the database instance using the following command?() SQLSTARTUP UPGRADEA、It enables all system triggers.B、It allows only SYSDBA connections.C、It ensures that all job queues remain active during the upgrade process.D、It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.
Which three are described in the standard web application deployment descriptor?() A、 session configurationB、 MIME type mappingsC、 context root for the applicationD、 servlet instance pool configurationE、 web container default port bindingsF、 ServletContext initialization parameters
You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter?()A、 0B、 1C、 NONED、 DEFAULT
The database is configured for automatic archive logging. Along with the other required parameters, this entry is in the initialization file:log_archive_dest2="SERVICE=standby_db1 MANDATORY REOPEN=600" From where does the database resolve standby_db1?()A、control fileB、tnsnames.oraC、data dictionaryD、initialization parameter file
Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository?() A、 BACKGROUND_DUMP_DESTB、 FOREGROUND_DUMP_DESTC、 CORE_DUMP_DESTD、 USER_DUMP_DESTE、 DIAGNOSTIC_DESTF、 All of the above
To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor, you can set values for which of the following initialization parameters?()A、 DB_CACHE_SIZEB、 SHARED_POOL_SIZEC、 LARGE_POOL_SIZED、 JAVA_POOL_SIZEE、 SGA_MAX_SIZEF、 SORT_AREA_SIZE
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
In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?()A、Password file B、Initialization file C、Datafile D、Control file E、Nothing - SYSDBA privileges are not required for these actions
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
The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL STARTUP; Which two activities are performed during a successful start up operation?()A、The databases configured to use the ASM instance are mountedB、The disk groups are mounted as per the ASM_DISKGROUPS initialization parameterC、ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedD、ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
多选题The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL STARTUP; Which two activities are performed during a successful start up operation?()AThe databases configured to use the ASM instance are mountedBThe disk groups are mounted as per the ASM_DISKGROUPS initialization parameterCASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedDASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
多选题Which three are described in the standard web application deployment descriptor?()Asession configurationBMIME type mappingsCcontext root for the applicationDservlet instance pool configurationEweb container default port bindingsFServletContext initialization parameters
多选题To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor, you can set values for which of the following initialization parameters?()ADB_CACHE_SIZEBSHARED_POOL_SIZECLARGE_POOL_SIZEDJAVA_POOL_SIZEESGA_MAX_SIZEFSORT_AREA_SIZE
多选题Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository?()ABACKGROUND_DUMP_DESTBFOREGROUND_DUMP_DESTCCORE_DUMP_DESTDUSER_DUMP_DESTEDIAGNOSTIC_DESTFAll of the above
多选题Which three are described in the standard web application deployment descriptor?()Asession configurationBMIME type mappingsCcontext root for the applicationDservlet instance pool configurationEweb container default port bindingsFServlet Context initialization parameters
多选题When setting up the Flashback Data Archive, which of these key parameters are required?()ATablespace nameBStorage quotaCRetentionDTable nameECreate a default archive
多选题Which two PL/SQL8 features are supported in Oracle Forms?()AmethodsBobject tablesCobject columnsDcollection typesEobject as stored procedure parameters
多选题Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters?()ASORT_AREA_SIZEBHASH_AREA_SIZECBITMAP_MERGE_AREA_SIZEDCREATE_BITMAP_AREA_SIZEEPGA_AGGREGATE_TARGET
多选题You set the value of the SGA_TARGET initialization parameter to 1G to enable Oracle to automatically resize most of the memory components according to the current workload in the database. You issue the following statement: SQL SELECT name, value, isdefault 2 FROM v$parameter 3 WHERE name LIKE ’%size%’; The output of this statement displays that the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters contain a zero value. What does this imply?()AThe SGA_TARGET initialization parameter cannot be set to a value less than 1GBThe SGA_TARGET initialization parameter cannot be set to a value greater than 1GCThe Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGADThe values of the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters cannot be set manually.ENo minimum limits are imposed on the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters.FThe Automatic Shared Memory Management feature cannot be disabled unless you specify values for the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters in the initialization parameter file.
单选题You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter?()A 0B 1C NONED DEFAULT
多选题The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL STARTUP; Which two activities are performed during a successful start up operation? ()(Choose two.)AThe databases configured to use the ASM instance are mountedBThe disk groups are mounted as per the ASM_DISKGROUPS initialization parameterCASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedDASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
多选题Which two statements are true regarding the starting of the database instance using the following command?() SQLSTARTUP UPGRADEAIt enables all system triggers.BIt allows only SYSDBA connections.CIt ensures that all job queues remain active during the upgrade process.DIt sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.
单选题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