Sign Up Login


  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 18978

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

 2 10200

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

 2 10971

Where would you look for errors from the database engine?

IBM,

2588

Compare and contrast TRUNCATE and DELETE for a table.

 7 14523

Give the reasoning behind using an index.

 2 8102

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

 2 7096

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

 1 3570

Give two examples of referential integrity constraints.

 2 7986

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?

 2217

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

 5 23316

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

 2 4676

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

 1 3055

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

 3 9677

How would you go about generating an EXPLAIN plan?

 2 7472

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What are statistics, under what circumstances they go out of date, how do you update them?

2003

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

2197

who owns the operating system files created by the utl_file package?

815

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2180

Why does Oracle not permit the use of PCTUSED with indexes?

2583

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

1777

What are the different types of indexes available in sql server? : sql server DBA

815

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

1650

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

793

What are the recovery models for a database? : sql server DBA

814

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2188

What purpose does the model database server? : sql server DBA

830

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

779

how can you process messages in order asynchronously?

744

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

906

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