Which SQL statement is used to return only different values?

How many columns are presented after executing this query: SELECT address1||','||address2||','||address2 "Address" FROM employee;

Datamart is a ?

Surrogate Key means

Select a feature that does not belong to Business Intelligence

Which of the following are configuration management tool ?

Can we change the Native Sql

RELATIONSHIPS INSERTED BETWEEN MEASURE DIMENSIONS AND REGULARDIMENSIONS WILL WORK.

Suppose i've a table emp and id is one of the column in it, what will be result for this query.select * from emp where id=99999 and 1=0;

for a 'CUBE' maximum number of Dimensions(including Measure Dimesions)

For Outer Join and Simple Join(inner Join) the Native SQL'll be Same

Can u implement 'Multi Measure' analysis in Report Studio with Cross tab.

Can u create Master-Detailed Reports for Cross-tabs.

'DELETE' command in SQL Will Remove the data as well as Structure

can u change the Governer Settings in Report Level.

'Report Validation' deals with the Data Present in Reoprt.

How can you load universe into the repository?

How can we test the universe & Report?

What are the user requirements in a universe?