Home » Other » Training & Certification » INTERVIEW QUESTION
INTERVIEW QUESTION [message #170478] Thu, 04 May 2006 00:19 Go to next message
Messages: 54
Registered: September 2005
these are the interview question i got can any one plz give me the answer.
1).In what script is “snap$” created? In what script is
the “scott/tiger” schema created?

2)How does Oracle guarantee data integrity of data changes?

3)How would you go about verifying the network name that the local_listener is currently using?

4)You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

5)What is the recommended interval at which to run statspack snapshots, and why?

6)An automatic job running via DBMS_JOB has failed. Knowing only that “it’s failed”, how do you approach troubleshooting this issue?

with regaards

Re: INTERVIEW QUESTION [message #170561 is a reply to message #170478] Thu, 04 May 2006 06:29 Go to previous messageGo to next message
Messages: 826
Registered: December 2005
Senior Member
regarding second question, data integrity is guranteed via the mechanism, that all sessions see only commited data..if there is any uncommited data, then only that session who has started that transaction will see it..how other sessions see commited data , whereas this one sees its uncommited data- via undo ..the previous image of the block is there in the undo, and that is read by all other sessions.

Re: INTERVIEW QUESTION [message #171313 is a reply to message #170478] Tue, 09 May 2006 06:57 Go to previous message
Messages: 1
Registered: May 2006
Junior Member
Reg. 1...Oracle has phased out Scott user in favor of sample schemas.
The script to create scott sample schema is utlsampl.sql located in ORACLE_HOME/rdmbs/admin
Previous Topic: which OCP developer path is better..
Goto Forum:

Current Time: Sat Jun 12 18:37:55 CDT 2021