+91 90691 39140 | +1 253 214 3115 | info@hub4tech.com | hub4tech

SQL Server Interview Questions and Answers

1
When is the UPDATE_STATISTICS command used?
  • When the processing of large data is done, this command is used.
  • Whenever large number of deletions, modification or copy takes place into the tables, the indexes need to be updated to take care of these changes. UPDATE_STATISTICS performs this job.
2
What are DMVs?

Dynamic Management Views (DMVs), are functions that give you information on the state of the server. DMVs, for the most part, are used to monitor the health of a server. They really just give you a snapshot of what’s going on inside the server. They let you monitor the health of a server instance, troubleshoot major problems and tune the server to increase performance.

3
What is RDBMS?

Relational Data Base Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships may be created and maintained across and among the data and tables. In a relational database, relationships between data items are expressed by means of tables. Interdependencies among these tables are expressed by data values rather than by pointers. This allows a high degree of data independence. An RDBMS has the capability to recombine the data items from different files, providing powerful tools for data usage.

4
What are tables and Fields?

A table is a set of data that are organized in a model with Columns and Rows. Columns can be categorized as vertical, and Rows are horizontal. A table has specified number of column called fields but can have any number of rows which is called record.

Example:.
Table: Employee.

Field: Emp ID, Emp Name, Date of Birth.

Data: 201456, David, 11/15/1960.

5
Differentiate between a HAVING CLAUSE and a WHERE CLAUSE.

HAVING CLAUSE

  • HAVING CLAUSE is used only with the SELECT statement.
  • It is generally used in a GROUP BY clause in a query.
  • If GROUP BY is not used, HAVING works like a WHERE clause.

WHERE Clause

  • It is applied to each row before they become a part of the GROUP BY function in a query.
Copyright ©2015 Hub4Tech.com, All Rights Reserved. Hub4Tech™ is registered trademark of Hub4tech Portal Services Pvt. Ltd.
All trademarks and logos appearing on this website are the property of their respective owners.
FOLLOW US