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...

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

What operator tests column for the absence of data?

600

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

560

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

641

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

583

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?

556

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

571

What is oracle full backup?

574

What is pga_aggregate_target?

574

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.

605

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?

567

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

552

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

631

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

665


Post New Oracle DBA (Database Administration) Questions

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

What is the finger command?

592


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

564


What is the purpose of the grep command?

2147


How can you find your id on a system?

568


How can you find out how many users are currently logged into the database?

606


What is oracle full backup?

574


How can you determine the number of sqlnet users logged in to the unix system?

575


Are database administrators in demand?

572


How do you prevent output from coming to the screen?

529


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

548


List five most important parameter in 9i affecting performance?

571


What does >> do?

592


What is dump destination? What are bdump, cdump and udump?

569


Who is a database user?

549


How do you set up tablespaces during an oracle installation?

610