Skip to main content

Top 30 SQL Interview Questions and Answers ?

 Interview Questions and Answers – Frequently?
1.What is RDBMS?
2.What are the Properties of the Relational Tables?
3.What is Normalization?
4.What is De-normalization?
5.How is ACID property related to Database?
6.What are the Different Normalization Forms?
7.What is a Stored Procedure?
8.What is a Trigger?
9.What are the Different Types of Triggers?
10.What is a View?
11.What is an Index?
12.What is a Linked Server?
13.What is a Cursor?
14.What is Collation?
15.What is the Difference between a Function and a Stored Procedure?
16.What is subquery? Explain the Properties of a Subquery?
17.What are Different Types of Join?
18.What are Primary Keys and Foreign Keys?
19.What is User-defined Functions? What are the types of User-defined Functions that can be created?
20.What is an SQL Server Agent?
21.What is PRIMARY KEY?
22.What is UNIQUE KEY Constraint?
23.What is FOREIGN KEY?
24.What is CHECK Constraint?
25.What is NOT NULL Constraint?
26.What is the difference between UNION and UNION ALL?
27.What is the difference between CHAR and VARCHAR Datatypes?
28.What is the Difference between VARCHAR and VARCHAR(MAX) Datatypes?
29.What is the Difference between VARCHAR and NVARCHAR datatypes?
30.Which are the Important Points to Note when Multilanguage Data is Stored in a Table?
31.What is SQL Injection?
32.How to Delete Duplicate Rows?

Comments

Post a Comment

Popular posts from this blog

A great career to Data Analyst fields

We are mid way in 2017 and we have been seeing some big changes in the business world. New forms of data analysis will be emerging to offer companies much more by way of Business Intelligence, operational guidance, and strategic market tactics. So what exactly will we see coming into play next year?   I know that the education system in India still follows once in a 10 year syllabus appraisal system and students still think that computer industry means C, C++, Java and .Net (in some colleges, in fact they still teach COBOL. So ultimately they fall in love with these languages and feel disheartened if somebody asks them to work on something new. This is especially true for Data analytics & Business Intelligence as other IT work would have some amount of language programming (e.g. in Mobile/Web development etc.) but Data analytics & Business Intelligence is mostly playing with software tools at junior level . Data analytics & Business Intelligence has been bill
3 comments
Read more

WHAT IS BUSINESS INTELLIGENCE (BI)?

BI  is an abbreviation of the two words  B usiness  I ntelligence , bringing the right information at the right time to the right people in the right format. It is a 5-step process to run your business smarter, starting with registering the right data correctly, collecting the data from multiple sources, transforming, combining and storing it in a data warehouse.                                        This data should be reported, analysed and distributed to the right people at the right time in the right format. The figure  shows these steps.
1 comment
Read more

Business Intelligence tools :

The most popular BI tools on the market are: 1] Oracle - Siebel Business Analytics Applications 2] SAS - Business Intelligence 3] SAP - BusinessObjects XI 4] IBM - Cognos 8 BI 5] Oracle - Hyperion System 9 BI+ 6] Microsoft - Analysis Services 7] MicroStrategy - Dynamic Enterprise Dashboards 8] Pentaho - Open BI Suite 9] Information Builders - WebFOCUS Business Intelligence.   Etc
3 comments
Read more