×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You experienced a loss of data files in your database. You did not lose any of your control files. You are going
to use RMAN to restore and recover the database.
Currently, your instance is shut down.
Which sequence of commands is correct to restore and recover your database?
to use RMAN to restore and recover the database.
Currently, your instance is shut down.
Which sequence of commands is correct to restore and recover your database?
2.
When performing recover of a database in NOARCHIVELOG mode with RMAN, the target database must be in
the ______ state to restore the control file.
the ______ state to restore the control file.
3.
You discover that a disk failure occurred on DISK3 where the data file belonging to the USER_DATA
tablespace is stored. The database is currently open and you need to recover the data file. You will restore the
data file from the backup on DISK5 to DISK2. What is the correct sequence of commands to restore and
recover the data file?
tablespace is stored. The database is currently open and you need to recover the data file. You will restore the
data file from the backup on DISK5 to DISK2. What is the correct sequence of commands to restore and
recover the data file?
4.
In this scenario, assume that you archive logs 101 to 104 to two archiving destinations, /log1 and /log2. The
control file contains archived log records as follows:
You run this command:
BACKUP ARCHIVELOG FROM SEQUENCE 101 UNTIL SEQUENCE 105; What happens?
control file contains archived log records as follows:
Sequence Filename
101 /log1/log_1_101.arc
101 /log2/log_1_101.arc
102 /log1/log_1_102.arc
102 /log2/log_1_102.arc
103 /log1/log_1_103.arc
103 /log2/log_1_103.arc
104 /log1/log_1_104.arc
104 /log2/log_1_104.arc
You accidentally delete logs 102 and 104 from log 1.101 /log1/log_1_101.arc
101 /log2/log_1_101.arc
102 /log1/log_1_102.arc
102 /log2/log_1_102.arc
103 /log1/log_1_103.arc
103 /log2/log_1_103.arc
104 /log1/log_1_104.arc
104 /log2/log_1_104.arc
You run this command:
BACKUP ARCHIVELOG FROM SEQUENCE 101 UNTIL SEQUENCE 105; What happens?
5.
You have just run this syntax to start the listener from the Listener Control utility:
What is the name of the Listener you started?
LSNRCTL>START
Starting /mstgelai/oracle/bin/tnslsnr: please wait...
System parameter file is /u01/oracle/network/admin/listener.ora Log messages written to /u01/oracle/network/
log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stc-sun01- server)
(PORT=1521)))
Connecting to...
The command completed successfullyStarting /mstgelai/oracle/bin/tnslsnr: please wait...
System parameter file is /u01/oracle/network/admin/listener.ora Log messages written to /u01/oracle/network/
log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stc-sun01- server)
(PORT=1521)))
Connecting to...
What is the name of the Listener you started?
6.
What is true about version-enabled tables?
7.
What is true regarding a transaction executed in Automatic Undo Management mode?
8.
What should you look at first to compute the number of undo blocks written per second to disk?
9.
The EMPLOYEES table is stored in the SAMPLE tablespace. The corresponding IPK_EMP index for the
EMPLOYEES table's primary key is stored in the INDX tablespace.
Out of 12 partitions, only partition P1 of the SALES table is stored in the SAMPLE tablespace. Which object will
be exported by this command? exp system/manager tablespaces=SAMPLE
EMPLOYEES table's primary key is stored in the INDX tablespace.
Out of 12 partitions, only partition P1 of the SALES table is stored in the SAMPLE tablespace. Which object will
be exported by this command? exp system/manager tablespaces=SAMPLE
10.
You want to drop the TBS1 tablespace from your database. You also want to delete the corresponding data
files automatically, and not have to do it manually. What should you do?
files automatically, and not have to do it manually. What should you do?