Twenty database users are connected to your database. Five of the users are running long queries involving sort operations. The TEMP tablespace is the default temporary tablespace for your database. You are performing offline tablespace backups of individual tablespaces and erroneously execute the following statement：
SQL>ALTER TABLSPACE temp OFFLINE NORMAL；
What is the result of this statement？（）
A. The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected after their queries complete.
B. The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected and must re-execute their queries.
C. The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are not disconnected， but these users must re-execute their queries.
D. The TEMP tablespace is not taken offline. The users using the TEMP tablespace for sorting are not disconnected， and their queries execute successfully.
您可能感兴趣的试卷
你可能感兴趣的试题
You issue the following command on the RMAN prompt.
RMAN> REPORT NEED BACKUP DAYS = 5 DATABASE；
Which statement is true about executing this command？（）
A. It will display a list of files that need incremental backup.
B. It will display a list of files that need backup after five days.
C. It will display a list of files that were backed up in the last five days.
D. It will display a list of files that have not been backed up in the last five days.
E. It will apply the current retention policy to determine the files that need to be backed up.
A. redo log files
B. password file
C. control file
D. change tracking file
A. LIST command
B. CROSSCHECK command
C. REPORT command
D. SHOW command
A. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING；
B. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；
C. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE
D. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
A.Datafiles
B. Current control file
C. Server parameter file （spfile）
D. Password file
Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database.
RMAN> COPY DATAFILE 2 TO ’D：\ORACLE\ORA90\MYNEWDB\DA2.DBF’；
Which two statements are true regarding the backup created using this command？（）
A. The copy of the datafile created is stored in the RMAN repository.
B. The copy of the datafile created can be viewed using the LIST BACKUP command.
C. The copy of the datafile created using this COPY command can be placed only on the disk.
D. The copy of the datafile created is similar to the backup of the file created using the BACKUP command.
E. The copy of the datafile created can be used for recovering the database using the user-managed recovery method.
A. the system change number
B. the locations of the redo log files
C. the locations of the datafiles
D. the physical location of all the database changes
In which scenario， will you issue the following command？（）
RMAN> REPORT NEED BACKUP DAYS 7；
A. to configure RMAN to maintain backup information in the RMAN repository for seven days
B. to configure RMAN to maintain backup information in the control file for at least seven days
C. to display the list of files that have not been backed up for the last seven days
D. to display the list of files that must be backed up within seven days
A. The block change tracking feature is enabled， and the information about the system change number is written in the change tracking file.
B. The block change tracking feature is enabled， and the information about the log sequence number is written in the change tracking file.
C. The block change tracking feature is enabled， and the information about the blocks that are changed since the last backup is written in the change tracking file.
D. The block change tracking feature is enabled， and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.
You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB. You issue the following command from the RMAN prompt to perform a backup of the tablespace：
RMAN> BACKUP TABLESPACE TS1 MAXSETSIZE 100M；
Which statement is true about executing this command？（）
A. The command generates an error.
B. The command backs up the tablespace and creates a backup set of size 200 MB
C. The command backs up the tablespace and creates two backup sets of size 100 MB each.
D. The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.
最新试题
You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）
View the Exhibit. One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9：00 a.m. You noticed this at 11：00 a.m. and you want to perform an incomplete recovery to recover the table. Which statement is true？（）
You disabled the Flashback Database feature by using the following command： SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs？（）
For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）
Consider the recovery steps in each of the cases given below： Case 1： Shut down the database and perform a backup. Restore all the data files. Mount the database. Recover the database. Without applying all the redo log files， open the database using the RESETLOGS option. Back up the database. Case 2： Shut down the database and perform a backup. Restore only the data files of the tablespace where user error damaged the data. Mount the database. Recover the database. Open the database with the RESETLOGS option. Back up the database. Case 3：Shut down the database Restore the data files Open the database Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery？（）
In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup？（）
You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to recreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to recreate the indexes？（）
Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived， and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery： RMAN> RUN { 2> SET UNTIL SEQUENCE 230 THREAD 1; 3> ALTER DATABASE MOUNT; 4> RESTORE DATABASE; 5> RECOVER DATABASE; 6> ALTER DATABASE OPEN RESETLOGS;7> }; With reference to this scenario， which statement is true？（）
You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command： SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）; Which two statements are true？ （）
The loss of the control file forced you to recreate the control file. After recreating it and opening the database， you find that some of the data files are named as MISSINGnnnnn， where nnnnn is a fivedigit number starting with 0. What could be the possible reason？（）