Shivprasad koirala s sql server: interview questions presents a solution for those programmers who want to get a job in software industry. It is a known fact that a. By Shiv Prasad Koirala in SQL; Nov 22nd, ; ; 0 Taken from the best selling SQL Server interview question book,you can see more about the book by . By Shiv Prasad Koirala in SQL; Mar 25th, ; ; 0 This article is extracted from the SQL Server interview question book published by BPB publication.

Author: Akirn Bazuru
Country: Vietnam
Language: English (Spanish)
Genre: Art
Published (Last): 28 February 2006
Pages: 93
PDF File Size: 15.16 Mb
ePub File Size: 3.97 Mb
ISBN: 706-6-41826-484-1
Downloads: 49303
Price: Free* [*Free Regsitration Required]
Uploader: Akilkree

For a table to be in first normal form, data must be broken up into the smallest units possible. Therefore, in this architecture, the client PC should have heavy configuration and it increases network traffic as a lot of data is sent to the client PC.

Sql Server Interview Questions

DB Have you heard about sixth normal form? You can fire the below query. Every sales person is marked with a primary key called as “SalesId”.

Wonderful work, however the topics covered here are less important than T-SQL questions, like joins or grouping. Add some more questions sithmichel Sep 2: Q What are E-R diagrams?

The first row “Shiv” indicates the top sales person in the hierarchy. To ask other readers questions about Sql Server Interview Questionsplease sign up.

But the disadvantage is that you need a robust central host server like Main Frames.

Below is a simple example which represents asales team organization hierarchy. If some interviewers think of this as a main difference between files and database, accept it… going in to debate means probably losing a job.

Mohsin Jamadar is currently reading it Jan 02, Interciew forms is really funny thing.

Abhijeet marked it as to-read Jun 23, E-R diagram also termed as Entity-Relationship diagram shows the relationship between various tables in the database. Finally, it should provide an independent way of accessing data and should not be dependent on the application to access the information. There is a huge similarity between Fourth and Fifth normal form, i. Extent is a basic unit of storage to provide space for tables.

But I think no matter how much experience you have, an interview is a different ball game. Now to establish the tree structure hierarchy we need to enter data in a linked list format.

Sql Server Interview Questions by Shiv Prasad Koirala

The major difference is the database size 2 GB and 4 GB servre, support of. Below is the complete fifth normal form of the database. In client server architecture, you have two entities, client and the database server.

Pages are contained in extent. Following is the list of architecture differences between them:. This set of byy is known as Normalization. One Asset can have sql server interview question by shivprasad koirala Maintenance.

Fifth normal form deals with reconstructing information from smaller pieces of information. You can read about the book by clicking on this link – http: This is a simple text file, which was designed by a programmer for a specific application. For every data row, there is a row offset which points to that data row. Dealers in order to sell the Product should be registered with shivpprasad Company.

SQL Server Interview Questions – Part 1 – CodeProject

Serrver new records are inserted new data, pages are allocated. So as soon as the eight pages are consumed, it allocates a new extent with data pages.

Sql Server Interview Sql server interview question by shivprasad koirala it was amazing 5. A good project executioner can get knocked off on simple SQL Server questions. In other words, each non-key field should be a fact about all the fields in the primary key. During an interview, people expect to answer a maximum of three normal forms and that’s what is expected practically.

You can add some more questions for sql developer like Q1. You do not have to really say all the above points during an interview.