DB Administration interview questions – page 15

Difference between Hashfile and Sequential File?

What are other Performance tunings you have done in your last project to increase the performance of slowly running jobs?

What is hashing algorithm and explain breafly how it works?

How can we pass parameters to job by using file.

What are the most important aspects that a beginner must consider doin his first DS project ?

How do we do the automation of dsjobs?

How can we create Containers?

How do we drill through from a powerplay cube to reportnet?

How I can convert Server Jobs into Parallel Jobs?

Does Enterprise Edition only add the parallel processing for better performance? Are any stages/transformations available in the enterprise edition only?

What is the mean of Try to have the constraints in the 'Selection' criteria of the jobs itself. This will eliminate the unnecessary records even getting in before joins are made?

What is difference b/w model&package?

What is the difference between datawarehouse and BI?

Did you Parameterize the job or hard-coded the values in the jobs?

What are the advantages of query studio compared to report studio

What is SQL tuning? how do you do it ?

If data is partitioned in your job on key 1 and then you aggregate on key 2, what issues could arise?

What is a look up table?

What are cubes?

How do you connect EME to Abinitio Server?

Explain time series algorithm in data mining?

What is the difference between 9i and 10g?

What is data file & descriptor file in dataset stage ? Plese expain briefly

Definitions of decision tree on the Web:

Is it possible we can define the path of control file backup by creating a text tarce file default where this is store ?

What is environment variables?what is the use of this?

Why we use g with 10g .

What is steps of cloning?

What are the similarities between ROLAP and MOLAP?

What is the meaning for data base without using technical terms?