What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
No Answer is Posted For this Question
Be the First to Post Answer
What does dba stand for database?
Give one method for transferring a table from one schema to another?
What is the difference between rman and a traditional hotbackup?
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?
What happens if the constraint name is left out of a constraint clause?
What is the advantage of using rman?
What are the possible ways to gain information regarding the control file?
What does the no logging option do? Why would we be careful of using it?
What is a junior dba?
A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?
What is the most common database language that a db administrator needs to know?