×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
An index-organized table (IOT) called SPARSE has had many records deleted. Which command reorganizes
the IOT so that the empty space is removed, while minimizing the impact for users?
the IOT so that the empty space is removed, while minimizing the impact for users?
2.
Data file DF1 belongs to tablespace TS1.,and the database is in ARCHIVELOG mode.
You did an incomplete recover in the following steps:
You did an incomplete recover in the following steps:
1. Take data file DF1 offline.
2. Copy a backup copy of DF1 into the current DF1 location.
3. Execute RECOVER DATAFILE UNTIL TIME sometime in the past.
4. Bring DF1 online.
5. Execute ALTER DATABASE OPEN RESETLOGS.
To guarantee that the database is recoverable in the future, what is the least amount of work needed?
2. Copy a backup copy of DF1 into the current DF1 location.
3. Execute RECOVER DATAFILE UNTIL TIME sometime in the past.
4. Bring DF1 online.
5. Execute ALTER DATABASE OPEN RESETLOGS.
3.
What is true about this statement used during import?
imp hr/hr tables= (employee, departments) file=hr.dmp ignore=y
4.
You need to recover five data files that are spread across multiple disks. Which initialization parameter should
you set to speed up redo application?
you set to speed up redo application?
5.
You are ready to implement RMAN in the backup and recover strategy for your company. Which system
privilege must the RMAN user have to be able to connect and execute RMAN commands on a target
database?
privilege must the RMAN user have to be able to connect and execute RMAN commands on a target
database?
6.
Examine this syntax which allocates channels during a parallel image copy:
RMAN> CONFIGURE DEVICE TYPE disk parallelism 4:
2> COPY
3> datafile 1 TO '/BACKUP/datafile1.dbf',
4> datafile 2 TO '/BACKUP/datafile2.dbf',
5> datafile 3 TO '/BACKUP/datafile3.dbf;
RMAN>COPY
2> datafile 4 TO '/BACKUP/datafile4.dbf';
How many channels are used?
RMAN> CONFIGURE DEVICE TYPE disk parallelism 4:
2> COPY
3> datafile 1 TO '/BACKUP/datafile1.dbf',
4> datafile 2 TO '/BACKUP/datafile2.dbf',
5> datafile 3 TO '/BACKUP/datafile3.dbf;
RMAN>COPY
2> datafile 4 TO '/BACKUP/datafile4.dbf';
How many channels are used?
7.
Users complain SQL statements using a particular index fail. Using DBVERIFY, you find that two separate
blocks in the index have become corrupt. The database data files for user data and index are very large.
What is the least disruptive recover strategy available in Oracle9i?
blocks in the index have become corrupt. The database data files for user data and index are very large.
What is the least disruptive recover strategy available in Oracle9i?
8.
Which is a restriction on a list partitioned table?
9.
If you create your database using Oracle Managed Files (OMF), what is true?
10.
In the Oracle9i Data Guard architecture, what is the purpose of the Log Transport Services?