How can you find your id on a system?
No Answer is Posted For this Question
Be the First to Post Answer
What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
What degree do database administrators need?
How does one create a new database?
What are the possible ways to gain information regarding the control file?
How do you set up your tablespace on installation level: low?
Tell me about standby database? What should we watch out for?
What does the no logging option do? Why would we use it? Why would we be careful of using it?
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 the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
What do you understand by a control file?
What is the use of the drop option in the alter table command?