网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
An important tablespace of your database is dropped by mistake. You use the Flashback Database feature to retrieve the tablespace. You perform the following steps to retrieve the tablespace： 1. You log on to Enterprise Manager as SYSDBA. 2. You select the maintenance screen. 3. You choose Perform Recovery option on the maintenance screen. 4. You choose Whole Database in the Object Type drop-down list Perform Recovery： Type screen. 5. You choose Recover to Current Time from the Operation Type on the Perform Recovery： Type screen. 6. You provide the Host Credentials for a database user. on the Perform Recovery： Type screen. 7. You click the continue button. An information screen appears saying that the database is unavailable. What is this information screen？（）
A
Recovery Manager
B
Recovery Window
C
Recovery Wizard
D
Enterprise Manager Home Page
参考答案
参考解析
解析：
暂无解析
更多 “单选题An important tablespace of your database is dropped by mistake. You use the Flashback Database feature to retrieve the tablespace. You perform the following steps to retrieve the tablespace： 1. You log on to Enterprise Manager as SYSDBA. 2. You select the maintenance screen. 3. You choose Perform Recovery option on the maintenance screen. 4. You choose Whole Database in the Object Type drop-down list Perform Recovery： Type screen. 5. You choose Recover to Current Time from the Operation Type on the Perform Recovery： Type screen. 6. You provide the Host Credentials for a database user. on the Perform Recovery： Type screen. 7. You click the continue button. An information screen appears saying that the database is unavailable. What is this information screen？（）A Recovery ManagerB Recovery WindowC Recovery WizardD Enterprise Manager Home Page” 相关考题
考题
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： SQLALTER 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.
考题
Your Oracle Database 10g is online when you execute the following statement： SQLALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF； What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）A、 The database does not record flashback logs for MY_TABLESPACEB、 The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.C、 All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.D、 None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE
考题
In which scenario will you perform a cancel-based recovery？（）A、 when a tablespace is dropped and you have only RMAN-based backup of the databaseB、 when a table is dropped and stored in the Recycle BinC、 when you are required to recover an existing table to its previous stateD、 when a tablespace is dropped and you have only a user-managed full backup of the database
考题
You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes？（）A、 SQL scriptsB、 Recovery Manager （RMAN） scriptC、 Data PumpD、 SQL*LoaderE、 Flashback database
考题
For which database operation would you need the database to be in the MOUNT state（）A、renaming the control filesB、re-creating the control filesC、dropping a user in your databaseD、dropping a tablespace in your databaseE、configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
考题
Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）A、 undo tablespaceB、 index tablespaceC、 read-only tablespaceD、 temporary tablespace
考题
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）A、renaming the control filesB、dropping a user in your databaseC、enabling or disabling redo log archivingD、dropping a tablespace in your databaseE、re-creating the control files， after you lost all the control files in your database
考题
Examine the following commands executed in your database： SQL ALTER SESSION RECYCLEBIN=ON； Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL DROP TABLE emp；Table dropped. What happens in this scenario？（）A、The table is moved to the SYSAUX tablespace.B、The table is moved to the SYSTEM tablespace.C、The table is removed from the database permanently.D、The table is renamed and remains in the TBSFD tablespace.
考题
In which scenario will you use the Flashback Version Query feature？（）A、 when you want to restore a table that has been dropped from the Recycle BinB、 when you want to identify the transaction ID of the transaction that deleted some important records from a tableC、 when you want to recover the schema of a dropped userD、when you want to restore a dropped tablespace
考题
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？（）A、 UNTIL SEQUENCEB、 UNTIL SCNC、 UNTIL CHANGED、 UNTIL CANCEL
考题
Examine the commands executed in a DBA session：SQL CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered. Which two statements are trueregarding the MRKT tablespace（）A、No more data files can be added to the tablespace.B、Segment space is managed by free lists in the tablespace.C、A user created without being assigned a default tablespace uses this tablespace.D、The tablespace can be dropped with the current setting with segments present in it
考题
You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）A、 by using the Flashback Database featureB、 by using RMAN incomplete recoveryC、 by performing a user-managed incomplete recoveryD、 by dropping and re-creating the index tablespace
考题
Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）A、 DROP TABLESPACE temp1；B、 DROP TABLESPACE temp1 INCLUDING CONTENTS；C、 DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；D、 DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；
考题
There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow. There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）A、Only bring the tablespace back online.B、Only recover the tablespace and then bring the tablespace back online.C、Shut down the database， recover the data file and then start up the database.D、Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.E、Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.
考题
单选题In which scenario will you use the Flashback Version Query feature？（）A
when you want to restore a table that has been dropped from the Recycle BinB
when you want to identify the transaction ID of the transaction that deleted some important records from a tableC
when you want to recover the schema of a dropped userD
when you want to restore a dropped tablespace
考题
单选题There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow. There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）A
Only bring the tablespace back online.B
Only recover the tablespace and then bring the tablespace back online.C
Shut down the database， recover the data file and then start up the database.D
Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.E
Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.
考题
单选题In which scenario will you perform a cancel-based recovery？（）A
when a tablespace is dropped and you have only RMAN-based backup of the databaseB
when a table is dropped and stored in the Recycle BinC
when you are required to recover an existing table to its previous stateD
when a tablespace is dropped and you have only a user-managed full backup of the database
考题
单选题You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code？（） RMANRUN { SET UNTIL SEQUENCE THREAD ； RESTORE DATABASE； RECOVER DATABASE； }A
NOMOUNTB
MOUNTC
OPEND
RESTRICTED
考题
单选题For which database operation would you need the database to be in the MOUNT state（）A
renaming the control filesB
re-creating the control filesC
dropping a user in your databaseD
dropping a tablespace in your databaseE
configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
考题
单选题You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）A
renaming the control filesB
dropping a user in your databaseC
enabling or disabling redo log archivingD
dropping a tablespace in your databaseE
re-creating the control files， after you lost all the control files in your database
考题
单选题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 contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）A
undo tablespaceB
index tablespaceC
read-only tablespaceD
temporary tablespace
考题
单选题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： SQLALTER 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.
考题
单选题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
考题
单选题An important tablespace of your database is dropped by mistake. You use the Flashback Database feature to retrieve the tablespace. You perform the following steps to retrieve the tablespace： 1. You log on to Enterprise Manager as SYSDBA. 2. You select the maintenance screen. 3. You choose Perform Recovery option on the maintenance screen. 4. You choose Whole Database in the Object Type drop-down list Perform Recovery： Type screen. 5. You choose Recover to Current Time from the Operation Type on the Perform Recovery： Type screen. 6. You provide the Host Credentials for a database user. on the Perform Recovery： Type screen. 7. You click the continue button. An information screen appears saying that the database is unavailable. What is this information screen？（）A
Recovery ManagerB
Recovery WindowC
Recovery WizardD
Enterprise Manager Home Page
考题
单选题Examine the following commands executed in your database： SQL ALTER SESSION RECYCLEBIN=ON； Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL DROP TABLE emp；Table dropped. What happens in this scenario？（）A
The table is moved to the SYSAUX tablespace.B
The table is moved to the SYSTEM tablespace.C
The table is removed from the database permanently.D
The table is renamed and remains in the TBSFD tablespace.
考题
多选题You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes？（）ASQL scriptsBRecovery Manager （RMAN） scriptCData PumpDSQL*LoaderEFlashback database
考题
单选题Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）A
DROP TABLESPACE temp1；B
DROP TABLESPACE temp1 INCLUDING CONTENTS；C
DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；D
DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；
热门标签
最新试卷
