网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
In what state are the datafiles of a tablespace after a TSPITR has been successfully completed?()
A

 The datafiles have an ONLINE status.

B

 The datafiles have an OFFLINE status.

C

 The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.

D

 The datafiles have an OFFLINE status and are in hot backup mode for an online backup.

E

 The datafiles are in STANDBY mode.


参考答案

参考解析
解析: 暂无解析
更多 “单选题In what state are the datafiles of a tablespace after a TSPITR has been successfully completed?()A  The datafiles have an ONLINE status.B  The datafiles have an OFFLINE status.C  The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.D  The datafiles have an OFFLINE status and are in hot backup mode for an online backup.E  The datafiles are in STANDBY mode.” 相关考题
考题 During tablespace creation, which filename format is NOT used for creating datafiles associated with a tablespace?()A、 incomplete namesB、 incomplete names with templatesC、 alias with template namesD、 numeric names

考题 When exporting metadata for the transportable tablespaces, what is the correct next step after confirming endian format?()A、 Export the tablespaces using data pump.B、 Determine if the transportable set is self-contained.C、 Convert the datafiles using RMAN.D、 Copy the datafiles from source to destination.

考题 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? ()A、The database is in NOMOUNT state.B、The database is in ARCHIVELOG mode and the tablespace is online.C、The database is in ARCHIVELOG mode and the tablespace is offline.D、The database is in NOARCHIVELOG mode and the tablespace is online.E、The database is in NOARCHIVELOG mode and the tablespace is offline.

考题 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 database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement:   SQL DROP TABLE SCOTT.EMP PURGE;   After one hour, you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup?()A、 the datafiles associated with the SYSTEM tablespaceB、 the datafiles associated to the DATA1 tablespaceC、 the datafiles associated to the SYSTEM and DATA1 tablespacesD、 all the datafiles in the database

考题 What must be done to make a shared tape drive highly available?()  A、 Ensure the rmt numbers are unique per node.B、 Nothing,because HACMP manages the state of the tape drive.C、 Nothing,because highly available tape devices are not supported.D、 Ensure that the tape device is in a defined state after system startup.

考题 In RMAN, when the RESYNC CATALOG command is issued, in which two situations does the command file actually perform synchronization?()A、After the COPY command.B、After adding a data file in the target database.C、After adding a tablespace in the target database.D、After adding a tablespace in the catalog database.E、After dropping a data file in the catalog database.F、After running SQL Loader to load a large amount of data.

考题 Which of the following are included in a transportable tablespace set?()  A、 The datafiles that make up a self-contained group of tablespaces required for copyB、 The system tablespaceC、 An export of the tablespace metadataD、 The spfileE、 All of the above

考题 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

考题 In what state are the datafiles of a tablespace after a TSPITR has been successfully completed?()  A、 The datafiles have an ONLINE status.B、 The datafiles have an OFFLINE status.C、 The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.D、 The datafiles have an OFFLINE status and are in hot backup mode for an online backup.E、 The datafiles are in STANDBY mode.

考题 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;

考题 You took the DATA1 tablespace offline at 10:00 A.M. At 12:30 P.M., a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2:00 P.M. and decided to perform an incomplete recovery.  Which datafiles will you recover?()A、 all the datafiles in the databaseB、 the datafiles associated with the SYSTEM tablespaceC、 the datafiles associated with the DATA1 tablespaceD、 all the datafiles in the database except those associated with the DATA1 tablespace

考题 单选题You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?()A One tablespace has only one datafileB Many tablespaces can share one datafileC One tablespace can have many datafilesD One datafile can contain many tablespaces

考题 单选题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. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement:   SQL DROP TABLE SCOTT.EMP PURGE;   After one hour, you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup?()A  the datafiles associated with the SYSTEM tablespaceB  the datafiles associated to the DATA1 tablespaceC  the datafiles associated to the SYSTEM and DATA1 tablespacesD  all the datafiles in the database

考题 单选题A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?()A Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. B Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online. C Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.D Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode. 

考题 单选题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.

考题 单选题What must be done to make a shared tape drive highly available?()A  Ensure the rmt numbers are unique per node.B  Nothing,because HACMP manages the state of the tape drive.C  Nothing,because highly available tape devices are not supported.D  Ensure that the tape device is in a defined state after system startup.

考题 单选题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.

考题 多选题Which of the following are included in a transportable tablespace set?()AThe datafiles that make up a self-contained group of tablespaces required for copyBThe system tablespaceCAn export of the tablespace metadataDThe spfileEAll of the above

考题 多选题The ORDERS table in the database of a company contains one million records. The table is stored in the DATA tablespace and the index created on the ORDERS table is stored in the index tablespace named INDEXES. On Monday, you failed to start the database because the datafiles of the INDEXES tablespace were missing. You dropped and recreated the INDEXES tablespace by issuing the following command:    SQLDROP TABLESPACE INDEXES INCLUDING CONTENTS;    SQL CREATE TABLESPACE INDEXES DATAFILE   ’C:///ORACLE/ORADATA/ORA101t/INDEX01.DBF’ SIZE 50m;   After that, you issued the following command to recreate the index:    CREATE UNIQUE INDEX sales_index_pk ON sales (order_id)   PCTFREE 10   INITRANS 2   MAXTRANS 255   TABLESPACE indexes   STORAGE (   INITIAL 1m  NEXT 1m   PCTINCREASE 0   MINEXTENTS 1   MAXEXTENTS 8192  )   NOLOGGING   PARALLEL( degree 4)   Which two clauses are responsible for reducing the time for the recreation of the index?()APCTFREEBMAXTRANSCPCTINCREASEDINITIALENOLOGGINGFPARALLEL

考题 单选题A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message: Which is the recommended sequence of operations you need to perform for the query successfully?()A  Drop the affected tablespace,re-create the tablespace,restore the datafiles,and the tablespace.B  Take the affected datafile offline(if not already offline),restore the damaged image of the datafile,and then bring it online.C  Restart the database in MOUNT mode,restore the damaged datafile,recover the datafile and then open the database with resetlogs.D  Put the database in RESTRICTED mode,restore all the datafiles in the affected datafile and recover the tablespace,and then put the database in normal operational mode.

考题 单选题When exporting metadata for the transportable tablespaces, what is the correct next step after confirming endian format?()A  Export the tablespaces using data pump.B  Determine if the transportable set is self-contained.C  Convert the datafiles using RMAN.D  Copy the datafiles from source to destination.

考题 单选题Your database is configured in NOARCHIVELOG mode. Due to a media failure, you have lost one of the datafiles belonging to a read-only tablespace. You know that the last backup was performed after the tablespace was made read-only. Which action should you take to restore the missing datafile in the minimum amount of time?()A  Restore all the datafiles from the backup.B  Restore only the lost datafile from the backup.C  Restore all the datafiles for the lost tablespace from the backup.D  Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.

考题 单选题Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database:   a. Restore the three database datafiles that were lost.  b. Issue the Startup Mount command to mount the database.  c. Issue the alter database open command.  d. Issue the alter database open resetlogs command.  e. Recover the database using the recover database command. f. Recover the datafiles with the recover datafile command.  g. Take the datafiles offline.  Which is the correct order of these steps in this case?()A a, b, e, cB b, e, dC a, b, d, cD b, g, c, fE a, b, d, f

考题 单选题Examine the statement: DROP TABLESPACE IND2  INCLUDING CONTENTS  AND DATAFILES;   What is the result of the statement?()A AB BC CD D

考题 单选题You took the DATA1 tablespace offline at 10:00 A.M. At 12:30 P.M., a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2:00 P.M. and decided to perform an incomplete recovery.  Which datafiles will you recover?()A  all the datafiles in the databaseB  the datafiles associated with the SYSTEM tablespaceC  the datafiles associated with the DATA1 tablespaceD  all the datafiles in the database except those associated with the DATA1 tablespace