SQL Server Interview Questions !
1) Explain in brief about Microsoft SQL server?
Microsoft SQL server is primarily produced by Microsoft and it uses Transact-SQL as its query language. This is a Relational database management system which implements ANSI and ISO standards. It is one of the most popular software for Data base management.
2) Explain about the architecture of MYSQL?
Architecture of MYSQL comprises of three main components they are
• SQLOS
• Relational Engine
• Protocol Layer.
SQLOS implements basic functions such as thread scheduling, I/O and memory management. Relational engine is used to support databases, stored procedures, tables, etc. SQL functionality is dependent upon the Protocol layer.
3) Detail about the hardware which is supported by SQL server?
SQL server basically supports about 2GB memory on a x86 hardware. If address window extension is installed in the operating system it will support up to 64 GB. On x64 hardware 8 TB of memory is supported. 4 GB of memory is supported when x86 versions are run on x64 hardware.
4) Explain about SQLOS?
Functions such as buffer pool management, synchronization primitives, memory and I/O management, etc are supported by SQLOS. This forms the base component in SQL. Thread management is entirely performed by SQLOS, it also monitors worker threads to detect and recover it from dead locks.
5) Explain about thread and memory management process of SQL?
SQL server implements its own thread and memory and it doesn’t rely on the operating system because it needs specialized features. All the different operations are divided into tasks. It takes care of all the background works and client process requests.
6) Explain about protocol layer present in SQL server?
External interface is implemented by SQL server. Communications of external tasks are routed through Microsoft defined format onto the Protocol layer. Tabular data systems are used to transfer data between a client and server. Access to SQL is possible through these protocols.
7) Explain about service Broker functions?
Messaging and message queuing platform is provided by SQL server applications. It is a part of database engine and provides an asynchronous programming environment. It communicates over TCP/IP and it is used to synchronous different applications.
8) Explain about merge replications?
Changes if any from the subscriber and publisher are tracked and these changes are synchronized between both of them. In case the same data is changed by the publisher and subscriber then this will result in an error which has to be manually rectified. Useful for subscription based content addition/changing.
9) Explain about reporting services of MYSQL?
This forms the report generating environment whereby a report is generated by the data generated by the client and server. This feature is administered via a web interface. Reports are created in RDL format. They can be designed by Microsoft visual studio.
10) Explain about integration services of Microsoft SQL server?
This integration feature is used to integrate data from various sources. This is chiefly used for business analysis (data ware housing). This includes GUI tools which help in building data extraction workflows, duplication and merging data, etc. This also helps to send email detailing the status of operation.
11) Explain about the command line tool SQLCMD?
This command line tool is available in the package of Microsoft SQL server. This state about the management features of SQL server. Queries can be written and executed using this prominent tool. Scripts using this command tool are stored as .sql and can be used to manage or create database.
12) Explain about Microsoft Visual studio?
Microsoft Visual studio provides supports data programming with Microsoft Visual studio. This can be used to write and debug code which can be executed by SQL CLR. A data designer is provided which can create, view and design data bases.
13) Explain about T SQL?
T-SQL is used to program and manage SQL server. Key operations such as creating, altering, entering and editing can be performed with the help of T-SQL. SQL Server functionality can be leveraged by sending T-SQL queries to the server which are then process and sent to the client.
14) Describe and explain about SQL native client?
SQL native client supports client side data access library for Microsoft SQL server. It supports various features such as TDS implementation, data types support, query notifications, etc. It can also receive multiple results in a single database. It can also be used with the help of generic data access layers.
15) Explain about SQL server 2005?
It is the successor of SQL server 2000. It has support to manage XML data in addition to relational data. XML data type is converted into binary before storing it in the database. Using TDS packets SQL server 2005 allows data base server to be exposed over web services.