Oracle DBA (Database Administration) Interview Questions
Questions Answers Views Company eMail

Which dba certification is best?

401

What do you mean by dba?

400

How many types of dba are there?

387

What is oracle dba role?

400

What is a dba why is this position necessary?

385

What is dba training?

380

How much money does a dba make?

410

What is dba and functionalities of dba?

409

Is oracle dba in demand?

416

What should a dba know?

374

What kinds of responsibilities does a dba have in a database environment?

422

How can I learn oracle dba?

383

What exactly does a dba do?

412

What is a dba certification?

395

What is dba in sound level?

383


Post New Oracle DBA (Database Administration) Questions

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

How can you tell if a tablespace has excessive fragmentation?

421


What is explain plan and how is it used?

415


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

396


What operator tests column for the absence of data?

412


How does one create a new database?

421


What does >> do?

414


A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

446


If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

432


What happens if the constraint name is left out of a constraint clause?

383


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

397


What are the roles and responsibilities of oracle dba?

457


How do you prevent output from coming to the screen?

363


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

425


What is the difference between internal & external schema?

472


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

391