| INTERVIEW QUESTION [message #170478] |
Thu, 04 May 2006 00:19  |
oradba16
Messages: 54
Registered: September 2005
|
Member |
|
|
Hi,
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
boo
|
|
|
|
| Re: INTERVIEW QUESTION [message #170561 is a reply to message #170478] |
Thu, 04 May 2006 06:29  |
orausern
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 |
vgg4u
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
