View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D： \oracle\product\10.2.0\oradata\oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）

相似题目

• In your database，the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）

  A . The optimizer statistics are collected automatically. B . Only the timed operating system （OS） statistics and plan execution statistics are collected. C . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization. D . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.  E . Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

  查看最佳答案

• View the Exhibit to examine the replay settings for replay parameters.What is the implication for setting the values for replay parameters?（）https://assets.asklib.com/images/image2/2018080213555554170.png

  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 parameter values. You are planning to set the value for the MEMORY_TARGET parameter of your database instance. What value would you recommend?（） https://assets.asklib.com/images/image2/2018080117085922509.png

  A . 90 MB B . 272 MB C . 362 MB D . 1,440 MB

  查看最佳答案

• Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY,and NLS_CHARACTERSET parameters?（）

  A . V$VALID_NLS_VALUES B . NLS_VALID_VALUES C . NLS_VALUE_OPTIONS D . V$NLS_VALUE_OPTIONS E . V$NLS_VALID_VALUES

  查看最佳答案

• 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.

  查看最佳答案

• Oracle9i offers the ability to monitor the dynamic use of the SGA through the DB_CACHE_ADVICE parameter. When this parameter is set to READY， what is its effect？ （）

  A . The Advisory is on and will capture both CPU and memory overhead. B . The Advisory is on but the memory for the Advisory is not allocated. C . The Advisory is off and the memory for the Advisory is not allocated. D . The Advisory is off but the memory for the Advisory remains allocated.

  查看最佳答案

• （）view of the fact，I wish to submit this report.

  A . In B . On C . To D . For

  查看最佳答案

• What stanza file does a system administrator view to determine what kernel-tuning parameter changes were made when the system was last booted？（）

  A . /etc/rc.net B . /etc/tunables/tuning C . /etc/tunables/lastboot D . /usr/samples/kernel/nextboot

  查看最佳答案

• 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.

  查看最佳答案

• When issuing the duplicate database command， you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter？（）  

  A .  To indicate the location of the auxiliary-instance online redo logs. B .  To indicate the location of the target database datafiles. C .  To indicate the location of the auxiliary-instance control file and online redo logs. D .  To indicate the location of the auxiliary-instance database datafiles. E .  This is not a valid parameter when duplicating a database.

  查看最佳答案

• View the Exhibit and examine the initialization parameter settings. https://assets.asklib.com/images/image2/2018080116211316874.jpg Which three initialization parameters are to be set manually as they are not automatically tuned（）

  A . LOG_BUFFER B . SORT_AREA_SIZE C . JAVA_POOL_SIZE D . STREAMS_POOL_SIZE E . DB_16K_CACHE_SIZE F . DB_KEEP_CACHE_SIZE

  查看最佳答案

• Which statement regarding the contents of the V$PARAMETER view is true？（）

  A . displays only the list of default values B . displays only the list of all basic parameters C . displays the currently in effect parameter values D . displays only the list of all advanced parameters E . displays the list of all the parameter files of a database

  查看最佳答案

• Which of the following commands should be used to view and change the network filesystem tuning parameters available on the system？（）

  A .  no B .  nfso C .  vmtune D .  exportf

  查看最佳答案

• Engine parameters shall be corresponded to NOx Technical Files,This is required by（）

  A . MARPOL Annex Ⅲ B . MARPOL Annex Ⅵ C . MARPOL Annex Ⅴ D . MARPOL Annex Ⅳ

  查看最佳答案

• 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 values B . Displays only the list of all basic parameters C . Displays the currently in effect parameter values D . Displays only the list of all advanced parameters E . Displays the list of all the parameter files of a database F . Displays the current contents of the server parameter file.

  查看最佳答案

• In your database， the STATISTICS_LEVEL initialization parameter is set to BASIC.  What is the impact of this setting？（）

  A . The optimizer statistics are collected automatically. B . Only the timed operating system （OS） statistics and plan execution statistics are collected. C . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization. D . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.  E . Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

  查看最佳答案

• After a number of days set by the parameter CONTROL_FILE_RECORD_KEEP_TIME， the information in the control file is overwritten by RMAN. What is this parameter’s default value？（）

  A . 1 day B . 5 days C . 7 days D . 31 day

  查看最佳答案

• You are granted the CREATE VIEW privilege. What does this allow you to do? （）

  A . Create a table view. B . Create a view in any schema. C . Create a view in your schema. D . Create a sequence view in any schema. E . Create a view that is accessible by everyone. F . Create a view only of it is based on tables that you created.

  查看最佳答案

• In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）

  A . It degrades the run time and compiler performance. B . It provides better run time and compiler performance. C . It provides better optimization of the statement during parse time. D . It forces the rule based optimizer to be used for statement optimization. E . It provides better run time performance but slightly degraded compiler performance. F . It provides better run time performance but slightly degraded run time performance.

  查看最佳答案

• 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 . 120M B . 320M C . 480M D . 600M

  查看最佳答案

• In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）

  A . the alert log file B . the core dump files C . the change tracking file D . the user session trace files E . the database audit trail files F . the background process trace file

  查看最佳答案

• Which command is used to view IPv6 parameters related to the BGP process?（）

  A . show ip bgp ipv6 B . show protocols ipv6 C . show ipv6 bgp D . show bgp ipv6

  查看最佳答案

• –Look this way. You’ll have a good view of the whole mountain. – ---.

  A．Idoit B．Goaway C．Gotit D．Don’tworry

  查看最佳答案

• ---Look this way. You ’ ll have a good view of the whole mountain.

  A．I do it B．Go away C．Got it D．Don ’ t worry

  查看最佳答案