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.
29
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?
20
How would you best determine why your MVIEW couldn't FAST
REFRESH?
4
if monday take full backup and tuesday it was cumulative
backup and wednesday we taken incremental backup, thursday
some disaster happen then what type of recovery and how it
will take?
4
What's the benefit of "dbms_stats" over "analyze"?
30
As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?
143
what is the last version,the release date of that version
and fix pack of ibm db2 udb?
160
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
379
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
If CPU is very slow What can u do to speed up?
6
What do the 9i dbms_standard.sql_txt() and
dbms_standard.sql_text() procedures do?
5
Oracle client is not able to connect to Oracle server
although tnsnames.ora file has
valid enteries. Oracle error message is “ cannot resolve
net service name”.
Mention any three reasons.
271
How do you tell what your machine name is and what is its IP
address?
1
what are the differences of where and if in SAS?
179
How would you configure your networking files to connect to
a database by the name of DSS which resides in domain
icallinc.com?
12
What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
2
How do you increase the OS limitation for open files (LINUX
and/or Solaris)?
4
Explain how you would restore a database using RMAN to Point
in Time?
6
Which dictionary view(s) would you first look at to
understand or get a high-level idea of a given Advanced
Replication environment?
1
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?
To Refer this Site to Your Friends 
Site Map
