What is the relation between database and instance?
No Answer is Posted For this Question
Be the First to Post Answer
What do you understand by recovery catalog?
What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
What is the purpose of the import option ignore? What is its default setting?
What are the five main functions of a database administrator?
How can you find out how many users are currently logged into the database? How can you find their operating system id?
You see multiple extents in the temporary tablespace. Is this a problem?
What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?
What kinds of responsibilities does a dba have in a database environment?
System tablespace cant be exported from one database and imported into another why?
When using oracle export/import what character set concerns might come up? How do you handle them?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?