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.
Database crashes. Corruption is found scattered among the
file system neither of your doing nor of Oracle's. What
database recovery options are available? Database is in
archive log mode.
How would you begin to troubleshoot an ORA-3113 error?
5
As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?
143
Explain materialized views and how they are used.
132
Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
177
How do you tell what your machine name is and what is its IP
address?
1
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
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
What would you use to improve performance on an insert
statement that places millions of rows into that table?
6
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.
274
How would you go about verifying the network name that the
local_listener is currently using?
2
Describe what redo logs are.
120
Define the SGA and:
How you would configure SGA for a mid-sized OLTP environment?
What is involved in tuning the SGA?
5
Typically, where is the conventional directory structure
chosen for Oracle binaries to reside?
16
What view(s) do you use to associate a user's SQLPLUS
session with his o/s process?
1
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
A table is classified as a parent table and you want to drop
and re-create it. How would you do this without affecting
the children tables?
132
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?
12
Give the stages of instance startup to a usable state where
normal users may access it.
184
What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
2
Where would you look for errors from the database engine?
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
