What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
3
currently iam working in mnc as a oracleappsdba,please send
the EXPERIENCE RESUME those who r worked as a oracle apps
dba
135
What's the benefit of "dbms_stats" over "analyze"?
31
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.
2
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.
5
Which dictionary tables and/or views would you look at to
diagnose a locking issue?
5
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
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?
14
Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
177
In which dictionary table or view would you look to
determine at which time a snapshot or MVIEW last
successfully refreshed?
3
Where in the Oracle directory tree structure are audit
traces placed?
159
I want to export only structure of the table from oracle
database. In that table to used the some partition.
To export the table in general way then compilation error
was occured i.e-EXP-00003: no storage definition found for
segment(11, 2771). Please tell me the correct export command
parameter to export the partitioned table.
Thanks in Advance..........
834
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.
5
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
. I have my backup RMAN script called "backup_rman.sh". I am
on the target database. My catalog username/password is
rman/rman.
My catalog db is called rman. How would you run this shell
script
from the o/s such that it would run as a background process?
305
Other than making use of the statspack utility, what would
you check when you are monitoring or running a health check
on an Oracle 8i or 9i database?
5
How does Oracle guarantee data integrity of data changes?
5
How would you begin to troubleshoot an ORA-3113 error?
6
What query tells you how much space a tablespace named
"test" is taking up, and how much space is remaining?
4
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?
Site Map
