SQL Server Interview Question and Answers:
41. What does NULL mean?
The value NULL means UNKNOWN; it does not mean (empty string). Assuming ANSI_NULLS are on in your SQL Server database, which they are by default, any comparison to the value NULL will yield the value NULL.
42. What are the Different Types of Normalization?
First Normal Form
Second Normal Form
Third Normal Form
Boyce’s Normal Form
Fourth Normal Form
Fifth Normal Form
43. What are Page Splits?
Pages are contained in extent. Every extent will have around eight data pages. But all the eight data pages are not created at once; they are created depending on data demand. So when a page becomes full it creates a new page, this process is called as “Page Split”.
44. What is an Identity?
Identity is a column that automatically generates numeric values.
41. What does NULL mean?
The value NULL means UNKNOWN; it does not mean (empty string). Assuming ANSI_NULLS are on in your SQL Server database, which they are by default, any comparison to the value NULL will yield the value NULL.
42. What are the Different Types of Normalization?
First Normal Form
Second Normal Form
Third Normal Form
Boyce’s Normal Form
Fourth Normal Form
Fifth Normal Form
43. What are Page Splits?
Pages are contained in extent. Every extent will have around eight data pages. But all the eight data pages are not created at once; they are created depending on data demand. So when a page becomes full it creates a new page, this process is called as “Page Split”.
44. What is an Identity?
Identity is a column that automatically generates numeric values.
No comments:
Post a Comment