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

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

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.

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

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

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）

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.

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

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

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.

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

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.

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

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.

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.

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.

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.

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

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.

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.

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

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

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