You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（）

A .  Implement transactions for database queries. B .  Close database connections in the application. C .  Use Microsoft ADO.NET in the data access layer. D .  Implement a retry policy in the data access layer.

A . The database must have multiplexed redo logs for the flashback to succeed. B . The database must be MOUNTED for the flashback to succeed. C . The database must use block change tracking for the flashback to succeed. D . The database must be opened in restricted mode for the flashback to succeed. E . The database must be opened with the RESETLOGS option after the flashback is complete. F . The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

A .  Use SQL Server Profiler to identify missing indexes. B .  Use the Database Engine Tuning Advisor to identify missing indexes. C .  Use a Dynamic Management View to analyze query plans. D .  Use a DynamicManagement View to ascertain the number of pending I/O requests.

A . By multiplexing the control files B . By multiplexing the redo log files C . By decreasing the size of redo log files D . By configuring mean time to recover （MTTR） to a lower value E . By setting the UNDO_RETENTION parameter to a higher value

A . a table name which has 100s of records B . a table name which has 10s of records C . a table name which has empty records D . a table name which has 1000s of records E . never use a table name

A . All control files are opened B . All redo files are opened C . The password file is opened D . The parameter file is opened E . All online data files are opened

A . BFILE  B . REF column  C . Object table  D . Column object  E . INSTEAD-OF trigger

A .   STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN； B .   STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS； C .   STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS； D .   STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

A .  SYSDATE should not be used with TIMESTAMP. B .  The database must have multiplexed redo log files. C .  The database must be in the MOUNT state to execute the command. D .  The database must be opened with the RESETLOGS option after the flashback operation. E .  The entire database needs to be restored from the most recent backup before the flashback operation.

A . The online redo log files and online data files are opened. B . All the online data file headers are checked for consistency. C . Instance recovery is performed before opening the database. D . The path and existence of all the log file members are checked

A .  user managed complete recovery B .  user managed incomplete recovery C .  RMAN-based complete recovery D .  RMAN-based incomplete recovery

A . The source database backup must be copied over the net for test database. B . The source database must be run in ARCHIVELOG mode if the database is open. C . The source database must be shut down cleanly if the database is in mounted state. D . A net service name should be set up and a listener configured with the target as well as the source database.

A . The online redo log files and online data files are opened. B . All the online data file headers are checked for consistency. C . Instance recovery is performed before opening the database. D . The path and existence of all the log file members are checked

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

A .  log_file_name_convert B .  convert_log_file_name C .  file_name_convert_log D .  redo_log_file_name_convert E .  logfile_convert_directory

A .  Put the database in hot backup mode and perform an online backup，including backing up the  archived redo logs. B .  Just back up the database datafiles without shutting down the database. C .  You will have to wait until you can shut down the database to perform the backup. D .  Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up. E .  Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the  course of the remaining backu

A . A backup of the target database when it is mounted B . A backup of online redo log files when the database is open C . A backup of only used data blocks in the file beingbeingbackup up D . A backup of online， read/write data files when the database is open E . A backup of only those data blocks that have changed since a previous backup F . A backup of online， read/write data files when the database is in the NOMOUNT state.

A . DBA_SCHEDULER_RUNNING_JOBS B . DBA_SCHEDULER_JOB_RUN_DETAILS C . DBA_SCHEDULER_JOBS D . DBA_SCHEDULER_JOB_LOG

A . You can perform consistent backups only. B . You can perform a complete database backup without shutting down the database instance. C . You can back up data files only when all data files have the same SCN recorded in the control file. D . You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP command

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 . SYSDATE should not be used with TIMESTAMP. B . The database must have multiplexed redo log files. C . The database must be in the MOUNT state to execute the command. D . The database must be opened with the RESETLOGS option after the flashback operation. E . The entire database needs to be restored from the most recent backup before the flashback operation.

A . Only the data files. B . Only the data files and the online logs. C . The data files， control files， and the online logs. D . The data files and control files， but not the online logs.

You are connected to a pluggable database (PDB) as a common user with DBA privileges.The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:SQL ＞ ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE;Which is true about the result of this command？（） A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened. B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened. C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted. D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.

You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.In which three ways can you re-create the lost disk group and restore the data？（） A. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data. B. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group. C. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data. D. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data. E. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group. F. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.