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

题目内容 (请给出正确答案)
单选题
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.” 相关考题
考题 You executed the following command to perform a backup of the USERS tablespace:  SQL ALTER TABLESPACE users BEGIN BACKUP; ALTER TABLESPACE users BEGIN BACKUP *  ERROR at line 1:  ORA-01123: cannot start online backup; media recovery not enabled  What could be the reason for this error()A、The MTTR Advisor is disabled.B、The database is in NOARCHIVELOG mode.C、The tablespace is already in backup mode.D、The Flash Recovery Area is not configured.

考题 You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?()A、You must have change tracking enabled in your databaseB、Your database must be running in NOARCHIVELOG modeC、To back up a tablespace, it must be in backup modeD、To back up a tablespace, it must first be taken offline

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

考题 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 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)?() A、 redo logsB、 control fileC、 temporary files of temporary tablespaceD、 the latest backup of only the damaged data fileE、 the latest backup of all the data files In the USERS 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 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?()A、 The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.B、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.C、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.D、 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.

考题 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()A、You can perform consistent backups only.B、You can perform a complete database backup without shutting down the database instance.C、You can back up data files only when all data files have the same SCN recorded in the control file.D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

考题 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 NOARCHIVELOG mode and the tablespace is online.C、 The database is in NOARCHIVELOG mode and the tablespace is offline.D、 The database is in ARCHIVELOG mode and the tablespace is offline.E、 The database is in ARCHIVELOG mode and the tablespace is online.

考题 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? ()A、No transaction on the tablespace is allowed but you can perform queries.B、The tablespace will automatically come out of backup mode when the file copy is complete.C、The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.D、The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.

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

考题 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?()  A、 No transaction on the tablespace is allowed but you can perform queries.B、 The tablespace will automatically come out of backup mode when the file copy is complete.C、 The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.D、 The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.

考题 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?()  A、 alter tablespace MY_DATA begin backupB、 alter tablespace MY_DATA start backupC、 alter tablespace MY_DATA backup beginD、 alter MY_DATA begin backupE、 You cannot back up individual tablespaces

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

考题 单选题You are maintaining your OLTP database in Oracle10g. You have not set the warning level and critical level threshold values for space usage of the DATA1 tablespace. What will be the impact?()A  No warning level or critical level alert will be generated.B  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.C  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.D  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.

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

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

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

考题 单选题You issued the following command:   ALTER TABLE SCOTT.EMP SHRINK SPACE;   The SCOTT.EMP table is stored in the DATA1 tablespace that has the following properties:   DATA1 is a read/write tablespace.   DATA1 is not autoextensible to an unlimited size.  DATA1 is online.   Segment space management for the DATA1 tablespace is manual.   You issued the ALTER TABLE SCOTT.EMP SHRINK SPACE; command that generates the following error:   ORA-10635: Invalid segment or tablespace type    What could be the reason for the failure of the command?()A  The tablespace, DATA1, is not read-only.B  The tablespace, DATA1, is not autoextensible.C  The tablespace, DATA1, is not offline.D  The segment space management for the tablespace, DATA1, is manual.

考题 单选题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?()A  The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.B  The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.C  The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.D  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.

考题 单选题You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?()A You must have change tracking enabled in your databaseB Your database must be running in NOARCHIVELOG modeC To back up a tablespace, it must be in backup modeD To back up a tablespace, it must first be taken offline

考题 单选题You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online.  Which statement about performing user-managed backups in a 24x7 environment is true?()A  You must have change tracking enabled in your databaseB  Your database must be running in NOARCHIVELOG modeC  To back up a tablespace,it must be in backup modeD  To back up a tablespace,it must first be taken offline

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

考题 单选题You executed the following command to perform a backup of the USERS tablespace:  SQL ALTER TABLESPACE users BEGIN BACKUP; ALTER TABLESPACE users BEGIN BACKUP *  ERROR at line 1:  ORA-01123: cannot start online backup; media recovery not enabled  What could be the reason for this error()A The MTTR Advisor is disabled.B The database is in NOARCHIVELOG mode.C The tablespace is already in backup mode.D The Flash Recovery Area is not configured.

考题 多选题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? ()AThe database is in NOMOUNT state.BThe database is in ARCHIVELOG mode and the tablespace is online.CThe database is in ARCHIVELOG mode and the tablespace is offline.DThe database is in NOARCHIVELOG mode and the tablespace is online.EThe database is in NOARCHIVELOG mode and the tablespace is offline.

考题 单选题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?()A  alter tablespace MY_DATA begin backupB  alter tablespace MY_DATA start backupC  alter tablespace MY_DATA backup beginD  alter MY_DATA begin backupE  You cannot back up individual tablespaces