Which are not system status for the project?
Created
Submitted
Approved
Active
Pending Close
Closed
Below is not in the steps to build the Dataware House :
Requirement gathering
Data modeling
Data profiling
Data mining
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 :
Data Profiling
Data Modelling
Data Integration
Data Staging
Can you convert a snowflake schema in to star schema?
True
False
Is Data modelling and Dimensional modelling same?
Which one is not the technique in ER modelling?
Conceptual modelling
Physical modelling
Logical modelling
None of the above
Another name for the EXCEPT operator is __________.
INSTEAD OF
NOT IN
INTERSECT
MINUS
Select the correct order of clauses
GROUP BY, HAVING, WHERE
HAVING, WHERE, GROUP BY
GROUP BY, WHERE, HAVING
WHERE, GROUP BY, HAVING
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?
Both the INSERTs and the UPDATE fails.
The INSERTs work, but the UPDATE fails
Only the first INSERT works.
Only the second INSERT works
What is the displayed result of the following: SELECT 3 / 4 * 100?
0
.75
75
75.00