Before Applying job posting in any websites or recruiting agencies or sending resumes to job recruiters or any other employment website you need to improve your skills on general knowledge, Aptitude, Puzzles, logical reasoning, general english, database, programming as per your job profile. Job recruiters or mostly preferring job candidates who are having more stuff in those categories mentioned above. So improving more skills on your job profile always boost up your career and your performance. Even hiring companies and job recruiters who are looking for many job posting websites actually they are looking and filtering on these activities. In these Sql Server section you need to update more questions to perform well in front of job recruiters and companies. Sql Server Interview questions are most important to score in interview, Update all questions to score well in all rounds in job interview.

Sql Server interview questions and answers

Why Sql Server test required for job stream?

SQL Server test is now important in job stream (Administration, IT software, software testing etc.).In Brightbix, you can practice online SQL Server questions and answers with the explanations in order to face interview, competitive exams like (TCS, Wipro, Infosys, Dell, Oracle, IBM etc.)

Where fresher and teens can get online SQL Server question and answers with an explanation?

In bright brainy, students can learn and practice SQL Server question and answers that it would be strengths, their current academic and its gives path to future career. Here you can find online test SQL Server questions and answers (technical, computer science, sample TCS, Infosys,Wipro and IT) with explanations for fresher which improve skills to face interview. Brightbix provides sample SQL Server questions and answers with detailed explanation and it would be ease to understand, SQL Server question and answers available for free download PDF.

Bright brainy offers lots of solved SQL Server questions

Here you can find lots of SQL Server question and answers with detailed descriptions. You can download free eBook pdf SQL Server question and answers.

1)
What is denormalization?

Denormalization is the process of putting one fact in numerous places (its vice –versa of normalization). Only one valid reason exists for denormalizing a relational design –to enhance performance or if we are doing data warehousing and data mining. The sacrifice to performance is that you increase redundancy in database.

2)
What is a candidate key ?

A table may have more than one combination of columns that could uniquely identify the rows in a table : each combination is a candidate key. During database design you can pick up one of the candidate keys to be the primary key . For example, in the supplier table supplieried and suppliername can be candidate key but you will only pick up supplierid as the primary key.

3)
What are indexes and what is the difference between clustered and nonclustered ?

Indexes in SQL Server are similar to the indexes in books . They help SQL Server retrieve the data quickly there are clustered and nonclustered indexes. A clustered index is a special type of index that reorders the way in which records in the table are physically stored. Therefore, table can have only one clustered index. The leaf nodes of a clustered index contain the data pages.

A nonclustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a nonclustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

4)
What is DTS ?

DTS is used to import data and while importing it helps us to transform and modify data. The name itself is self explanatory DTS (Data transformation Services).

5)
What is fill factor ?

The ‘fill factor’ option specifies how full SQL Server will make each index page. When there is no free space to insert new row on the index page, SQL Server will create new index page and transfer some rows from the previous page to the new one This operation is called page splits. You can reduce the number of page splits by setting the appropriate fill factor option to reserve free space on each index page. the fill factor is a value from 1 through 100 that specifies the percentage of the index page to be left empty. The default value for fill factor is 0. It is treated similarly to a fill factor value of 100, the difference in that SQL Server leaves some space within the upper level of the index tree for FILLFACTOR = 0. The fill factor percentage is used only at the time when the index is created . If the table contains read only data (or data that very rarely changed) , you can set the ‘fill factor’ option to 100. When the table’s data is modified very often , you can decrease the fill factor to 70% or whatever you think is best.