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 relation between database and instance?

597

What is the difference between sga and pga?

567

What do you mean by oracle database?

538

What are the important tasks of common oracle dba?

520

What is the difference between a database and instance? What is the relation between them?

541

What are the possible ways to gain information regarding the control file?

515

What is the difference between cold backup and hot backup?

550

What are the various ingredients of sga?

528

What do you understand by the oracle?

515

Explain the term 'oracle grid architecture'?

546

What are the different types of backup available in the oracle?

546

What are the main benefits of using spfile over pfile?

594

What do you understand by the term 'normalization'? Explain the various modes of normalization?

520

What are the different responsibilities of a dba?

658

Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?

514

Post New Oracle DBA (Database Administration) Questions

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

What do you understand by the term 'normalization'?

633

What are elements of administration?

544

What are database skills?

544

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

517

What is main function of database administrator?

525

What does a senior database administrator do?

557

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

523

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

546

What do you understand by a control file?

519

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

538

What is the full form of dba?

557

You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?

572

What is the main function of database?

560

Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

546

What is dba in sound level?

542

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