Sql Interview Questions And Answers

Sql Interview Questions list for experienced

  1. What does SQL stand for?
  2. What is the main role of a primary key in a table?
  3. What are foreign keys?
  4. What is Trigger?
  5. What is a Linked Server?
  6. What is Difference between Function and Stored Procedure?
  7. What is sub-query? Explain properties of sub-query?
  8. What are different Types of Join?
  9. What is difference between DELETE & TRUNCATE commands?
  10. What arethe different types of triggers?
  11. What is Service Broker?
  12. Where SQL server user names and passwords are stored in SQL server?
  13. What does TOP Operator Do?
  14. What is MERGE Statement?
  15. Which are new data types introduced in SQL SERVER 2008?
  16. How would you handle error in SQL SERVER 2008?
  17. What is Data Compression?
  18. How to copy the tables, schema and views from one SQL Server to another?
  19. How to copy data from one table to another table?
  20. What is SQLCMD?
  21. What is Aggregate Functions?
  22. Difference between Function and Stored Procedure?
  23. What are the subsets of SQL?
  24. Explain the different types of SQL commands.
  25. What are the different types of database management systems?
  26. What are the usages of SQL?
  27. What is a default constraint?
  28. What do you mean by a table and a field in SQL?

Sql interview questions and answers on advance and basic Sql with example so this page for both freshers and experienced condidate. Fill the form below we will send the all interview questions on Sql also add your Questions if any you have to ask and for apply in Sql Tutorials and Training course just send a mail on info@pcds.co.in in detail about your self.

Top Sql interview questions and answers for freshers and experienced

What is Sql ?

Answer : Structured Query Language (SQL) is a language for querying databases. Questions should include code examples and table structure, and include a tag for the DBMS implementation (e.g. MySQL, PostgreSQL, Oracle, MS SQL Server) being used. If your question relates to a specific DBMS (uses specific extensions/features), use that DBMS\'s tag instead. Answers to questions tagged with SQL should use ANSI SQL as much as possible.

Questions : 1 :: What does SQL stand for?

Structured Query...View answers

Questions : 2 :: What is the main role of a primary key in a table?

The main role of a primary key in a data table is to maintain the internal integrity of a data...View answers

Questions : 3 :: What are foreign keys?


Foreign key field – is a field that links one table to another table’s primary or foreign key.Foreign Key : You can logically relate data from multiple tables...View answers

Questions : 4 :: What is Trigger?

A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Triggers are stored in and managed by the DBMS. Triggers are used to maintain the referential...View answers

Questions : 5 :: What is a Linked Server?

Linked Servers is a concept in SQL Server by which we can add other SQL Server to a Group and query both the SQL Server dbs using T-SQL Statements. With a linked server, you can create very clean,...View answers

Questions : 6 :: What is Difference between Function and Stored Procedure?


UDF can be used in the SQL statements anywhere in the WHERE/HAVING/SELECT section where as Stored procedures cannot be. UDFs that return tables can be treated as another rowset. This can be used in...View answers

Questions : 7 :: What is sub-query? Explain properties of sub-query?

Sub-queries are often referred to as sub-selects, as they allow a SELECT statement to be executed arbitrarily within the body of another SQL statement. A sub-query is executed by enclosing it in a...View answers

Questions : 8 :: What are different Types of Join?

Cross Join A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join. The size of a Cartesian product result set is the number of row s in...View answers

Questions : 9 :: What is difference between DELETE & TRUNCATE commands?


Delete command removes the rows from a table based on the condition that we provide with a WHERE clause. Truncate will actually remove all the rows from a table and there will be no data in the...View answers

Questions : 10 :: What arethe different types of triggers?

There are three types of t riggers. (For a complete lesson on Triggers see Chapters 2 and 3 of SQL Programming Joes 2 Pros Volume 4 ISBN: 1451579489) 1) DML t rigger There are...View answers

Questions : 11 :: What is Service Broker?

Service Broker is a message-queuing technology in SQL Server that allows developers to integrate SQL Server fully into distributed applications. Service Broker is feature which provides facility to...View answers

Questions : 12 :: Where SQL server user names and passwords are stored in SQL server?

They get stored in System Catalog Views sys.server_principals and sys.sql_logins.

Questions : 13 :: What does TOP Operator Do?

The TOP operator is used to specify the number of rows to be returned by a query. The TOP operator has new addition in SQL SERVER 2008 that it accepts variables as well as literal values and can be...View answers

Questions : 14 :: What is MERGE Statement?

MERGE is a new feature that provides an efficient way to perform multiple DML operations. In previous versions of SQL Server, we had to write separate statements to INSERT, UPDATE, or DELETE data...View answers

Questions : 15 :: Which are new data types introduced in SQL SERVER 2008?

The GEOMETRY Type: The GEOMETRY data type is a system .NET common language runtime (CLR) data type in SQL Server. This type represents data in a two-dimensional Euclidean coordinate system. The...View answers

Questions : 16 :: How would you handle error in SQL SERVER 2008?

SQL Server now supports the use of TRY...CATCH constructs for providing rich error handling. TRY...CATCH lets us build error handling at the level we need, in the way we need to, by setting a...View answers

Questions : 17 :: What is Data Compression?

In SQL SERVER 2008 Data Compression comes in two flavors:  Row Compression  Page Compression Row Compression Row compression changes the format of physical storage of data. It...View answers

Questions : 18 :: How to copy the tables, schema and views from one SQL Server to another?

There are multiple ways to do this. 1)“Detach Database” from one server and “Attach Database” to another server. 2)Manually script all the objects using SSMS and run the...View answers

Questions : 19 :: How to copy data from one table to another table?

There are multiple ways to do this. 1) INSERT INTO SELECT This method is used when table is already created in the database earlier and data is to be inserted into this table from another table....View answers

Questions : 20 :: What is SQLCMD?

sqlcmd is enhanced version of the isql and osql and it provides way more functionality than other two options. In other words sqlcmd is better replacement of isql (which will be deprecated...View answers

Questions : 21 :: What is Aggregate Functions?

Aggregate functions perform a calculation on a set of values and return a single value. Aggregate functions ignore NULL values except COUNT function. HAVING clause is used, along with GROUP BY, for...View answers

Questions : 22 :: Difference between Function and Stored Procedure?

Cu UDF can be used in the SQL statements anywhere in t he WHERE/HAVING/SELECT section where as Stored procedures cannot be. UDFs that return tables can be treated as another r owset. This can be...View answers

Questions : 23 :: What are the subsets of SQL?

The main significant subsets of SQL are: DDL (Data Definition Language) DML (Data Manipulation Language) DCL (Data Control Language) TCL (Transaction Control...View answers

Questions : 24 :: Explain the different types of SQL commands.

Data Definition Language: DDL is that part of SQL which defines the data structure of the database in the initial stage when the database is about to be created. It is mainly used to create and...View answers

Questions : 25 :: What are the different types of database management systems?

Database management systems are classified into four types: Hierarchical database: It is a tree-like structure where the data is stored in a hierarchical format. In this database, the parent may...View answers

Questions : 26 :: What are the usages of SQL?

These are the operations that can be performed using SQL: Creating new databases Inserting new data Deleting existing data Updating records Retrieving the data Creating and dropping...View answers

Questions : 27 :: What is a default constraint?

Constraints are used to specify some sort of rules for processing data and limiting the type of data that can go into a table. Now, let’s understand the default constraint. The default...View answers

Questions : 28 :: What do you mean by a table and a field in SQL?

Organized data in the form of rows and columns is said to be a table. Here, rows and columns are referred to as tuples and attributes.The number of columns in a table is referred to as a field. In...View answers
More Question

Ask your interview questions on Sql

Write Your comment or Questions if you want the answers on Sql from Sql Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---