The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)

相似题目

• You are specifying French case-insensitive sorts by using the NSL_SORT parameter for the user session of the user， Scott. Which value will you set for the NLS_SORT parameter？（）

  A .  FRENCH_AI B .  FRENCH_CI C .  AI_FRENCH D .  CI_FRENCH

  查看最佳答案

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

  查看最佳答案

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

  查看最佳答案

• Which of the following are valid settings for the NLS_COMP parameter？（）

  A .  ASCII B .  ANSI C .  BINARY D .  MONOLINGUAL E .  MULTILINGUAL

  查看最佳答案

• Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object？（）

  A .  PLSQL_BLOCK B .  JAVA_STORED_PROCEDURE C .  STORED_PROCEDURE D .  EXECUTABLE E .  None of the above are invalid settings.

  查看最佳答案

• You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY-MM-DD. The default format of which two data types would be affected by this setting？ （）

  A .  DATE B .  TIMESTAMP C .  INTERVAL YEAR TO MONTH D .  INTERVAL DAY TO SECOND E .  TIMESTAMP WITH LOCAL TIME ZONE

  查看最佳答案

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

  查看最佳答案

• The important initial stability parameter，GM，is the（）.

  A . metacentric height B . height of the metacenter above the keel C . height of the center of buoyancy above the keel D . height of the center of gravity above the keel

  查看最佳答案

• Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?（）

  A . PLSQL_BLOCK B . JAVA_STORED_PROCEDURE C . STORED_PROCEDURE D . EXECUTABLE E . None of the above are invalid settings.

  查看最佳答案

• What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?（）

  A . The number of DBWR processes increases B . The number of ASMB processes increases C . The number of DBWR_TO_SLAVES increases D . The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/O overhead

  查看最佳答案

• 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

  查看最佳答案

• The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema.  Which two statements are true regarding the outcome of this action？（）

  A .  All the related indexes and views are automatically dropped B .  The flashback drop feature can recover only the table structure C .  Only the related indexes are dropped whereas views are invalidated D .  The flashback drop feature can recover both the table structure and its data

  查看最佳答案

• Which of the following are valid settings for the NLS_COMP parameter?（）

  A . ASCII B . ANSI C . BINARY D . MONOLINGUAL E . MULTILINGUAL

  查看最佳答案

• You set the following parameters in the parameter file and restarted the database: https://assets.asklib.com/images/image2/2018080210353589884.jpg Which two statements are true regarding these parameters after the database instance is restarted?（）

  A . The MEMORY_MAX_TARGET parameter is automatically set to 500 MB B . The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually C . The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero D . The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively

  查看最佳答案

• 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

  查看最佳答案

• The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?（）

  A . All the related indexes and views are automatically dropped B . The flashback drop feature can recover only the table structure C . Only the related indexes are dropped whereas views are invalidated D . The flashback drop feature can recover both the table structure and its data

  查看最佳答案

• You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）  

  A .  The database will not start. B .  The database will start but will not retain the undo data in the undo segment. C .  The database will start， and the undo segment will contain the undo data for at least one hour. D .  The database will start， and the undo segment will retain the undo data for at least 15 minutes.

  查看最佳答案

• 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

  查看最佳答案

• You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY­MM­DD. The default format of which two data types would be affected by this setting？（）

  A . DATE B . TIMESTAMP C . INTERVAL YEAR TO MONTH D . INTERVAL DAY TO SECOND E . TIMESTAMP WITH LOCAL TIME ZONE

  查看最佳答案

• What are the main parameters of ion selective electrode？What are the main parameters of ion selective electrode？

  查看最佳答案

• What is the parameter TINIT used for？（)

  A．A.To set the initial value of the timer that inhibits handover after a change of channel B．B.To set the initial value of the timer that controls the measurement events of the mobile C．C.To set the initial value of the timer that controls if handover during signaling is allowed or not D．D.To set the initial value of the timer that controls if handover to another BSC is allowed or not E．E.To set the initial value of the timer that controls the filtering process

  查看最佳答案

• You set the following parameters in the parameter file and restarted the database:Which two statements are true regarding these parameters after the database instance is restarted？（）

  <img src='https://img2.soutiyun.com/shangxueba/ask/64233001-64236000/64234478/9691c5b47b07d813739fc0e9660c9439.jpg' /> A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively

  查看最佳答案

• 在Lido/Flight的起飞性能计算中，如果相关航班存在起飞性能限制，点击Parameter界面MALTOW栏“i”标识，系统将显示什么信息（）

  A．Takeoff Performance Weight Limit B．"Takeoff Performance Weight Restriction C．"Takeoff Weight Limit D．"Takeoff Performance Limit 此题为多项选择题。

  查看最佳答案