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

How do you switch from an init.ora file to a spfile?

TCS,

4 18225

Explain the difference between a data block, an extent and a segment.

 2 9730

Give two examples of how you might determine the structure of the table DEPT.

 2 10480

Where would you look for errors from the database engine?

IBM,

2343

Compare and contrast TRUNCATE and DELETE for a table.

 7 13658

Give the reasoning behind using an index.

 2 7641

Give the two types of tables involved in producing a star schema and the type of data theyhold.

 2 6609

What type of index should you use on a fact table?

 1 3257

Give two examples of referential integrity constraints.

 2 7554

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?

 1989

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

 5 22359

What command would you use to create a backup control file?

 2 4205

Give the stages of instance startup to a usable state where normal users may access it.

 1 2681

What column differentiates the V$ views to the GV$ views and how?

 3 9035

How would you go about generating an EXPLAIN plan?

 2 7030

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

what are the differences of where and if in SAS?

1656

What are the different types of upgrades that can be performed in sql server? : sql server DBA

674

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

1674

suppose you want to audit specific activities on sensitive data. How can you achieve that?

534

. 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?

1972




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

2040

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

1857

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

1411

What is the difference between clustered and non-clustered index? : sql server DBA

536

what is the role of dip user in our database?

2037

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

2411

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

1972

What is dbcc? : sql server DBA

771

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

2961

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3298

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