Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle DBA (Database Administration)
  2. Suggest New Category
Oracle DBA (Database Administration) Interview Questions
Questions Answers Views Company eMail

What operator tests column for the absence of data?

 599

System tablespace cant be exported from one database and imported into another why?

 555

Explain the wait events in statspack report 'db sequential real'?

 636

Explain the wait events in statspack report 'db scattered read'?

 581

What is your favorite tool for day-to-day oracle operation?

 548

What is the difference between truncate and delete? How would a full table scan behave after?

 552

What is difference between co-related sub query and nested sub query?

 567

What is oracle full backup?

 570

What is pga_aggregate_target?

 571

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.

 603

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

 627

If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?

 566

Tell me about standby database? What should we watch out for?

 547

What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?

 617

Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

 659

Post New Oracle DBA (Database Administration) Questions

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

What is tkprof and how is it used?

608

How long does it take to learn database administration?

557

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

610

What are the main functions of dba?

580

What do you understand by recovery catalog?

568

How can I learn oracle dba?

563

What are types of data model?

551

How do you prevent output from coming to the screen?

528

What is main function of database administrator?

571

What is the difference between sga and pga?

618

How do you put database is archivelog mode, explain procedure?

549

How can you find all the processes on your system?

570

What are the functions of administration?

555

Does dba need to know programming?

568

What are the main benefits of using spfile over pfile?

641

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