Which dictionary view(s) would you first look at to
understand or get a high-level idea of a given Advanced
Replication environment?
1
Explain materialized views and how they are used.
132
What's the benefit of "dbms_stats" over "analyze"?
30
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
Can you tell me about your experience with the
administration of COTS system..? Also, how do you set up
seed data..?
144
Give the stages of instance startup to a usable state where
normal users may access it.
184
How would you edit your CRONTAB to schedule the running of
/test/test.sh to run every other day at 2PM?
2
How to start SQL Server in minimal configuration mode?
349
What is database replicaion? What are the different types
of replication you can set up in SQL Server?
137
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
An automatic job running via DBMS_JOB has failed. Knowing
only that "it's failed", how do you approach troubleshooting
this issue?
2
How do you tell what your machine name is and what is its IP
address?
1
currently iam working in mnc as a oracleappsdba,please send
the EXPERIENCE RESUME those who r worked as a oracle apps
dba
134
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
What command would you use to encrypt a PL/SQL application?
216
Where in the Oracle directory tree structure are audit
traces placed?
159
What query tells you how much space a tablespace named
"test" is taking up, and how much space is remaining?
along with your userid / name. ThanQ
Site Map
