网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Examine the parameter for your database instance: You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan: Identify the reason why the optimizer chose different execution plans.（）
- A、The optimizer used a dynamic plan for the query.
- B、The optimizer chose different plans because automatic dynamic sampling was enabled.
- C、The optimizer used re-optimization cardinality feedback for the query.
- D、The optimizer chose different plan because extended statistics were created for the columns used.
参考答案
更多 “ Examine the parameter for your database instance: You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan: Identify the reason why the optimizer chose different execution plans.（）A、The optimizer used a dynamic plan for the query.B、The optimizer chose different plans because automatic dynamic sampling was enabled.C、The optimizer used re-optimization cardinality feedback for the query.D、The optimizer chose different plan because extended statistics were created for the columns used.” 相关考题
考题
We will do our best to ( ) shipment to meet your requirements in time.
A.expectB.expediteC.exerciseD.examine
考题
You are writing a method that accepts a string parameter named message.Your method must break the message parameter into individual lines of text and pass each line to a second method named Process.Which code segment should you use?（）A.B.C.D.
考题
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()
A. Set MEMORY_TARGET to zeroB. Set the STATISTICS_LEVEL parameter to BASICC. Set the WORKAREA_SIZE_POLICY parameter to MANUALD. Set the PGA_AGGREGATE_TARGET parameter to nonzero value
考题
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.
考题
Which statement about Automatic Memory Management with Oracle 11g is true?()
A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.B. Oracle can reallocate memory between the SGA and PGA automatically as needed.C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA 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?()
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
考题
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true？（）A、Displays only the list of default valuesB、Displays only the list of all basic parametersC、Displays the currently in effect parameter valuesD、Displays only the list of all advanced parametersE、Displays the list of all the parameter files of a databaseF、Displays the current contents of the server parameter file.
考题
Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH; What would be the outcome of this command？（）A、The command would return an error because LOG_BUFFER is a static parameter.B、The parameter value would be changed and it would come into effect immediately.C、You need to restart the database so that parameter changes can come into effect.D、The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
考题
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile
考题
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.
考题
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
考题
You have a computer that runs Windows 7. You configure the computer to automatically install all updates.You need to verify whether a specific update is installed. What should you do?（）A、In Event Viewer， examine the Application log.B、In Windows Update， examine the update history.C、At the command prompt， run Wusa.exe and specify the /kb parameter.D、At the command prompt， run Verifier.exe and specify the /query parameter.
考题
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.
考题
You are the administrator of a small network supporting Windows NT 4.0 computers. You configure a setup script to automatically upgrade Windows NT Workstation 4.0 computers to Windows 2000 Professional. When you attempt to test the process on a single computer， you receive this error message： "The specified Setup script file （path：/unattend.txt） is inaccessible or invalid. Contact your system administrator." Which action will most likely resolve this error？ （）A、Add the UnattendedInstall="Yes" parameter to the [Unattended] section of your Unattend.txt fileB、Add the UnattendMode=FullUnattended parameter to the [Data] section of your Unattend.txt fileC、Add the UnattendedInstall="Yes" parameter to the [GuiUnattended] section of your Unattend.txt fileD、Add the UnattendMode=FullUnattended parameter to the [Unattended] section of your Unattend.txt file
考题
多选题You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）ASet the UNDO_RETENTION parameter to AUTO.BCreate an initial undo segment in undotablespace.CSet the UNDO_RETENTION parameter to 900 or moreDSet the initialization parameter UNDO_MANAGEMENT to AUTOESet the UNDO_MANAGEMENT parameter to the name of an undotablespace
考题
单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）A
Set MEMORY_TARGET to zeroB
Set the STATISTICS_LEVEL parameter to BASICC
Set the WORKAREA_SIZE_POLICY parameter to MANUALD
Set the PGA_AGGREGATE_TARGET parameter to nonzero value
考题
单选题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
考题
单选题Your database block size is 4 KB. In this database， you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace？（）A
The parameter DB_CACHE_SIZE must be a multiple of 8.B
The value of the parameter SGA_MAX_SIZE must be increased.C
The tablespace must be created with a uniform extent size of 8 KBD
The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.
考题
单选题Examine the parameter setting in your database: Which statement is correct about the database?（）A
Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not setB
The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are setC
The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are setD
Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup
考题
单选题Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH； What would be the outcome of this command？ （）A
The command would return an error because LOG_BUFFER is a static parameter.B
The parameter value would be changed and it would come into effect immediately.C
You need to restart the database so that parameter changes can come into effect.D
The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
考题
单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this？（）A
Set MEMORY_TARGET to zeroB
Set the STATISTICS_LEVEL parameter to BASICC
Set the WORKAREA_SIZE_POLICY parameter to MANUALD
Set the PGA_AGGREGATE_TARGET parameter to nonzero value
考题
单选题Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true？（）A
Displays only the list of default valuesB
Displays only the list of all basic parametersC
Displays the currently in effect parameter valuesD
Displays only the list of all advanced parametersE
Displays the list of all the parameter files of a databaseF
Displays the current contents of the server parameter file.
考题
单选题In your Certkiller .com production database， you find that the database users are able to create and read files with unstructured data， available in any location on the host machine from an application. You want to restrict the database users to access files in a specific location on the host machine. What could do to achieve this？（）A
Modify the value for the UTL_FILE_DIR parameter in the parameter fileB
Grant read and write privilege on the operating system path to the database usersC
Modify the value for the LDAP_DIRECTORY_ACCESS parameter in the parameter fileD
Modify the value for the PLSQL_NATIVE_LIBRARY_DIR parameter in the parameter fileE
Create a directory object referring to the operating system path， and grant read and write privilege on the directory object to the database users
考题
单选题You have a computer that runs Windows 7. You configure the computer to automatically install all updates.You need to verify whether a specific update is installed. What should you do?（）A
In Event Viewer， examine the Application log.B
In Windows Update， examine the update history.C
At the command prompt， run Wusa.exe and specify the /kb parameter.D
At the command prompt， run Verifier.exe and specify the /query parameter.
考题
单选题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.
考题
多选题Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）Acontrol fileBall datafilesCpassword fileDonline redo log fileEarchive redo log fileFserver parameter fileGonly the SYSTEM datafile
热门标签
最新试卷
