网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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 backup
- B、 alter tablespace MY_DATA start backup
- C、 alter tablespace MY_DATA backup begin
- D、 alter MY_DATA begin backup
- E、 You cannot back up individual tablespaces
参考答案
更多 “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” 相关考题
考题
USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format.Which methodswould you use to achieve this?（）A. Use Data Pump to transfer the existing data to a new encrypted tablespaceB. Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespaceC. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespaceD. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespaceE. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted
考题
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 execute the following command to change the status of the SALES tablespace： SQL ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）A、The tablespace would require recovery to go back online.B、A checkpoint is taken on all data files that are associated with the SALES tablespace.C、The sessions that subsequently try to access the objects in the SALES tablespace receive an error.D、The new status of the SALES tablespace is recorded in the control file when the database instance is closed.
考题
You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager （RMAN）. The most recent backup of the TOOLS tablespace to disk was taken on January 3. The TOOLS tablespace is read/x7fonly. On February 21， when you execute a command to back up all the tablespaces to disk， you find that RMAN backs up the TOOLS tablespace also， even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLS tablespace， you decide that the tablespace should not be backed up by RMAN. What can you to do skip backing up the TOOLS tablespace without changing the current backup optimization setting？（）A、configure a default device for RMAN backupsB、temporarily disable the retention policy for RMAN backupsC、configure automatic channel allocation for RMAN backupsD、use the CONFIGURE command to reconfigure the recovery window to 60 days
考题
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.
考题
You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）A、run a procedure to check the tablespace space usageB、define the warning threshold for the tablespace at 75% in Database ControlC、create a trigger to be executed when tablespace space usage reaches 75%D、submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervalsE、define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command
考题
Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode？（） A、 alter tablespace DAVE_TBS backup modeB、 alter tablespace DAVE_TBS start backupC、 alter tablespace DAVE_TBS begin backupD、 alter tablespace DAVE_TBS backup beginE、 alter tablespace DAVE_TBS backup
考题
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 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 of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?（）A、alter tablespace DAVE_TBS backup modeB、alter tablespace DAVE_TBS start backup C、alter tablespace DAVE_TBS begin backup D、alter tablespace DAVE_TBS backup begin E、alter tablespace DAVE_TBS backup
考题
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.
考题
Adam is working as a Database Administrator （DBA） for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup， he discovers that one of the disks crashed， resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details， he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure， what should Adam do to recover the USERS tablespace？（）A、 Restore the USERS01.dbf file from the backup， and open the database using the STARTUP command.B、 Restore the USERS01.dbf file using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.C、 Restore the USERS01.dbf file from the backup， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.D、 Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
考题
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.
考题
You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）A、 restore the tablespace from the backup； there is no need to apply the redo informationB、 restore the full database to recover the data up to the point when you performed the backupC、 restore the tablespace from the backup and then perform a recovery using the backup control fileD、 restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied
考题
USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methodswould you use to achieve this?（）A、Use Data Pump to transfer the existing data to a new encrypted tablespaceB、Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespaceC、Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespaceD、Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespaceE、Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted
考题
You execute this command in MOUNT mode： ALTER DATABASE ARCHIVELOG； Where is the information that the database is now in ARCHIVELOG mode stored？（）A、SPFILEB、archive logC、control fileD、system tablespace
考题
You execute the following command to change the status of the SALES tablespace：SQL ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）A、The tablespace would require recovery to go back online.B、A checkpoint is taken on all data files that are associated with the SALES tablespace.C、The sessions that subsequently try to access the objects in the SALES tablespace receive an errorD、The new status of the SALES tablespace is recorded in the control file when the database instance isclosed
考题
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.
考题
单选题AUM has been retaining about 15 minutes worth of undo. You want to double the retentionperiod， but not at the expense of new transactions failing. You decide to alter the system to set the parameter UNDO_RETENTION=18000. However， AUM still retains only about 15 minutes worth of undo. What is the problem？ （）A
You need to alter the undo tablespace to add the RETENTION GUARANTEE setting.B
You need to increase the size of the undo tablespace.C
The undo tablespace is not set to auto-extend.D
You need to alter the Recycle Bin to add the RETENTION GUARANTEE setting.
考题
单选题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.
考题
多选题USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methodswould you use to achieve this?（）AUse Data Pump to transfer the existing data to a new encrypted tablespaceBUse ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespaceCUse CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespaceDEnable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespaceEEncrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted
考题
单选题Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?（）A
alter tablespace DAVE_TBS backup modeB
alter tablespace DAVE_TBS start backup C
alter tablespace DAVE_TBS begin backup D
alter tablespace DAVE_TBS backup begin E
alter tablespace DAVE_TBS backup
考题
单选题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.
考题
单选题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.
考题
单选题Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode？（）A
alter tablespace DAVE_TBS backup modeB
alter tablespace DAVE_TBS start backupC
alter tablespace DAVE_TBS begin backupD
alter tablespace DAVE_TBS backup beginE
alter tablespace DAVE_TBS backup
热门标签
最新试卷