Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback?（）A、The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.B、The optimizer can re optimize a query only once using cardinality feedback.C、The optimizer enables monitoring for cardinality feedback after the first execution of a query.D、The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.E、After the optimizer identifies a query as a re-optimization candidate, statistics collected by thecollectors are submitted to the optimizer.
Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback?（）
- A、The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
- B、The optimizer can re optimize a query only once using cardinality feedback.
- C、The optimizer enables monitoring for cardinality feedback after the first execution of a query.
- D、The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
- E、After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.
相关考题：
We will do our best to ( ) shipment to meet your requirements in time. A.expectB.expediteC.exerciseD.examine
View the Exhibit to examine the replay settings for replay parameters.What is the implication for setting the values for replay parameters?() A. The COMMIT order in the captured workload is preserved during replay.B. The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.D. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.E. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.
View the Exhibit to examine the parameters set for your database instance.You execute the following command to perform I/O calibration after the declaration of bind variables in the session that are used in the command:Which statement describes the consequence?（）A. The command produces an error.B. The calibration process runs successfully and populates all the bind variables.C. The calibration process runs successfully but the latency time is not computed.D. The calibration process runs successfully but only the latency time is computed.Only users with the SYSDBA privilege can run this procedure. Qualified users must also turn on timed_statistics, and ensure asynch_io is enabled for datafiles.
Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.)You restart the instance.To what value will the MEMORY_MAX_TARGET parameter be set by default?() A.120MB.320MC.480MD.600M
View the Exhibit to examine the parameter values.You are planning to set the value for the MEMORY_TARGET parameter of your database instance.What value would you recommend?() A. 90 MBB. 272 MBC. 362 MBD. 1,440 MB
Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0MEMORY_TARGET=0SGA_TARGET=0PGA_AGGREGATE_TARGET=500mWhich three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）A. LOG_BUFFERB. SORT_AREA_SIZEC. JAVA_POOL_SIZED. STREAMS_POOL_SIZEE. DB_16K_CACHE_SZIEF. DB_KEEP_CACHE_SIZE
Your network consists of a single Active Directory domain that contains two domain controllers. Both domain controllers run Windows Server 2003 Service Pack 2 (SP2). Auditing of successful account logon events is enabled on all computers in the domain. You need to identify the last time a specific user logged on to the domain. What should you do?（）A、Examine the System Event Log on the user’s computer.B、Examine the System Event Log on both domain controllers.C、Examine the Security Event Log on both domain controllers.D、Examine the Application Event Log on the user’s computer.
下列系统消息中，从寻呼信道（F-PCH）发送的有：（）A、CDMA Channel List MsgB、System Parameters MsgC、Extended System Parameters MsgD、Access Parameters MsgE、Neighbor List MsgF、Sync Channel Msg
You are trying to change the polling parameters used by the location manager via the Cisco WCS，and your request is being denied. What is wrong？（）A、Polling values can be changed only in the maintenance window.B、Polling values can be changed only on the location server.C、Your login does not have the correct permissions.D、You must wait for the location server to become available.
Your web application uses a simple architecture in which servlets handle requests and then forward to aJSP using a request dispatcher. You need to pass information calculated in the servlet to the JSP for view generation.This information must NOT be accessible to any other servlet，JSP or session in the webapp. Which two techniques can you use to accomplish this goal？（）A、Add attributes to the session object.B、Add attributes on the request object.C、Add parameters to the request object.D、Use the pageContext object to add request attributes.E、Add parameters to the JSP’s URL when generating the request dispatcher.
The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server： LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’ DB_RECOVERY_FILE_DEST_SIZE = 20G Which statement is true regarding the archived redo log files（）A、It will be created on the local file system.B、It will be created only in the Flash Recovery Area.C、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.D、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.
Examine the values for the following initialization parameters： FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database（）A、The SGA advisor will be disabled.B、The MTTR advisor will be disabled.C、Automatic checkpoint tuning will be disabled.D、Checkpoint information will not be written to the alert log file.
Your alert log file has the following information： Tue May 25 17：43：38 2004 ORA-00060： Deadlock detected. More info in file /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc. What would you do to ensure that database is still running correctly？（）A、examine the trace file and kill the session that caused the deadlockB、examine the trace file and kill both the sessions responsible for the deadlockC、examine the trace file for details and ask the user who caused the deadlock to roll back the transactionD、examine the trace file for details and remember that deadlocks are resolved automatically by Oracle databaseE、examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock
Your network consists of a single Active Directory domain that contains two domain controllers. Both domain controllers run Windows Server 2003 Service Pack 2 (SP2). Auditing of successful account logon events is enabled on all computers in the domain. You need to identify the last time a specific user logged on to the domain. What should you do? （）A、Examine the System Event Log on the user’s computer.B、Examine the System Event Log on both domain controllers.C、Examine the Security Event Log on both domain controllers.D、Examine the Application Event Log on the user’s computer.
多选题Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）ALOG_BUFFERBSORT_AREA_SIZECJAVA_POOL_SIZEDSTREAMS_POOL_SIZEEDB_16K_CACHE_SZIEFDB_KEEP_CACHE_SIZE
单选题Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance. To what value will the MEMORY_MAX_TARGET parameter be set by default?（）A120MB320MC480MD600M
多选题You decided to configure the flash recovery area in your database to centralize the storage of all the recovery files in a certain location on disk. Which two parameters will you specify in the init.ora file？（）ADB_CREATE_FILE_DESTBDB_RECOVERY_FILE_DESTCDB_RECOVERY_FILE_DEST_SIZEDDB_ONLINE_LOG_DEST_n
单选题A: Excuse me. I’d like to exchange this watch. I just bought it, but look at this. B: ______AYes, I know your watch is new, but I like my old one better.BWhat seems to be the problem?CThank you for your kindness, but my watch still works.DSorry. Why didn’t you examine it carefully before you bought it?
多选题Examine the values for the following initialization parameters： FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database（）AThe SGA advisor will be disabled.BThe MTTR advisor will be disabled.CAutomatic checkpoint tuning will be disabled.DCheckpoint information will not be written to the alert log file.
多选题下列系统消息中，从寻呼信道（F-PCH）发送的有：（）ACDMA Channel List MsgBSystem Parameters MsgCExtended System Parameters MsgDAccess Parameters MsgENeighbor List MsgFSync Channel Msg
单选题By saying “... we’re going to look the other way in terms of what our laws are” (Line 2, Para. 4), Mayor Anderson means “_____”.Awe will turn a blind eye to your if legal statusBwe will examine the laws in a different wayCthere are other ways of enforcing the lawDthe existing laws must not be ignored
单选题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
多选题Your web application uses a simple architecture in which servlets handle requests and then forward to aJSP using a request dispatcher. You need to pass information calculated in the servlet to the JSP for view generation.This information must NOT be accessible to any other servlet，JSP or session in the webapp. Which two techniques can you use to accomplish this goal？（）AAdd attributes to the session object.BAdd attributes on the request object.CAdd parameters to the request object.DUse the pageContext object to add request attributes.EAdd parameters to the JSP’s URL when generating the request dispatcher.
单选题The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server： LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’ DB_RECOVERY_FILE_DEST_SIZE = 20G Which statement is true regarding the archived redo log files（）AIt will be created on the local file system.BIt will be created only in the Flash Recovery Area.CIt will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.DIt will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.
单选题You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?（）AOPTIMAL BINITIAL CPCTINCREASE DNEXT
多选题Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）ALOG_BUFFERBSORT_AREA_SIZECJAVA_POOL_SIZEDSTREAMS_POOL_SIZEEDB_16K_CACHE_SZIEFDB_KEEP_CACHE_SIZE