a, c, f, g
b, d, e, h
a, b, c, f, g
d, a, e, g
b, c, f, e, g
第1题:
You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided, which approach would you take to solve the problem? ()
第2题:
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()
第3题:
At database startup, you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes?()
第4题:
You took the DATA1 tablespace offline at 10:00 A.M. At 12:30 P.M., a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2:00 P.M. and decided to perform an incomplete recovery. Which datafiles will you recover?()
第5题:
When performing an incomplete recover of the whole database, which data files must you restore? ()
第6题:
Which of the following are included in a transportable tablespace set?()
第7题:
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()
第8题:
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?()
第9题:
You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?()
第10题:
One tablespace has only one datafile
Many tablespaces can share one datafile
One tablespace can have many datafiles
One datafile can contain many tablespaces