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 5951

Explain an ORA-01555

 2 5871

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

 3 17336

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

 2 9604

Explain the use of setting GLOBAL_NAMES equal to TRUE.

 1 8317

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

 1 3884

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

 1844

Explain the use of table functions.

 1 4873

Name three advisory statistics you can collect.

 1 4827

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

 1 7785

Explain materialized views and how they are used.

 1894

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

 1 8965

What background process refreshes materialized views?

Accenture, FLSmidth,

2 11402

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

 2 7760

Describe what redo logs are.

 1 4328

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1844

What are the steps you will take to improve performance of a poor performing query?

2419

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

514

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1336

how can you connect from 10g user to 11g user??

1681




Query processing is slow(eg select query)how will u solve that

6515

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2389

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

1998

How would you extract DDL of a table without using a GUI tool?

2048

What is a system database and what is a user database? : sql server DBA

599

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

601

what is ora 24313?what is the procedure to exclude that error?

2100

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

548

which background process invoke at the time of upgradation tell me???

2224

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

1520

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