Oracle DBA (Database Administration) Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle DBA (Database Administration) Interview Questions

Questions Answers Views Company eMail

What is the finger command?

613

What does >> do?

624

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

627

How can you find all the processes on your system?

605

What happens when the default and temp tablespace clauses are left out from create user statements?

607

What is pct free/pct used/pct increase parameter in segment? What is growth factor?

594

When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?

635

What is pct free/pct used/pct increase parameter in segment?

606

What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?

628

How can you find out how many users are currently logged into the database? How can you find their operating system id?

576

What happens if a tablespace clause is left off of a primary key constraint clause?

609

Discuss row chaining, how does it happen?

610

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

631

How can you find dead processes?

572

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

631

Post New Oracle DBA (Database Administration) Questions

Un-Answered Questions { Oracle DBA (Database Administration) }

When should the default values for oracle initialization parameters be used as is?

711

How many control files should you have? Where should they be located?

611

What is the difference between internal & external schema?

794

What do you understand by recovery catalog?

591

What is dba training?

594

I have applied the following commands: now what will happen, will the database will give an error / it will work?

594

What do you understand by the term 'normalization'?

710

How do I become a database administrator?

608

How do you use automatic pga memory management with oracle 9i and above?

622

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

605

What is dba and functionalities of dba?

636

How can you find out how many users are currently logged into the database? How can you find their operating system id?

576

What are the main functions of dba?

611

What is the difference between cold backup and hot backup?

616

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

596

For More Un-Answered { Oracle DBA (Database Administration) } Questions Click Here