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

DB Administration Interview Questions

Questions Answers Views Company eMail

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2627

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2105

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 4715

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

2375

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2659

How would you best determine why your MVIEW couldn't FAST REFRESH?

2305

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1992

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

1874

How would you begin to troubleshoot an ORA-3113 error?

1 4744

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 6201

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 5177

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

2450

You're getting high "busy buffer waits" - how can you find what's causing it?

1 5398

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 4428

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1997

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

how can you enable flashback feature?

900

Where do you find the default index fill factor and how to change it? : sql server DBA

1035

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

943

What the different components in replication and what is their use? : sql server DBA

1008

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2142

What is the difference between dropping a database and taking a database offline? : sql server DBA

1018

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

2375

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 purpose does the model database server? : sql server DBA

1109

What is dbcc? : sql server DBA

1228

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2283

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

7779

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

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

1036

Explain materialized views and how they are used.

2399

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