Define the SGA and:
How you would configure SGA for a mid-sized OLTP environment?
What is involved in tuning the SGA?
I have kept recovery catalog on same target database and
taken backup of target DB to disk. deleted the target DB &
tried to restore and revoer DB using the backup on disk
but it is not possible, how do we restore & recover DB
How to bind a cobol module to a given job?
I am not able to understand this concept.Can anyone help me
out as how to carry out this task?
Which dictionary view(s) would you first look at to
understand or get a high-level idea of a given Advanced
. I have my backup RMAN script called "backup_rman.sh". I am
on the target database. My catalog username/password is
My catalog db is called rman. How would you run this shell
from the o/s such that it would run as a background process?
You have found corruption in a tablespace that contains
static tables that are part of a database that is in
NOARCHIVE log mode. How would you restore the tablespace
without losing new data in the other tablespaces?
How would you extract DDL of a table without using a GUI tool?
You have 4 instances running on the same UNIX box. How can
you determine which shared memory and semaphores are
associated with which instance?
how do we explain a project in cognos in an interview?
please help me. Also how do we perform testing in cognos
after creating reports?
Provide an example of a shell script which logs into SQLPLUS
as SYS, determines the current date, changes the date format
to include minutes & seconds, issues a drop table command,
displays the date again, and finally exits.
Database crashes. Corruption is found scattered among the
file system neither of your doing nor of Oracle's. What
database recovery options are available? Database is in
archive log mode.
how can you connect from 10g user to 11g user??
what is the role of dip user in our database?
one datafile is lost in standy side how can you recover that??