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?
Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
172
What would you do with an "in-doubt" distributed transaction?
4
You're getting high "busy buffer waits" - how can you find
what's causing it?
6
How do you recover a datafile that has not been physically
been backed up since its creation and has been deleted.
Provide syntax example.
35
I got an error SQL1042C. An unexpected system error
occurred.
Explanation:
A system error occurred. One possible reason for this error
is that the database manager is not installed correctly or
the environment is not set up correctly.
On OS/2, while trying to start the database manager, a very
common reason for this error is a corrupted NET.ACC file.
The command cannot be processed.
The tables and views would not be opened. What is the way
to open the dataase?
pls help me
365
What would you use to improve performance on an insert
statement that places millions of rows into that table?
3
What do the 9i dbms_standard.sql_txt() and
dbms_standard.sql_text() procedures do?
4
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
What are statistics, under what circumstances they go out
of date, how do you update them?
168
what is the last version,the release date of that version
and fix pack of ibm db2 udb?
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..........
799
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
24
An automatic job running via DBMS_JOB has failed. Knowing
only that "it's failed", how do you approach troubleshooting
this issue?
1
Where in the Oracle directory tree structure are audit
traces placed?
156
If CPU is very slow What can u do to speed up?
5
How does Oracle guarantee data integrity of data changes?
2
Explain the use of table functions.
131
What is database replicaion? What are the different types
of replication you can set up in SQL Server?
135
Can you tell me about your experience with the
administration of COTS system..? Also, how do you set up
seed data..?