DB Administration interview questions – page 7

What is clusters ?

Can we decrease the Datafile size?

What is the difference between Data Warehouse and Online Analytical Processing

What is an index and How it is implemented in Oracle database

What is the Difference b/w Microstrategy and cognos Reporting Tool

What is a dimension table?

Job type can't runnable in this plot form and view data server command error. to running the jobs this error can be displayed.

State some of the uses of OpenEdge architect features useful for a Developer?

What is Object Oriented model?

Explain about Mobile enterprise application enablement?

Explain the features of Openedge features?

How to improve the performance of hash file?

It is possible to access the same job two users at a time in datastage?

What happens when Update command is used without where clause?

What is cliques? What is Vdisk and how it will communicate with physical data storage at the time of data retrieval through AMP ?

What are two examples of an OLTP environment?

How do you sort a table?

Explanation about replication server software?

What is data validation strategies for data mart validation after loading process

What are slowly changing dimensions?

What is an Oracle sequence

What are the basic element of base configuration of an Oracle database

Which two can be implemented as a centrally located logical architecture?

Which two statements are true about a foreign key?

What is the difference between sequential file and a dataset? When to use the copy stage?

What is an Oracle index

What is Smart Metric?

How are the index updates

1* what is the diffrance betwin DNS DHCP ? file system of windows? compare with nis & dns

What is a private synonym