1.Explain about your current project?
2.What are Data marts?why do you use ?
3.What is STLC?
4.What is UAT?When does it perform?
5.What is Smoke Testing?
6.What are the Scenarios you cover in ETL Testing?
7.How will you validate Duplicates?
8.Difference between Int and Bigint
9.Difference between Varchar and nvarchar
10.Difference between Unique key and Primary Key
11.Surrogate key use
12.Indexing
13.SubString,String
14.Date Function (How wil you validate the date column?)
15,Pivot in SQL
16.Difference between Union and Full outer join
17.How will you run the jobs in Data stage
18.How to find the maximum salary of the employees.
19.Write the SQL-How will you find the 5th Highest salary from Employee table(Rank and Dense Rank)
20.Difference between Verification and validation of code
21.Unix basic commands
22.What is look up? and How will you validate Foreign Key
23.Normalization(What is it?)
24. RDBMS
25.Indexes(Clustered)
No comments:
Post a Comment