DB Administration Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB Administration Interview Questions

Questions Answers Views Company eMail

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

2 7017

Explain an ORA-01555

2 6710

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 18580

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

2 10714

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 8947

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

1 4547

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2283

Explain the use of table functions.

1 5483

Name three advisory statistics you can collect.

1 5507

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

1 8412

Explain materialized views and how they are used.

2399

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

1 9590

What background process refreshes materialized views?

Accenture, FLSmidth,

2 12432

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

2 8627

Describe what redo logs are.

1 4992

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2375

How to start SQL Server in minimal configuration mode?

7835

what functionality does oracle provide to secure sensitive information?

953

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4392

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2409

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1948

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1923

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1065

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2579

What the different topologies in which replication can be configured? : sql server DBA

1190

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

2451

how can you initialize log miner?

1089

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

2796

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2384

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1874

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