DB Administration interview questions

What are the different modes of mounting a Database with the Parallel Server ?

What are the steps involved in Database Startup ?

What is Full Backup ?

Can Full Backup be performed when the database is open ?

What is the steps for recovery of missing data file? and the steps for physical stand by database creation?

What is Mirrored on-line Redo Log ?

What is On-line Redo Log?

What is the steps for recovery with missing online redo logs?

What is Partial Backup ?

What are the steps involved in Database Shutdown ?

What is the difference between hot backup n rman backup?

What is the diff between abinitiorc and .abinitiorc files ?

Diff.between Output index and Output indexes?

What is OLAP?

How can you run a graph continuously without usingcontinuous components ?

What are the sections that we have in Crystal reports?

Can we export data of reports into other format like inworld doc etc?

Is there any feature like summing total in crystal report?

Does Crystal Report support all the functions that we havein Oracle?

Broadcast and replicate does the similar work , what's thediff then

What is OLAP grid? Where it is used?

How can we know the time taken for particular report execution?

Can we create report using more than one database?

How do u reduce warnings

Why do you use stored procedures and what is their main functionality in a RDBMS?

What is data consititency

What is diff b/w Abstraction and Encapsulation?

How do we connect to the database?

What is subreport? In one report maximum how many subreportwe can insert?

How does database implement concurrency and consistency in both distributed and local settings.