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

相似题目

• You encrypt your files to ensure the security of the files. You want to make a backup copy of the files and maintain their security settings. You have the option of backing up to either the network or floppy disk.  What should you do？（）

  A . Copy the files to a network share on an NTFS volume and do nothing further. B . Copy the files to a network share on a FAT 32 volume and do nothing further. C . Copy the files to a floppy disk that has been formatted by using Windows 2000 Professional.  D . Place the files in an encrypted folder， and then copy the folder to floppy disk.

  查看最佳答案

• 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

  查看最佳答案

• You are maintaining your OLTP database in Oracle10g. You have not set the warning level and critical level threshold values for space usage of the DATA1 tablespace. What will be the impact？（）

  A .  No warning level or critical level alert will be generated. B .  A warning level alert will never be generated， but a critical level alert will be generated when 97 percent space of the DATA1 tablespace is used. C .  A critical level alert will never be generated， but a warning level alert will be generated when 85 percent space of the DATA1 tablespace is used. D .  A warning level alert will be generated at 85 percent space usage of the DATA1 tablespace， and a critical level alert is generated at 97 percent space usage of the DATA1 tablespace.

  查看最佳答案

• 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

  查看最佳答案

• To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor， you can set values for which of the following initialization parameters？（）

  A .  DB_CACHE_SIZE B .  SHARED_POOL_SIZE C .  LARGE_POOL_SIZE D .  JAVA_POOL_SIZE E .  SGA_MAX_SIZE F .  SORT_AREA_SIZE

  查看最佳答案

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

  查看最佳答案

• You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows： Warning （%）： 90  Critical （%）： 95  Which background process is responsible for issuing alerts when the threshold is crossed（）

  A . System monitor （SMON） B . Process monitor （PMON） C . Memory manager process （MMAN） D . Manageability Monitor process （MMON）

  查看最佳答案

• You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUTparameter set to a nonzero value.Which three statements about resumable space allocation are true? （）(Choose three.)

  A . Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session. B . A resumable statement is suspended only if an out of space error occurs. C . When a resumable statement is suspended, the transaction that contains the statement is also suspended. D . A resumable statement can only be suspended and resumed once during the execution of the statement. E . You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a sessio

  查看最佳答案

• You encrypt three files to ensure the security of the files. You want to make a backup copy of these three files and maintain their security settings. You have the option of backing up to either the network or a floppy disk. What should you do？（）

  A . Copy the files to a network share on an NTFS volume. Do nothing further. B . Copy the files to a network share on a FAT32 volume. Do nothing further. C . Copy the files to a floppy disk that has been formatted by using Win2000 Professional. Do nothing further. D . Place the files in an encrypted folder. Then copy the folder to a floppy disk.

  查看最佳答案

• 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 have a hosted Exchange organization.All servers in the organization have Exchange Server 2010 Service Pack 1 （SP1） installed.You need to group a set of users for administrative delegation.  What should you create？（）

  A . a managed folder mailbox policy B . a new distribution group C . a new management role D . a new role assignment policy

  查看最佳答案

• 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 have a server that runs Windows Server 2003 Service Pack 2 (SP2).You need to compare the current security settings of the server to a security template. Which tool should you use?（）

  A . Security Templates snap-in  B . Group Policy Management Console  C . Security Configuration and Analysis snap-in  D . Microsoft Baseline Security Analyzer (MBSA)

  查看最佳答案

• You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value.Which three statements about resumable space allocation are true? （）

  A . Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session. B . A resumable statement is suspended only if an out of space error occurs. （Out of space condition Maximum extents reached condition，Space quota exceeded condition） C . When a resumable statement is suspended, the transaction that contains the statement is also suspended. D . A resumable statement can only be suspended and resumed once during the execution of the statement. E . You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.

  查看最佳答案

• You are maintaining an OLTP database in Oracle10g. You set the value of the LOG_ARCHIVE_TRACE parameter to zero. What is the impact of this setting？ （） 

  A .  The trace files will be disabled only for a specific session. B .  Tracing will be disabled for a client identifier. C .  Tracing will be disabled only for the ARCn process. D .  The SQL Trace facility will be disabled for the instance.

  查看最佳答案

• You have a single Active Directory directory service domain. All servers run Windows Server 2003. You create several new Group Policies. You need to determine the end result of these Group Policies before applying the settings.  What should you do？（）

  A .  Use Resultant Set of Policy （RSoP） in Planning mode. B .  Use Resultant Set of Policy （RSoP） in Logging mode. C .  Use Event Viewer to view the system log. D .  Use Event Viewer to view the application log.

  查看最佳答案

• You have a computer that runs Windows Vista. The computer contains a custom application. You need toexport the user state and the settings of the custom application.  What should you do?（）

  A . Run Loadstate.exe and specify the /config parameter. B . Run Scanstate.exe and specify the /genconfig parameter. C . Modify the miguser.xml file. Run Loadstate.exe and specify the /ui parameter. D . Modify the migapp.xml file. Run Scanstate.exe and specify the /i parameter.

  查看最佳答案

• By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value， you will enable which of the following memory-management options？（）  

  A .  Automatic PGA Memory Management B .  Automatic SGA Memory Management C .  Automatic Shared Memory Management D .  Automatic Memory Management E .  Manual SGA Memory Management F .  None of the above

  查看最佳答案

• You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting？（）  

  A .  The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory. B .  The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory. C .  The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory. D .  The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.

  查看最佳答案

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

  查看最佳答案

• You have a server that runs Windows Server 2003 Service Pack 2 （SP2）. You need to compare the current security settings of the server to a security template. Which tool should you use？（）

  A . Security Templates snap-in B . Group Policy Management Console C . Security Configuration and Analysis snap-in D . Microsoft Baseline Security Analyzer （MBSA）

  查看最佳答案

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

  查看最佳答案

• If you have an option to buy a share for €4 in three years-time, the share price today is €5. If you have told the time value of an option is €2, which value of the option would be

  查看最佳答案