0

databases Online Quiz - 94

Description: databases Online Quiz - 94
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Which SQL statement is used to return only different values?

  1. SELECT DIFFERENT

  2. SELECT DISTINCT

  3. SELECT UNIQUE

  4. SELECT SEPARATE


Correct Option: B

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

  1. 1

  2. 2

  3. 3

  4. 4


Correct Option: A

AI Explanation

To answer this question, let's break down the query:

The query is selecting three columns: address1, address2, and address2. However, these columns are concatenated using the double pipe operator (||) and separated by commas.

So, after executing the query, the result will be a single column called "Address" that contains the concatenated values of address1, address2, and address2 (which seems to be a typo and should probably be address3).

Therefore, the correct answer is A) 1.

Datamart is a ?

  1. Data about data

  2. Is a subset of a Dataware house

  3. Data collected from various sources

  4. All of the Above


Correct Option: B

Surrogate Key means

  1. It is a primary key for a Dimension table.

  2. It is a system generated sequence numbers

  3. It is a unique key

  4. It is a foreign key for a FACT table.


Correct Option: B

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) It is a primary key for a Dimension table - This option is incorrect. A surrogate key is not specifically a primary key for a Dimension table. It can be used as a primary key, but it is not limited to that role.

Option B) It is a system-generated sequence number - This option is correct. A surrogate key is a unique identifier that is generated by the system, typically using a sequence number or an auto-incrementing value. It is used to uniquely identify records in a table and is not derived from any meaningful data.

Option C) It is a unique key - This option is partially correct. A surrogate key is indeed a unique key, but its uniqueness is achieved by being generated by the system rather than being inherently unique based on the data it represents.

Option D) It is a foreign key for a FACT table - This option is incorrect. A surrogate key is not specifically a foreign key for a FACT table. While it can be used as a foreign key, it is not limited to that role.

The correct answer is B) It is a system-generated sequence number. This option is correct because a surrogate key is a unique identifier generated by the system, typically using a sequence number or an auto-incrementing value, to uniquely identify records in a table.

Select a feature that does not belong to Business Intelligence

  1. Publishing report through a web portal.

  2. Cleaning of Source data

  3. Data Mining

  4. Forecasting

  5. Statistical Analysis


Correct Option: B

Which of the following are configuration management tool ?

  1. Control-M

  2. Autosys

  3. Version manager

  4. none of the above


Correct Option: C,D

Can we change the Native Sql

  1. True

  2. False


Correct Option: A

RELATIONSHIPS INSERTED BETWEEN MEASURE DIMENSIONS AND REGULARDIMENSIONS WILL WORK.

  1. True

  2. False


Correct Option: A

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;

  1. it'll display the result of which id=99999

  2. no rows selected

  3. Error

  4. garbage value...


Correct Option: B

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

  1. 128

  2. 136

  3. 64

  4. 32


Correct Option: C

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

  1. True

  2. False


Correct Option: A

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

  1. True

  2. False


Correct Option: A

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

  1. True

  2. False


Correct Option: A

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

  1. True

  2. False


Correct Option: A

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

  1. True

  2. False


Correct Option: A

can u change the Governer Settings in Report Level.

  1. True

  2. False


Correct Option: A

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

  1. True

  2. False


Correct Option: B
  1. Exporting the universe

  2. Extracting the Universe

  3. Copying the Universe

  4. Exporting and then Extracting Universe


Correct Option: D

How can we test the universe & Report?

  1. integrity check

  2. By coping report query and run in backend(oracle,sql server...)

  3. Both a & b

  4. Neither a nor b


Correct Option: C

What are the user requirements in a universe?

  1. Database connections

  2. key column

  3. metrics

  4. Dimension


Correct Option: A,B,C
- Hide questions