Tag: technology

Questions Related to technology

Which are not system status for the project?
technology packaged enterprise solutions

  1. Created

  2. Submitted

  3. Approved

  4. Active

  5. Pending Close

  6. Closed

Show answer
Correct Option: A,D

Below is not in the steps to build the Dataware House :
technology databases

  1. Requirement gathering

  2. Data modeling

  3. Data profiling

  4. Data mining

Show answer
Correct Option: D

Process in which data from disparate, homogeneous or heterogeneous systems is cleansed, aggregated, consolidated, de-normalized and loaded into a single database or data warehouse after applying business rules is :

technology databases

  1. Data Profiling

  2. Data Modelling

  3. Data Integration

  4. Data Staging

Show answer
Correct Option: C

Can you convert a snowflake schema in to star schema?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Is Data modelling and Dimensional modelling same?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which one is not the technique in ER modelling?
technology databases

  1. Conceptual modelling

  2. Physical modelling

  3. Logical modelling

  4. None of the above

Show answer
Correct Option: D

Another name for the EXCEPT operator is __________.
technology databases

  1. INSTEAD OF

  2. NOT IN

  3. INTERSECT

  4. MINUS

Show answer
Correct Option: D

Select the correct order of clauses
technology databases

  1. GROUP BY, HAVING, WHERE

  2. HAVING, WHERE, GROUP BY

  3. GROUP BY, WHERE, HAVING

  4. WHERE, GROUP BY, HAVING

Show answer
Correct Option: D

CREATE SET TABLE A (A Integer, B Integer) Unique Primary Index (A) INSERT INTO Table A (1, 2) INSERT INTO Table A (1, 1) UPDATE Table A SET b = b + 1 WHERE b = 1. Which statement is correct?

technology databases

  1. Both the INSERTs and the UPDATE fails.

  2. The INSERTs work, but the UPDATE fails

  3. Only the first INSERT works.

  4. Only the second INSERT works

Show answer
Correct Option: C

What is the displayed result of the following: SELECT 3 / 4 * 100?
technology databases

  1. 0

  2. .75

  3. 75

  4. 75.00

Show answer
Correct Option: A