Assuming today is Monday, how would you use the DBMS_JOB
package to schedule the execution of a given procedure owned
by SCOTT to start Wednesday at 9AM and to run subsequently
every other day at 2AM.
Which dictionary view(s) would you first look at to
understand or get a high-level idea of a given Advanced
In oracle 10g export, import if we declare rows=y/n what would
be the output?
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
In which dictionary table or view would you look to
determine at which time a snapshot or MVIEW last
How would you best determine why your MVIEW couldn't FAST
You create a private database link <link name> and upon
connection, fails with: ORA-2085: <Link name> connects to
<fully qualified remote db name>. What is the problem? How
would you go about resolving this error?
What would you do with an "in-doubt" distributed transaction?
when we login sql editor using username and password then it
says this error "could not resolve service name" then what
can we do at client side.( here thing is tnsnames.ora file
is ok till yesterday and worked well, but now it giving error.
Define the SGA and:
How you would configure SGA for a mid-sized OLTP environment?
What is involved in tuning the SGA?
Can you tell me about your experience with the
administration of COTS system..? Also, how do you set up
Typically, where is the conventional directory structure
chosen for Oracle binaries to reside?
Query processing is slow(eg select query)how will u solve that