DB Administration interview questions – page 17

How we determine index require rebuilding ?

Why we use SQL server with VB6 programming instead SQl Server with Access ?

What is ETL?

What is the approximate size of a data warehouse?

If i have primary key this is possible to create another primary key on table.

What is undo /rollback segment how you resize this ?

What are measures?

In Dimensional modeling fact table is normalized or denormalized?in case of star schema and incase of snow flake schema?

How sga use if i execute select * from emp where empid=111;

Which files of unix or linux use or configure in oracle installation ?

Definitions of public key certificate?

What is junk dimension? What are junk dimension and degenerated dimension?

Where is trace file generate & when this is create .

User say your database is slow how you solve this how identified reasons ?

What is the use of bridge table. Can give a simple example?

What is primary & unique key which type index oracle create when we make those key ?

Definitions of software agent?

How grid work. is it possible grid in 9i. how ?

What is data mart?

Definitions of electronic data exchange?

How many ways U can update a relational source definition and what r they?

Which one is the better partition to stages for performance in Enterprise edition?

What is a CUBE in data warehousing concept?

What is dblink and how use it ?

If i have unique key this is possible to create another unique key on table .

What is the difference between Native SQL and Cognos SQL?

How you can determine query use full table scan?

How do you load the time dimension?

Define Meta data, Master data and Transaction data.

How data store in bitmap & btree index what is benefit ?