What is the difference between truncate and delete? Why is one faster?

588

What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?

518

How do I become a data manager?

472

What is the most common database language that a db administrator needs to know?

520

What are types of data model?

493

Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)

707

You see a wait on lms process in statspack, what does that mean?

513

What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?

512

How many dba can you have?

492

You see multiple extents in the temporary tablespace. Is this a problem?

541

What do you mean by oracle dba?

512

How can you determine if an oracle instance is up from the operating system level?

512

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?

538

I am getting error "no communication channel" after changing the domain name? What is the solution?

540

Who is dba in dbms?

511