Tag: databases

SELECT * FROM Persons WHERE FirstName LIKE '%a'

SELECT * FROM Persons WHERE FirstName ='a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

SELECT * FROM Persons WHERE FirstName='%a%'

INSTR

SUBSTRING

SUBSTR

POS

SELECT DIFFERENT

SELECT DISTINCT

SELECT UNIQUE

SELECT SEPARATE

1

2

3

4

Data about data

Is a subset of a Dataware house

Data collected from various sources

All of the Above

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.

Publishing report through a web portal.

Cleaning of Source data

Data Mining

Forecasting

Statistical Analysis

Control-M

Autosys

Version manager

none of the above

True

False

True

False