Tag: databases

Questions Related to databases

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?
technology databases

  1. SELECT * FROM Persons WHERE FirstName LIKE '%a'

  2. SELECT * FROM Persons WHERE FirstName ='a'

  3. SELECT * FROM Persons WHERE FirstName LIKE 'a%'

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

Show answer
Correct Option: C

Which character function can be used to return a specified portion of a character string?
technology databases

  1. INSTR

  2. SUBSTRING

  3. SUBSTR

  4. POS

Show answer
Correct Option: C

Which SQL statement is used to return only different values?

technology databases

  1. SELECT DIFFERENT

  2. SELECT DISTINCT

  3. SELECT UNIQUE

  4. SELECT SEPARATE

Show answer
Correct Option: B

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

  1. 1

  2. 2

  3. 3

  4. 4

Show answer
Correct Option: A

Datamart is a ?
technology databases

  1. Data about data

  2. Is a subset of a Dataware house

  3. Data collected from various sources

  4. All of the Above

Show answer
Correct Option: B

Surrogate Key means
technology databases

  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.

Show answer
Correct Option: B

Select a feature that does not belong to Business Intelligence

technology databases

  1. Publishing report through a web portal.

  2. Cleaning of Source data

  3. Data Mining

  4. Forecasting

  5. Statistical Analysis

Show answer
Correct Option: B

Which of the following are configuration management tool ?
technology databases

  1. Control-M

  2. Autosys

  3. Version manager

  4. none of the above

Show answer
Correct Option: C,D

Can we change the Native Sql
technology databases

  1. True

  2. False

Show answer
Correct Option: A

RELATIONSHIPS INSERTED BETWEEN MEASURE DIMENSIONS AND REGULARDIMENSIONS WILL WORK.
technology databases

  1. True

  2. False

Show answer
Correct Option: A