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？（）

相似题目

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

  查看最佳答案

• When configuring the messaging system， which of the following are valid parameters for the file transport？ （）

  A . File Name B . Operating System C . Location D . Host E . Mode

  查看最佳答案

• our database instance is started using the server parameter file （SPFILE）. You executed a command tochange the value of the LOG_BUFFER initialization parameter：ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）

  A . The command succeeds only if Automatic Memory Management is not enabled. B . The command succeeds， but you need to restart the database for changes to take effect. C . The command returns an error because the size of the redo log buffer cannot be changed dynamically. D . The parameter value is changed and it comes into effect as soon as space becomes available in theSystem Global Area （SGA）

  查看最佳答案

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

  查看最佳答案

• Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository？（） 

  A .  BACKGROUND_DUMP_DEST B .  FOREGROUND_DUMP_DEST C .  CORE_DUMP_DEST D .  USER_DUMP_DEST E .  DIAGNOSTIC_DEST F .  All of the above

  查看最佳答案

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

  查看最佳答案

• Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file？（）

  A . ROWS B . SKIP C . LOAD D . BINDSIZE

  查看最佳答案

• 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

  查看最佳答案

• 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 are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to  ’LOG%t_%s_%r.dbf’.  Why is %r used in the file name format？（） 

  A . to uniquely identify the archived log files with the restore operation B . to uniquely identify the archived log files with the redo log group number C . to uniquely identify the archived log files for each incarnation of the database D . to uniquely identify the archived log files with the number of recovery operations performed

  查看最佳答案

• 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 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？（）

  A .  DB_CREATE_FILE_DEST B .  DB_RECOVERY_FILE_DEST C .  DB_RECOVERY_FILE_DEST_SIZE D .  DB_ONLINE_LOG_DEST_

  查看最佳答案

• Which of the following entries is INVALID in the /etc/resolv.conf file？ （）

  A . nameserver 127.0.0.1 B . # gargoyl is128.66.12.1 C . domainname peanut.com D . search peanut.com cashew.com brazil.com almond.com

  查看最佳答案

• 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

  查看最佳答案

• Which one of the following files includes the parameter NAMES.DIRECTORY_PATH（hostname）？（）

  A . Listener.ora B . Tnsnames.ora C . Cman.ora D . Sqlnet.ora

  查看最佳答案

• The database was started up using a text parameter file. What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement？（）

  A . Only MEMORY is updated. B . Only SPFILE values are updated. C . Only init

  查看最佳答案

• Which of the combustion parameters listed is used in a diesel engine, but NOT related to the injection system?（）

  A . Atomization B . Metering C . Effective stroke D . Penetratio

  查看最佳答案

• 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 executed the following command to back up your control file：  ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  Which initialization parameter is used to specify the location of the trace file？（）

  A . USER_DUMP_DEST B . CORE_DUMP_DEST C . TRACE_DUMP_DEST D . BACKUP_DUMP_DEST E . BACKGROUND_DUMP_DEST

  查看最佳答案

• 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

  查看最佳答案

• Your database instance is started using the server parameter file （SPFILE）. You executed acommand to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH；  What would be the outcome of this command（）

  A . The command succeeds only if Automatic Memory Management is not enabled. B . The command succeeds， but you need to restart the database for changes to take effect. C . The command returns an error because the size of the redo log buffer cannot be changed dynamically. D . The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area （SGA）.

  查看最佳答案

• 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

  查看最佳答案

• 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

  查看最佳答案