You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace?()
时间:2022-09-29
Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs?()
You want to check all the data blocks being written to the datafiles by analyzing the data on each block every time the DBWn process writes. Which action will you perform to check the data blocks?()
时间:2022-09-28
You issued the following statement: SQL> ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1; Which parameter is NOT overridden by using the above statement?()
You decided to configure the flash recovery area in your database to centralize the storage of all the recovery files in a certain location on disk. Which two parameters will you specify in the init.ora file?()
You want to purge job entries older than 5 days from the job log. You do not want to purge window log entries. Which command will you use to accomplish this task?()
时间:2022-09-27
An RMAN backup job fails, displaying the following error message: ORA19809: limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. What would you do to resolve the error?()
时间:2022-09-26
You are performing a database recovery because a user’s schema is dropped. While performing the recovery, you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing?()
On Monday, you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday, you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct?()
The size of the largest datafile, data1.dbf, in your database is 30MB. You issued the following command: RMAN>CONFIGURE MAXSETSIZE 10MB; What will be the impact of the above setting?()
Which two statements regarding compressed backups in Recovery Manager (RMAN) are true?()
时间:2022-09-25
You executed the following FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); Which two statements are correct?()
In which scenario will you perform an incomplete recovery?()
You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area?()
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups. Which two backups would you be able to perform when the database is being accessed by users?()
时间:2022-09-24