What is the difference between a database and instance?
No Answer is Posted For this Question
Be the First to Post Answer
Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
When configuring sqlnet on the client what files need to be set up?
When using oracle export/import what character set concerns might come up? How do you handle them?
How many redo logs should you have and how should they be configured for maximum recoverability?
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 are roles in oracle?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
Discuss row chaining, how does it happen?
What database block size should I use?
What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
What are the types of schemas?
You see multiple fragments in the system tablespace, what should you check first?