What command is used to type files to the screen?
How can you determine the number of sqlnet users logged in to the unix system?
What are the types of locks in database?
How do you install statspack?
What are the goals of dba?
How can you determine if an oracle instance is up from the operating system level?
How can you find out how many users are currently logged into the database?
What are elements of administration?
Discuss row chaining, how does it happen? How do you correct it?
What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
What are the main functions of dba?
How many redo logs should you have and how should they be configured for maximum recoverability?
What os user should be used for the first part of an oracle installation (on unix)?
You see multiple fragments in the system tablespace, what should you check first?
Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.