databases Online Quiz - 94
Description: databases Online Quiz - 94 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
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.
Lists and Cross tabs Must and Should have a Measure and dimensions to implement/run the report.
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?