SQL Server Interview Questions You'll Most Likely Be Asked

5 of 5 Stars!

Price: $19.95
Sale: $16.56
Save: 17% off


Qty. 
+-
SQL Server Interview Questions You'll Most Likely Be Asked is a perfect companion to stand a head above the rest in today’s competitive job market. Rather than going through comprehensive, textbook-sized reference guides, this book includes only the information required immediately for job search to build an IT career. This book puts the interviewee in the driver's seat and helps them steer their way to impress the interviewer. 
 
Table of contents
1. Engine Enhancements
2. Availability and Disaster Recovery Enhancements
3. Column store Index
4. Security Enhancements
5. Programmability and Beyond-Relational Enhancements
6. Integration Services
7. Data Quality Services
8. Master Data Services
9. Analysis Services and PowerPivot
10. Reporting Services
HR Questions
Index
 
Includes:
(a) 290 SQL Server Interview Questions, Answers and proven strategies for getting hired as DBA
(b) Dozens of scenario based examples to respond to interview questions
(c) 76 HR Questions with Answers and proven strategies to give specific, impressive, answers that help nail the interviews
(d) 2 Aptitude Tests download available on www.vibrantpublishers.com
 
Sample from the book
(Below Questions and Answers are randomly taken from different pages of the book)
 
1: List out the major engine enhancements in SQL Server 2005 database engine.
Answer:
Some of the major engine enhancements featured in SQL Server 2005 are in the fields of Programmability, Manageability, Distributed Queries, Availability, XML, Scalability and Performance, International Enhancements and Security Enhancements. Some major improvements are the introduction of new data types, integration of SQL programming with the .Net environment, the database engine can be managed more dynamically, improved indexing, backup and restore features, XML data type, improved native table and index partitions, improved characterset support and better security enhancements. The latest version, SQL Server 2016, is promising some enhancements in Stretch Database, Foreign Key relationship limits and SERVERPROPERTY. It also has upgrades in the Analysis Services, Master Data Services, Integration Services and Reporting Services.
 
2: List 3 major Programmability Enhancements in SQL Server 2005 database engine.
Answer: 

Some of the major Programmability enhancements featured in SQL Server 2005 are:
a) New data types like CLR, XML and large object data types such as varchar(max), nvarchar(max) etc.
b) Integration with .Net framework for using T-SQL  statements, Triggers, Stored Procedures and User-defined Functions within the Visual Studio IDE. This gives more options in the .Net framework to manipulate and debug database programming easily. 
c) New operators in Transact SQL such as APPLY, PIVOT and UNPIVOT. The APPLY operator lets the user call a function that returns a table data type or a subquery against each row of the outer query. PIVOT and UNPIVOT are used to turn the rows into columns and columns into rows (rotating data) for cross-tab reports. 
 
3: List 4 major Manageability Enhancements in SQL Server 2005 database engine.
Answer: 

The main Manageability Enhancements in SQL Server 2005 is that the database engine can be managed more dynamically. The users and schemas are separated now for better security, table and Index partitioning has improved considerably, files can be initialised instantly and managing the indexes has become easier. The 3 major enhancements are:
a) In the Security aspects – the 2005 release has included a GRANT permission which can be used to grant all permissions. The objects are now stored in schemas and individual users cannot own them. Instead, access is given to specific roles for specific schemas. Users who belong to these roles can access the schema and the objects in it.  
b) For the Administrators – table and index partitions are allowed in 2005 release. This makes managing bulk data much easier. Dynamic memory management is possible now which supports large databases as against the static memory in the earlier versions which had limitations.
c) Managing the indexes has become simpler and more effective in 2005 release. Now the administrators can reorganize, rebuild or disable the indexes easily.
d) Since XML has become a new data type in 2005 version, now we can create a new XML schema for storing and managing XML documents within the database.
 
4: List the major Security Enhancements in SQL Server 2005 database engine.
Answer:
 
The latest Security enhancements are reduced surface area during installation using a configuration tool, data encryption within the database, granular permission, password policy at par with Windows Server 2003, security context for module execution is defined and multiple proxy accounts are allowed. During installation, all features are not installed by default as earlier. This reduces the surface area required for installation. The Surface Area Configuration tool allows the user to manage the server’s external safety profile using a GUI. Module signing lets hiding the inner modules and schema of the database from the end user. The first module which is open to the end user is granted permission and there the basic security validations can be done. SQL Server 2005 allows the stored procedures, triggers (other than DDL triggers), functions and assemblies to be signed or secured.