Are you searching for SQL Server interview or viva questions?
Here we are giving some common SQL server questions with answers. These are frequently asked in project viva and also in job interview.
Here are some SQL Server Interview Questions
Q.1 What is use of GROUP BY and HAVING clause in SQL?
Ans: The GROUP BY clause partitions the selected rows on distinct values of the column on which the group by has been made while HAVING selects groups which match the criteria specified.
Q.2 What is tuple in SQL?
Ans: It is an instance of data within a relational database.
Q. 3 Explain SQL Profiler?
Ans: SQL Profiler is a graphical tool. System administrators can monitor events in an instance of Microsoft SQL Server. We can save and capture data of each event in a file or SQL Server table and analyze it later.
Q. 4 Explain User Defined Functions?
Ans: User-Defined Functions allow us to define its own T-SQL functions. These function accept 0 or multiple parameters.
Q.5 What is schema?
Ans: It is a collection of database objects of Use.
Q.6 What is Sequence?
Ans: A Sequence is a database object. A Sequence may be used for providing very quick generation of unique numbers.
Q.7 What is Equi Joins in SQL?
Ans: In this kind of join operation the join comparison operator is an equality. When we join two tables together through equality or values in one or more columns , this is called Equi join.
Q. 8 What is Cartesian Join?
Ans: When two tables are joined without using a where class it produces a Cartesian join. It combines each row of one table with each row of another table.
Q.9 Tell three SQL keywords which are used to change or set someone’s permissions?
Ans: GRANT, REVOKE and DENY.
Q.10 What are data model in SQL?
Ans: Data model is the underlying the structure of the database.
Q.11 What is an Entity?
Ans: Entity is a ‘thing’ in the real world and which has an independent existence.
Q.12 Explain Data Warehousing?
Ans: “A Data warehouse is a subject oriented, non volatile integrated ,time variant collection of data for supporting management in decision making process”.
Q.13 Tell the advantages of Database?
- reduced data Redundancy
- Shared data
- Enforce security
- Enforce security
- Maintain integrity
- Avoided data Inconsistency
Q.14 List the advantage of SQL?
- SQL provides a greater abstraction in comparison to procedural languages.
- End users and system personnel can deal with a number of database management system
Q.15 What is BCP?
Ans: BCP is a short form of BulkCopy. We can copy heavy amount of data from table and view by using it.
Q.16 List some transaction properties?
Q.17 Deference between DBMS and object oriented DBMS?
Ans: DBMS contains a collection of interrelated data and also a set of program for accessing this data. While the object oriented DBMS stores information in the form of objects.
Q.18 List the types of SQL Commands?
- Data Control Language (DCL)
- Data Manipulation Language (DML)
- Data Definition Language (DDL)
- Data Query Language (DQL)
Q.19 What are attributes in SQL?
Ans: In SQL an entity is represented by a set of attributes. These are descriptive properties of each member of an entity set. Different types of attributes are.