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.
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?
How can you tell how much space is left on a given file
system and how much space each of the file system's
subdirectories take-up?
4
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
381
Describe what redo logs are.
120
Explain the use of table functions.
136
Explain how you would restore a database using RMAN to Point
in Time?
6
How does propagation differ between Advanced Replication and
Snapshot Replication (read-only)?
3
What are the steps you will take to improve performance of
a poor performing query?
206
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.
4
Explain the concept of the DUAL table.
23
Database is hung. Old and new user connections alike hang on
impact. What do you do? Your SYS SQLPLUS session IS able to
connect.
4
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
What would you do with an "in-doubt" distributed transaction?
15
What's the benefit of "dbms_stats" over "analyze"?
30
What are the ways tablespaces can be managed and how do they
differ?
17
Typically, where is the conventional directory structure
chosen for Oracle binaries to reside?
14
How would you extract DDL of a table without using a GUI tool?
3
You have 4 instances running on the same UNIX box. How can
you determine which shared memory and semaphores are
associated with which instance?
4
Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
177
Where would you look for errors from the database engine?
along with your userid / name. ThanQ
Site Map
