×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
Which user-managed backup performed on your database can be labeled as consistent?
2.
You are using RMAN for backup and recovery of your database. You set the retention policy to NONE by
executing the following command:
What would be the impact of this setting?
executing the following command:
RMAN>CONFIGURE RETENT POLICY TO NONE;
What would be the impact of this setting?
3.
You are using RMAN to perform a backup of your database. Which statement is true regarding image copy
backups?
backups?
4.
You decided to use RMAN to perform backup and recovery of your database. During the process of creating
the recovery catalog you executed the following command:
Why do you need to execute this command?
the recovery catalog you executed the following command:
RMAN>register database;
Why do you need to execute this command?
5.
The CONTROL_FILE_RECORD_KEEP_TIME parameter is set to the default value of seven days in your
database. The control file is used as the RMAN repository. But the initial size of the control file is too small to
store all the RMAN information for seven days. What will happen in this scenario?
database. The control file is used as the RMAN repository. But the initial size of the control file is too small to
store all the RMAN information for seven days. What will happen in this scenario?
6.
You back up your database, which is running in ARCHIVELOG mode, at regular intervals. On Monday morning,
you find that one of the data files is corrupted and the database administrator is recovering the file by executing
the following command after restoring the file from a backup:
What is the objective of using the AUTOMATIC option with the RECOVER command?
you find that one of the data files is corrupted and the database administrator is recovering the file by executing
the following command after restoring the file from a backup:
SQL>RECOVER AUTOMATIC datafile 8;
What is the objective of using the AUTOMATIC option with the RECOVER command?
7.
Users in your production database complain that they are not able to access the data from the CUSTOMERS
table. On investigation, you find that the table is truncated and you need to import the table using the Oracle
Import utility. Which option must you use to suppress the object creation error while importing the table?
table. On investigation, you find that the table is truncated and you need to import the table using the Oracle
Import utility. Which option must you use to suppress the object creation error while importing the table?
8.
You started your database at 7:30 a.m. and you backed up three copies of all existing archived log files to tape
at 9:00 a.m. At 10:30 a.m., you executed the following command:
at 9:00 a.m. At 10:30 a.m., you executed the following command:
RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 4;
At 1:00 p.m., you executed the following commands:
RMAN>CONFIGURE BACKUP OPTIMIZATION ON;
RMAN>BACKUP DEVICE TYPE sbt COPIES 2ARCHIVELOG ALL;
Other RMAN configuration parameters are set to their default values. Which statement is correct?
At 1:00 p.m., you executed the following commands:
RMAN>CONFIGURE BACKUP OPTIMIZATION ON;
RMAN>BACKUP DEVICE TYPE sbt COPIES 2ARCHIVELOG ALL;
9.
You are using Recovery Manager (RMAN) to back up your production database at regular intervals. On Monday
morning, the database administrator asks you to execute the following set of commands:
morning, the database administrator asks you to execute the following set of commands:
RMAN>CROSSCHECK BACKUPSET OF DATABASE;
RMAN>DELET NOPROMPT EXPIRED BACKUP;
What could be the reason to execute these commands?
RMAN>DELET NOPROMPT EXPIRED BACKUP;
10.
You require a Web client to be able to make an HTTP connection to an Oracle9i database server while using
an application Web server as middle tier. Where would you install Oracle Net or JavaNet?
an application Web server as middle tier. Where would you install Oracle Net or JavaNet?