SQL Server Interview Questions and Answers Day – 3

Before going through SQL Server Interview Questions and Answers Day – 3,  I would like to recommend you to go through previous article : SQL Server Interview Questions and Answers Day – 1 SQL Server Interview Question and Answers Day -2 What is View ? View is nothing but a Virtual table which is used the retrieve data from one table or multiple tables. There is no physical existence view in a database. Basically view is used to create a subset of a table or multiple tables. View is used to summarize data from various tables which can be used Read More …

Share Knowledge

SQL Server Interview Questions and Answers Day -2

Before going through SQL Server Interview Questions and Answers Day – 2,  I would like to recommend you to go through previous article : SQL Server Interview Questions and Answers Day – 1 What is SQL command? SQL are a set of instructions which is responsible to create, select, delete database as well database tables. In other words SQL commands are responsible to create and do all the manipulation in the database as well as database tables. How many types of SQL commands? SQL command has been divided into five major groups depending on their functionality. i. Data Definition Language Read More …

Share Knowledge

SQL Server Interview Questions and Answers Day 1

Day 1 – SQL Server Interview Questions and Answers What is SQL? SQL is the internationally recognized standard language for dealing with data in relational database. SQL is a language specifically and solely designed to create, operate on, and manage relational database. SQL isn’t a general-purpose language, such as C++ or Java; it is Structured Query Language which is used for storing data, manipulating, and retrieving data stored in a relational database. SQL is a language specifically and solely designed to create, operate on, and managed relational    databases.   What is RDBMS? RDBMS stands for Relational Database Management System; it Read More …

Share Knowledge