DB Administration interview questions – page 2

In one subreport how many subreport we can insert?

What is the significance of ?mp run? command ?

Can we use stored procedure for creating the report?

Are there any limitations in crystal reports?

How can one find a cycle in the linked list? IF found how to recognize the cycle and delete that cycle?

How do we format field?

How many types of subreport are there?

Can we stop the database null values? How?

What is the section expert? Why we use it?

Is snow flake or star schema used? If star schema means why?

How can we change the Hierarchi of group? and for parameteralso?

Can we use our own SQL for creating a report?

What is Join Index in TD and How it works?

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANYPRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THATPRIVILIZES.

What are ntfs, fat32 and ext3

What is fulltextsearch

How many different types of reports we can create in Crystalreports?

Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

Different indexes in database

Difference between ODS and Staging

What is meant by roll up and roll back in dataware housing?

What is caching? What are the different types of caching?

How you can test a dbc file ?

Hyperion is the one of the tool in data ware house.its an olap tool.y u cant display that tool?

What are the features of Clipper VO?

How is file locking handled in Clipper?

Advantages of DBMS?

How Do I Make Remarks In My Code?

What are the different types of data warehousing?

Define pre-emptive and non-pre-emptive.