网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS which statement is true？（）
A
You cannot perform the TSPITR with the constraints enabled.
B
You must perform the TSPITR recovery of both tablespaces for it to be successful.
C
You can perform TSPITR only on the USERS tablespace.
D
RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically.
E
The TSPITR will only be successful if the constraint is enabled.
参考答案
参考解析
解析：
暂无解析
更多 “单选题Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS which statement is true？（）A You cannot perform the TSPITR with the constraints enabled.B You must perform the TSPITR recovery of both tablespaces for it to be successful.C You can perform TSPITR only on the USERS tablespace.D RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically.E The TSPITR will only be successful if the constraint is enabled.” 相关考题
考题
Which options must you configure while performing an automated Tablespace Point－in－Time Recovery (TSPITR) by using Recovery Manager (RMAN)?()
A. New channels for restore and recovery tasksB. New name for the data files of the tablespaceC. Auxiliary name for the data files of the tablespaceD. Auxiliary destinations for an auxiliary set of data files
考题
When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（）A、 The SYSTEM tablespace.B、 The UNDO tablespace.C、 All tablespaces with tables.D、 All tablespaces with indexes.E、 No tablespaces are automatically restored.
考题
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 te minate abnormally. Which statement is true about the next database startup and the USERS tablespace？（） A、 The database will open，and the tablespace automatically comes out of the backup mode.B、 The database will be mounted，and recovery must be performed on the USERS tablespace.C、 The database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.D、 The database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.
考题
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？（） A、 The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.B、 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.C、 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.D、 If you restart the database，the database will not be opened.
考题
In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）A、flash back the databaseB、perform point-in-time recoveryC、perform a full database recoveryD、drop and re-create the tablespaceE、use Recovery Manager （RMAN） to recover the database
考题
Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）A、Perform Export before TSPITR and Import after TSPITRB、Move objects to another schema that has the same tablespace assignedC、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
考题
You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）A、 take data files from the read-only tablespace offline before performing a recoveryB、 recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the databaseC、 drop the read-only tablespace and re-create the tablespace after recoveryD、 perform a recovery； status of the tablespace in control file will be changed automatically
考题
Examine the command that is used to create a table： SQL CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command） （）A、A CHECK constraint is created on the OID column.B、A NOT NULL constraint is created on the OID column.C、The ORDERS table is the only object created in the USERS tablespace.D、The ORDERS table and a unique index are created in the USERS tablespace.E、The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.
考题
Which of the following statement is incorrect regarding RMAN？（）A、It detects corrupt blocks.B、It performs only offline database backups.C、It omits empty blocks during backups.D、It performs tablespace point-in-time recovery （TSPITR）.
考题
Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）A、 The target database must be in NOARCHIVELOG mode.B、 No backup is required of the database before you perform a TSPITR.C、 You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.D、 If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.E、 If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.
考题
Which options must you configure while performing an automated Tablespace Point-in-Time Recovery(TSPITR) by using Recovery Manager (RMAN)?（）A、New channels for restore and recovery tasksB、New name for the data files of the tablespaceC、Auxiliary name for the data files of the tablespaceD、Auxiliary destinations for an auxiliary set of data files
考题
Why should you back up a duplicated tablespace after a TSPITR is complete？（） A、 The tablespace cannot be duplicated or restored to any point in time after the duplication. B、 The tablespace cannot be duplicated or restored to the point in time before the duplication. C、 The entire database cannot be restored after a TSPITR， so a backup is required.D、 You cannot bring the tablespace online until its been backed up.E、 There is no requirement to do so， as RMAN will back up the tablespace after the TSPITR.
考题
Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS which statement is true？（） A、 You cannot perform the TSPITR with the constraints enabled.B、 You must perform the TSPITR recovery of both tablespaces for it to be successful.C、 You can perform TSPITR only on the USERS tablespace.D、 RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically.E、 The TSPITR will only be successful if the constraint is enabled.
考题
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?（）A、The database will open, and the tablespace automatically comes out of the backup modeB、The database will be mounted, and recovery must be performed on the USERS tablespace.C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
考题
单选题Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?（）A
New channels for restore and recovery tasksB
New name for the data files of the tablespaceC
Auxiliary name for the data files of the tablespaceD
Auxiliary destinations for an auxiliary set of data files
考题
多选题Examine the command that is used to create a table： SQL CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）AA CHECK constraint is created on the OID column.BA NOT NULL constraint is created on the OID column.CThe ORDERS table is the only object created in the USERS tablespace.DThe ORDERS table and a unique index are created in the USERS tablespace.EThe ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.
考题
单选题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?（）A
The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.B
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.C
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.D
If you restart the database, the database will not be opened.
考题
单选题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？（）A
The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.B
If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.C
If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.D
If you restart the database，the database will not be opened.
考题
单选题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 te minate abnormally. Which statement is true about the next database startup and the USERS tablespace？（）A
The database will open，and the tablespace automatically comes out of the backup mode.B
The database will be mounted，and recovery must be performed on the USERS tablespace.C
The database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.D
The database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.
考题
单选题Because of a logical corruption in your production database， you wanted to perform Tablespace Point in Time Recovery （TSPITR）. But before you start the recovery，you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object？（）A
Perform Export before TSPITR and Import after TSPITRB
Move objects to another schema that has the same tablespace assignedC
Perform Incomplete Recovery before TSPITR with the Log Sequence Number （LSN）D
Perform Incomplete Recovery before TSPITR with the System Change Number （SCN）
考题
单选题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 MBC
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.
考题
单选题Which options must you configure while performing an automated Tablespace Point-in-Time Recovery （TSPITR） by using Recovery Manager （RMAN）？（）A
New channels for restore and recovery tasksB
New name for the data files of the tablespaceC
Auxiliary name for the data files of the tablespaceD
Auxiliary destinations for an auxiliary set of data files
考题
单选题Which of the following statement is incorrect regarding RMAN？（）A
It detects corrupt blocks.B
It performs only offline database backups.C
It omits empty blocks during backups.D
It performs tablespace point-in-time recovery （TSPITR）.
考题
多选题Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）AThe target database must be in NOARCHIVELOG mode.BNo backup is required of the database before you perform a TSPITR.CYou must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.DIf you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.EIf you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.
考题
多选题When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（）AThe SYSTEM tablespace.BThe UNDO tablespace.CAll tablespaces with tables.DAll tablespaces with indexes.ENo tablespaces are automatically restored.
考题
单选题Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method.You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）A
Perform Export before TSPITR and Import after TSPITRB
Move objects to another schema that has the same tablespace assignedC
Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D
Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
考题
单选题Why should you back up a duplicated tablespace after a TSPITR is complete？（）A
The tablespace cannot be duplicated or restored to any point in time after the duplication. B
The tablespace cannot be duplicated or restored to the point in time before the duplication. C
The entire database cannot be restored after a TSPITR， so a backup is required.D
You cannot bring the tablespace online until its been backed up.E
There is no requirement to do so， as RMAN will back up the tablespace after the TSPITR.
热门标签
最新试卷
