Draft one mock email requesting your non-technical
management grant you downtime to (provide justification
where applicable) complete the following tasks:
(1) Generate statistics on a large table;
(2) Generate an RDA – if you don't know what an RDA is
please say so.
(3) Rename datafiles.
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?
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?
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?
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?
Typically, where is the conventional directory structure
chosen for Oracle binaries to reside?
13
What view(s) do you use to associate a user's SQLPLUS
session with his o/s process?
1
What is the recommended interval at which to run statspack
snapshots, and why?
2
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
how do we explain a project in cognos in an interview?
please help me. Also how do we perform testing in cognos
after creating reports?
Which environment variables are absolutely critical in order
to run the OUI?
3
What query tells you how much space a tablespace named
"test" is taking up, and how much space is remaining?
2
currently iam working in mnc as a oracleappsdba,please send
the EXPERIENCE RESUME those who r worked as a oracle apps
dba
134
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
Where in the Oracle directory tree structure are audit
traces placed?
159
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.
3
How would you best determine why your MVIEW couldn't FAST
REFRESH?
4
Draft one mock email requesting your non-technical
management grant you downtime to (provide justification
where applicable) complete the following tasks:
(1) Generate statistics on a large table;
(2) Generate an RDA – if you don't know what an RDA is
please say so.
(3) Rename datafiles.
28
Explain materialized views and how they are used.
132
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?
19
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
what are the differences of where and if in SAS?
179
How does Oracle guarantee data integrity of data changes?
5
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
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
Site Map
