×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
Your database is in ARCHIVELOG mode and four archive destinations are defined for your database. You
notice that one of the disks mapped to an archive destination has become inaccessible. You are using the
RMAN BACKUP command to perform a backup of the database including archived log files. What would
happen if RMAN tries to back up the archived log files from this location?
notice that one of the disks mapped to an archive destination has become inaccessible. You are using the
RMAN BACKUP command to perform a backup of the database including archived log files. What would
happen if RMAN tries to back up the archived log files from this location?
2.
Which statement regarding the RMAN repository stored in the control file is true?
3.
Which statement correctly describes RMAN backup and recovery?
4.
You are using Recovery Manager (RMAN) to back up your database at regular intervals. On Monday morning,
you find that the media that has the users.dbf data file is corrupted. You use the RMAN SET NEWNAME
command to restore the file to a new location. Which RMAN command would you use to update the control file
with the new location?
you find that the media that has the users.dbf data file is corrupted. You use the RMAN SET NEWNAME
command to restore the file to a new location. Which RMAN command would you use to update the control file
with the new location?
5.
Because of some data loss, you have to perform a Time-Based incomplete recovery of your test database.
After applying the required archived redo log files, what is the next step that you would perform?
After applying the required archived redo log files, what is the next step that you would perform?
6.
Your database has 10 tablespaces. A few days ago, one of the tablespaces was made read only. In case of a
media failure necessitating a tablespace recovery, which type of tablespace can be re-created rather than
recovered?
media failure necessitating a tablespace recovery, which type of tablespace can be re-created rather than
recovered?
7.
You require a backup of a database that operates in NOARCHIVELOG mode. You performed a backup of the
entire set of data files and control files, but excluded online redo log files from this backup. Which statement
regarding this backup is true?
entire set of data files and control files, but excluded online redo log files from this backup. Which statement
regarding this backup is true?
8.
You need to change the name of a net service name without changing any domains.
Which net configuration file would you edit?
Which net configuration file would you edit?
9.
Under which conditions would you perform an incomplete recovery of a database? (Choose all that apply.)
10.
In your production database, you observe that one of the data files is corrupted while the database was
functional. When investigating the reason, you find that the media has crashed and now you have to restore the
data file to a different location while the database is functional. You have the option of using the following steps:
1. Take the tablespace offline by using the ALTER TABLESPACE command in IMMEDIATE mode.
2. Restore the data file to a new location.
3. Apply the archived redo log files.
4. Use the ALTER DATABASE command to update the control file.
5. Bring the tablespace online by using the ALTER TABLESPACE command. Which sequence of steps would
you use to restore the data file, ensuring near to zero downtime?
functional. When investigating the reason, you find that the media has crashed and now you have to restore the
data file to a different location while the database is functional. You have the option of using the following steps:
1. Take the tablespace offline by using the ALTER TABLESPACE command in IMMEDIATE mode.
2. Restore the data file to a new location.
3. Apply the archived redo log files.
4. Use the ALTER DATABASE command to update the control file.
5. Bring the tablespace online by using the ALTER TABLESPACE command. Which sequence of steps would
you use to restore the data file, ensuring near to zero downtime?