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.
if monday take full backup and tuesday it was cumulative
backup and wednesday we taken incremental backup, thursday
some disaster happen then what type of recovery and how it
will take?
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
Does any body has ORACLE Certification Dumps or Materials
on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i
to 10g DBA Upgrade, Oracle 11i if any body have it, please
kindly drop an email to: taruni_2k8@yahoo.com
hi, how can i check all backups are exist to restore? I.e.
i forget to take backup on one day. But now i want to check
that all backups are there to restore now. I know the
answer of through timestamps we know how to check. But i
need any other way?
What is the cache hit ratio, what impact does it have on
performance of an Oracle database and what is involved in
tuning it?
9
What is database replicaion? What are the different types
of replication you can set up in SQL Server?
137
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?
20
As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?
143
What are the steps you will take to improve performance of
a poor performing query?
206
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?
11
What would you do with an "in-doubt" distributed transaction?
14
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
27
A table is classified as a parent table and you want to drop
and re-create it. How would you do this without affecting
the children tables?
132
Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
177
what is the last version,the release date of that version
and fix pack of ibm db2 udb?
160
Describe what redo logs are.
120
How would you begin to troubleshoot an ORA-3113 error?
5
In which dictionary table or view would you look to
determine at which time a snapshot or MVIEW last
successfully refreshed?
2
How would you configure your networking files to connect to
a database by the name of DSS which resides in domain
icallinc.com?
12
From the database level, how can you tell under which time
zone a database is operating?
20
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.
2
You have 4 instances running on the same UNIX box. How can
you determine which shared memory and semaphores are
associated with which instance?
4
How can you tell how much space is left on a given file
system and how much space each of the file system's
subdirectories take-up?
4
What are statistics, under what circumstances they go out
of date, how do you update them?
To Refer this Site to Your Friends 
Site Map
