Question 1

Which SQL statement is used to return only different values?

SELECT DIFFERENT
SELECT DISTINCT
SELECT UNIQUE
SELECT SEPARATE

Answer

Correct Option: B

Question 2

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

technology databases

1
2
3
4

Answer

Correct Option: A

Question 3

Datamart is a ?

technology databases

Data about data
Is a subset of a Dataware house
Data collected from various sources
All of the Above

Answer

Correct Option: B

Question 4

Surrogate Key means

technology databases

It is a primary key for a Dimension table.
It is a system generated sequence numbers
It is a unique key
It is a foreign key for a FACT table.

Answer

Correct Option: B

Question 5

Select a feature that does not belong to Business Intelligence

technology databases

Publishing report through a web portal.
Cleaning of Source data
Data Mining
Forecasting
Statistical Analysis

Answer

Correct Option: B

Question 6

Which of the following are configuration management tool ?

technology databases

Control-M
Autosys
Version manager
none of the above

Answer

Correct Option: C,D

Question 7

Can we change the Native Sql

technology databases

True
False

Answer

Correct Option: A

Question 8

RELATIONSHIPS INSERTED BETWEEN MEASURE DIMENSIONS AND REGULARDIMENSIONS WILL WORK.

technology databases

True
False

Answer

Correct Option: A

Question 9

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;

technology databases

it'll display the result of which id=99999
no rows selected
Error
garbage value...

Answer

Correct Option: B

Question 10

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

technology databases

128
136
64
32

Answer

Correct Option: C

Question 11

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

technology databases

True
False

Answer

Correct Option: A

Question 12

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

technology databases

True
False

Answer

Correct Option: A

Question 13

Lists and Cross tabs Must and Should have a Measure and dimensions to implement/run the report.

technology databases

True
False

Answer

Correct Option: A

Question 14

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

technology databases

True
False

Answer

Correct Option: A

Question 15

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

technology databases

True
False

Answer

Correct Option: A

Question 16

can u change the Governer Settings in Report Level.

technology databases

True
False

Answer

Correct Option: A

Question 17

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

technology databases

True
False

Answer

Correct Option: B

Question 18

How can you load universe into the repository?

technology databases

Exporting the universe
Extracting the Universe
Copying the Universe
Exporting and then Extracting Universe

Answer

Correct Option: D

Question 19

How can we test the universe & Report?

technology databases

integrity check
By coping report query and run in backend(oracle,sql server...)
Both a & b
Neither a nor b

Answer

Correct Option: C

Question 20

What are the user requirements in a universe?

technology databases

Database connections
key column
metrics
Dimension

Answer

Correct Option: A,B,C

Description: databases Online Quiz - 94
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 94

Find more quizzes from top tags