Showing posts from 2015Show All

All Scripts Interview Questions

SQL What is mean by primary key?  difference between primary key and foreign key? …

Advantmed Interview Questions

SSIS: 1)  how to import multiple files  in SQl server? 2)  what is mean by  dela…

Accenture Interview Questions - 2

1.Can we use DML statement in view 2.Can we update primary key, what will happen with …

Accenture Interview Questions - 1

SQL: CTE Global Temp Tables Indexes Joins Types of Schema SSIS: Ty…

ABFL Interview Questions

SQL: Describe the Join operations : What is the self join? Please explain in de…

All Scripts Interview Questions

SQL
  1. What is mean by primary key?  difference between primary key and foreign key?
  2. Difference between Where and having?
  3. Difference Between Delete and Truncate?
  4. What is mean by Trigger?
  5. What is functions and procedures?  difference between triggers, procedures and functions?
  6. Explain query plan 
  7. What is index ? explain in detail
  8. What is the difference between  clustered and nonclustered indexes
  9. Write query to find duplicate records
  10. What is TSQL
  11. What is constraint in  SQL
  12. What is normalisation
  13. Difference between temporary table and table variable 
  14. Identity column and unique column
  15. Explain different isolation levels in SQL server
  16. What is view
  17. What is mean by Cursor 
SSIS
  1. Explain SSIS project
  2. What are the ways to to deploy SSIS packages
  3. Difference between Union All transformation and Merge transformation
  4. What is a surrogate key 
  5. What is mean by OLAP?  difference between OLAP and OLTP 
  6. What is BCP
  7. What are different SSIS  log providers
  8. Advantages of using SSIS packages  over Stored procedures
SSRS

  1. Example of SSRS
Posted by Saudagar Jadhav at December 31, 2015 0 comments
Labels:

Advantmed Interview Questions

SSIS:
1)  how to import multiple files  in SQl server?
2)  what is mean by  delay validation?
3)  what is mean by derived column?
4)  what is mean by conditional split?
5)  explain error handling in SSIS?
6)   explain different ways  to Deploy SSIS Pacakge?

SQL:
1)  explain joins?
2)  explain temporary tables,  CTE and table variables?
3)  difference between temporary tables,  CTE and table variables?
4)   what are different types of indexes?
5)  explain nolock in SQL server?
6)  what will be the output of the below query:
SELECT * INTO Table A FROM Table B Where 0=1;
7)  explain  error handling in SQL server
8)  in try catch block how to execute 2nd query,  when 1st query fail?
9)  explain query execution plan
10)  what is mean by Performance tuning?
11)  In vs Exists?

12)  difference between ROW_NUMBER(), RANK(), DENSE_RANK()
Posted by Saudagar Jadhav at December 31, 2015 0 comments
Labels:

Accenture Interview Questions - 2

1.Can we use DML statement in view

2.Can we update primary key, what will happen with the foreign key

3.Is there any solution to update view base on multiple table

4.Difference between return value and output parameter in SP

5.How do you see transaction isolation feature 

6.What is In-Memory Tables in SQL

7.Column store index, DIfference between row store and column store index

8.Is there any difference between normal delete and delete in column store? Is there any difference 

9.Segmentation and fragmentation

10.Have you work on partition table

11.let us go through practical example.(Please go through the image).Write view, for each employee for each row look for the next record and then reduce 1 day that will be effective_upto_date.

12.How do you do requirement gathering, what are steps you will do

13.What kind of delivery method do you use,  Waterfall or Agile ?

14. How do you do impact analysis? if you have 1000 tables , 100 Sp , 50 packages , several reports and other objectsHow do you assess all these impacts for e.g emp id now has int and now client say i want to change as alphanumeric.

EMP table:

Emp_id, Name

1, XYZ

2, PQR

Null,Other

Salary Table :

ID,Salary 

1, 14000

3, 20000

Null, null

Output : Inner join :Left Join :Right Join :Full join :Cross join :

15.How do you train your subordinate, suppose new joinee come, how do you help them as you are a senior resource.
Posted by Saudagar Jadhav at December 31, 2015 0 comments
Labels:

Accenture Interview Questions - 1

SQL:
  1. CTE
  2. Global Temp Tables
  3. Indexes
  4. Joins
  5. Types of Schema
SSIS:

  1. Types of Dimensions
  2. Types of Measure
  3. OLAP vs OLTP
  4. Multiple sheet Importing in SSIS flow with Logic
  5. Delay validation
Posted by Saudagar Jadhav at December 31, 2015 0 comments
Labels:

ABFL Interview Questions

SQL:

  1. Describe the Join operations : What is the self join? Please explain in detail using one example.
  2. What types of joins
  3. What is the difference between varchar & char data types?
  4. We had created the view using CTE, view performance is very poor. It will take around 15+ minutes to fetch the data. How to enhance the view performance?
  5. What types of indexes supported in SQL Server 2016?
  6. What are the new features in SQL Server 2016?
  7. Suppose we join around 10+ tables and query performance is very poor, how to check & optimize the query performance?
  8. Are you worked in Link Servers? If yes, please explain the same.
  9. How to monitor SQL Jobs using the SQL Queries or SQL Agent?
  10. Are you worked in complex stored procedure?
  11. What is the difference between stored procedure & function? Why we are using stored procedure? What are the benefits for the Stored Procedure?
SSIS:
1) Describe the SSIS. Explain the flow how to create normal SSIS ETL Package?
2) What are the data Transformations you used in ETL Packages? Explain in detail.
3) Explain how to load Incremental data using SSIS tool?
4) Difference between Merge Transformation & Lookup Transformation?
5) Explain how to deploy the ETL packages using SSIS 2016?
6) What are the new features in SSIS 2016?
7) We deployed SSIS ETL package in SSIS Catalog & we created the job to execute the Package, suppose the Job is failed due to SSIS Package error, how you can check the error & resolve the same?
8) How we check ETL errors using the SSIS catalog?
9) In case of ETL Package failed, Should we trigger email with the ERROR description? If yes, Please explain in details.
10) Explain Master & Child ETL Packages logic for loading the data.

11) Suppose, In one SSIS package we are loading the data in 4 different tables. Suppose, 3 tables data is loaded successfully & 1 table data load is failed, If I again execute the package, we don't need to load again 3 tables data because the data is successfully loaded. We want to load the data which is failed during the execution. How we will achieve that? Please explain in details.
Posted by Saudagar Jadhav at December 31, 2015 0 comments
Labels:
Subscribe to: Posts (Atom)