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 . Issue ALTER DATABASE BACKUP CONTROLFILE TO filename B . Make a copy of the control file with the database shut down C . Issue ALTER DATABASE BACKUP CONTROLFILE TO trace D . Make a copy of the control file with the database still running&e

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 . Log on to a domain controller and run the Resultant Set of Policy wizard in planning mode on the domain B . Log on to each server and run Security Configuration and Analysis to analyze the security settings by using a custom security template C . Create a logon script to run the secedit command to analyze all servers in the domain D . Run the Microsoft Baseline Security Analyzer （MBSA） on a server to scan for Windows vulnerabilities on all servers in the domai

A . With the Cargo Gear Register on the ship B . In the Official Log C . At the Coast Guard Marine Safety Office with the vessel's inspection records D . At the central records center of the agency testing the cargo gear

A . ISM B . SOLAS C . DOC D . SMS

A .  The target database must be in the MOUNT mode to ensure restoration of the datafiles. B .  You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility. C .  The control file must be recreated. D .  The database must be opened with the RESETLOGS option.

A . Run the sfc.exe command-line tool. B . Run the convert.exe command-line tool.  C . From Disk Management, format the volume and select the NTFS file system. D . From Disk Management, upgrade the disk that contains the volume to a dynamic disk.

A . Calling frequency B . Distress frequency C . Urgency frequency D . Working frequency

A . To store the backup information of multiple database B . To restrict the amount of space that is used by the backups C . To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter. D . To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

A .  by using the Flashback Database feature B .  by using RMAN incomplete recovery C .  by performing a user-managed incomplete recovery D .  by dropping and re-creating the index tablespace

A .  V$DATABASE B .  V$FLASHBACK_DATABASE_STAT C .  V$FLASHBACK_DATABASE_LOG D .  V$RECOVERY_FILE_DEST

A .  online redo log files B .  alert log files C .  control file D .  datafiles associated with the SYSTEM tablespace

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 . To store the backup information of multiple database B . To restrict the amount of space that is used by the backups C . To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter. D . To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

A . Datafiles B .  Current control file C .  Server parameter file （spfile） D .  Password file

A .  Increase the value of the FAST_START_MTTR_TARGET initialization parameter. B .  Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter. C .  Increase the value of the PGA_AGGREGATE_TARGET initialization parameter. D .  Increase the value of the SGA_TARGET initialization parameter.

A . Client operating systems in use. B . Server operating systems in use. C . VPN client access by using PPTP. D . Installation of Active Directory client software.

A . Corrupted blocks, if any, are repaired. B . Checks are performed for physical corruptions. C . Checks are performed for logical corruptions. D . Checks are performed to confirm whether all database files exist in correct locations E . Backup sets containing both data files and archive logs are created.

A .  Client operating systems in use. B .  Server operating systems in use. C .  VPN client access by using PPTP. D .  Installation of Active Directory client software.

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 . Create a Microsoft SQL Server 2005 Integration Services （SSIS） package that alters the partition queries and processes aggregated partitions every evening. B . Enable proactive caching on the partitions. Set the cache to update periodically with a latency of 24 hours. C . Set the rebuild interval of the partitions to 36 hours. Create a Microsoft SQL Server 2005 Integration Services （SSIS） package that processes aggregated partitions every evening. D . Enable proactive caching on the ProductOrderStatus measure group. Set scheduled polling that re-processes the measure group whenever the system dates change.

You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository.Which condition must be met before you create the VPC？（） A. A base catalog exists B. The recovery catalog is empty C. The base recovery catalog must be dropped D. A target database is registered in the recovery catalog