When configuring sqlnet on the client what files need to be set up?
What is the dba role in oracle?
What are the steps involved in instance recovery in oracle?
How many control files should you have? Where should they be located?
If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?
What database block size should I use?
Discuss row chaining, how does it happen? How do you correct it?
How can you tell if an index on particular table is used or not used in 9i?
How can you determine if an oracle instance is up from the operating system level?
What is a junior dba?
If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
Why are recursive relationships bad? How do you resolve them?
How does one create a new database?
What do you understand by a control file?
Tell me about standby database? What should we watch out for?