1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category
DB Administration Interview Questions
Questions Answers Views Company eMail

How would you go about increasing the buffer cache hit ratio?

 2 5979

Explain an ORA-01555

 2 5887

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

 3 17356

How would you determine the time zone under which a database was operating?

 2 9615

Explain the use of setting GLOBAL_NAMES equal to TRUE.

 1 8327

What command would you use to encrypt a PL/SQL application?

 1 3896

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

 1848

Explain the use of table functions.

 1 4881

Name three advisory statistics you can collect.

 1 4836

Where in the Oracle directory tree structure are audit traces placed?

 1 7797

Explain materialized views and how they are used.

 1898

When a user process fails, what background process cleans up after it?

 1 8977

What background process refreshes materialized views?

Accenture, FLSmidth,

2 11417

How would you determine what sessions are connected and what resources they are waiting for?

 2 7776

Describe what redo logs are.

 1 4337

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

559

what are the performance views in an oracle rac environment?

563

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1526

What would you do with an "in-doubt" distributed transaction?

1421

What is the default port no on which sql server listens? : sql server DBA

566




what are the differences of where and if in SAS?

1666

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

565

how can you generate profile of pl/sql applications to identify performance bottlenecks?

603

Explain about your sql server dba experience? : sql server DBA

551

Which autogrowth database setting is good? : sql server DBA

581

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

662

What is the importance of a recovery model? : sql server DBA

557

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1848

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1239

How do you open a cluster administrator? : sql server DBA

581

For More Un-Answered { DB Administration } Questions Click Here