The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.
If you restart the database, the database will not be opened.
第1题:
Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()
第2题:
Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace. On Monday, you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace. On Tuesday, you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15. When you try to open the database on Wednesday morning, you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table?()
第3题:
You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace: RMAN> BACKUP TABLESPACE DETTBS; Under which conditions would this command execute successfully? ()
第4题:
You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8:00 P.M. Your database is running in ARCHIVELOG mode. On Monday, at 9:00 A.M., a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace. Which two clauses can you use with the RECOVER command?()
第5题:
You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use?()
第6题:
No warning level or critical level alert will be generated.
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.
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.
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.
第7题:
The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.
If you restart the database, the database will not be opened.
第8题:
The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
If you restart the database,the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.
If you restart the database,the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.
If you restart the database,the database will not be opened.
第9题:
The tablespace, DATA1, is not read-only.
The tablespace, DATA1, is not autoextensible.
The tablespace, DATA1, is not offline.
The segment space management for the tablespace, DATA1, is manual.
第10题:
You must have change tracking enabled in your database
Your database must be running in NOARCHIVELOG mode
To back up a tablespace, it must be in backup mode
To back up a tablespace, it must first be taken offline
第11题:
the datafiles associated with the SYSTEM tablespace
the datafiles associated to the DATA1 tablespace
the datafiles associated to the SYSTEM and DATA1 tablespaces
all the datafiles in the database
第12题:
The database is in NOMOUNT state.
The database is in ARCHIVELOG mode and the tablespace is online.
The database is in ARCHIVELOG mode and the tablespace is offline.
The database is in NOARCHIVELOG mode and the tablespace is online.
The database is in NOARCHIVELOG mode and the tablespace is offline.
第13题:
Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?()
第14题:
You are working on a database that must be functioning 24 hours a day, 7 days a week. The databaseis configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups()
第15题:
The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace.To accomplish the task, you issued the following command: SQL> ALTER TABLESPACE hi_data BEGIN BACKUP; Which two statements are true in this scenario? ()
第16题:
The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace. To accomplish the task, you issued the following command: SQL> ALTER TABLESPACE hi_data BEGIN BACKUP; Which two statements are true in this scenario?()
第17题:
To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?()
第18题:
The database will open, and the tablespace automatically comes out of the backup mode
The database will be mounted, and recovery must be performed on the USERS tablespace.
The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
第19题:
Restore all the datafiles from the backup.
Restore only the lost datafile from the backup.
Restore all the datafiles for the lost tablespace from the backup.
Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.
第20题:
The database will open,and the tablespace automatically comes out of the backup mode.
The database will be mounted,and recovery must be performed on the USERS tablespace.
The database will be mounted,and data files in the USERS tablespace must be taken out of the backup mode.
The database will not be mounted,and you must restore all the data files for the USERS tablespace from the backup,and perform recovery.
第21题:
The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.
The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.
The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.
The SALES table can be recovered by restoring the SALESTB tablespace from the backup, but the rows inserted on Tuesday need to be inserted again.
第22题:
You must have change tracking enabled in your database
Your database must be running in NOARCHIVELOG mode
To back up a tablespace,it must be in backup mode
To back up a tablespace,it must first be taken offline
第23题:
The MTTR Advisor is disabled.
The database is in NOARCHIVELOG mode.
The tablespace is already in backup mode.
The Flash Recovery Area is not configured.
第24题:
alter tablespace MY_DATA begin backup
alter tablespace MY_DATA start backup
alter tablespace MY_DATA backup begin
alter MY_DATA begin backup
You cannot back up individual tablespaces