AThe backup performed on Sundays contains all the blocks that have ever been used in the database.
BThe backup performed on Sundays contains all the blocks that have changed since the last level 1backup.
CThe backup performed on each working day contains all the blocks that have changed since the lastlevel 0 backup.
DThe backup performed on Monday contains all the blocks that have changed since the level 0 backup,and every other working day contains all the blocks that have changed since the level 1 backup.
View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the FlashbackVersions Query, you find that the first two updates are not listed. What could be the reason?()
单选题查看答案
You work as a database administrator for Certkiller .com. You need to rename a data file of atablespace. How would you perform this?()
单选题查看答案
You need to rename a data file of a tablespace. How would you perform this?()
单选题查看答案
In a new installation of Oracle Database 11g, you perform these activities: 1. Organize software and data on different subdirectories to avoid poor performance. 2. Use consistent naming conventions for database files. 3. Separate administrative information pertaining to the database in different directories. Which optioncorresponds to the type of activities you performed()
单选题查看答案
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?()
多选题查看答案
You work as a database administrator for Certkiller .com. You are using Recovery Manager (RMAN) to perform backups in your databases. Which four backup operations can be performed using RMAN?()
多选题查看答案
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?()
单选题查看答案
Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery,you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?()
单选题查看答案
You executed the following command in Recovery Manager (RMAN): RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed?()
单选题查看答案
You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()
单选题查看答案