An automatic job running via DBMS_JOB has failed. Knowing
only that "it's failed", how do you approach troubleshooting
this issue?
2
What would you use to improve performance on an insert
statement that places millions of rows into that table?
6
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 the differences of where and if in SAS?
179
How would you begin to troubleshoot an ORA-3113 error?
5
How would you edit your CRONTAB to schedule the running of
/test/test.sh to run every other day at 2PM?
2
What's the benefit of "dbms_stats" over "analyze"?
30
What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
2
Explain how you would restore a database using RMAN to Point
in Time?
6
what is the last version,the release date of that version
and fix pack of ibm db2 udb?
160
If you're unsure in which script a sys or system-owned
object is created, but you know it's in a script from a
specific directory, what UNIX command from that directory
structure can you run to find your answer?
13
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
currently iam working in mnc as a oracleappsdba,please send
the EXPERIENCE RESUME those who r worked as a oracle apps
dba
134
How would you extract DDL of a table without using a GUI tool?
3
Can you tell me about your experience with the
administration of COTS system..? Also, how do you set up
seed data..?
144
What would you do with an "in-doubt" distributed transaction?
15
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?
14
What spfile/init.ora file parameter exists to force the CBO
to make the execution path of a given statement use an
index, even if the index scan may appear to be calculated as
more costly?
2
Which dictionary view(s) would you first look at to
understand or get a high-level idea of a given Advanced
Replication environment?
Site Map
