You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands： CONFIGURE DEFAULT DEVICE TYPE TO sbt； CONFIGURE BACKUP OPTIMIZATION ON； CONFIGURE RETENTION POLICY TO REDUNDANCY 3； From Monday to Saturday， you performed the following actions： Day Action Monday BACKUP DATABASE Tuesday BACKUP DATABASE Wednesday BACKUP DATABASE Thursday BACKUP DATABASE Friday BACKUP DATABASE Saturday BACKUP DATABASE How many times will the backup of the USERS tablespace be performed？（）
A、 The backup will not be performed at all.
B、 three times
C、 four times
D、 six times
相关问题推荐
-
In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level. You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated. How do you achieve this objective？（）
A、by setting the SQL_TRACE parameter to FALSE in the parameter file
B、by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session
C、by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session
D、by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session
-
Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）
A、recovery cannot be performed because a backup was not performed after the last incomplete recovery
B、restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
C、restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
D、restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday
-
Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message： 01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5： ’/u01/app/oracle/oradata/orcl/example01.dbf’ You need to rectify the corruption while ensuring the following： The data file should remain online. The mean time to recover （MTTR） should be minimal. You are not using a backup control file， and all the archived logs are accessible. Which option would you choose？（）
A、flash back the corrupted blocks
B、use the DBMS_REPAIR package
C、use the RMAN TSPITR command
D、use the RMAN BLOCKRECOVER command
E、use the RESTORE DATABASE and RECOVER DATABASE commands
F、investigate the time at which the corruption occurred and perform a point-in-time recovery
-
关于类和对象描述错误的是()。
A．对象(Object)是现实世界中的客观事物，对象具有确定的属性
B．类是具有相同属性和行为的一组对象的集合
C．对象是类的抽象，类是对象的实例
D．类是对象的抽象，对象是类的实例
-
You have a disk group， DGROUP1， with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group： ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES （MIRROR FINE）; Which statement is true？（）
A、When a file is created in DGROUP1 with the template， it would have threeway mirroring.
B、When a file is created in DGROUP1， the MY_TEMP template becomes the default template.
C、When a file is created in DGROUP1 with the template， it would have twoway mirroring and file striping.
D、When a file is created in DGROUP1 with the template， it would have threeway mirroring and file striping.
E、When a file is created in DGROUP1 with the template， it would have twoway mirroring but no file striping.