1.Explain Active/Active and Active/Passive cluster configurations?
Ans: Many Diff are there :
1.Active/Active : It is the bassically use for the default nodes, Here first node will be default and second node will be named instance. Both node will be active.
Its Move group from cluster administration is possible for both side.
System performance will go down, if both resources are in one node.
2.Active/Passive : Its also basically use for nodes But in this case Only one Active node with default instance. No system performance degradation will be there for this case even if we switchover to the other node. Both have same configuration.
2.What is Data Compression?
Ans: In the new version of SQl Server 2008 are diff type of Data Compressions :
1. Row Compression
2. Page Compression
3. Dictionary Compression
3.What is the mean of Row Compression?
Ans: Row compression changes the format of physical storage of data. It minimize the metadata
In SQL SERVE 2008 Data Com column information, length, offsets etc .associated with each record. Numeric data types and fixed length strings are stored in variable-length storage format, just like Varchar.
4.What is the Page Compression?
Ans: Its is bassically use for the sharing of the two common data b/w rows of the given page. Its have a many tecniques for the compression of the data :
1. Row Compression
2. Prefix Compression
5.What is the mean of Dictionary Compression?
Ans: Dictionary Compression is bassically use for the searching . Seaching bassically the duolicat This Dictionary mainly work is the differentiate between prefix and dictionary compression is that prefix is only restricted to one column while dictionary is applicable to the complete page. value thoroughout the page,and stores them to CI
6.What is Xml Datatype?
Ans: Xml is the bassically that type of Datatype which is use for SQL Server Datatype, Its a Xml documents and fragments in a Sql server. Xml bassically a instances that is missing a single top-level element. we can create columns and variables of the xml type and store XML instances in them. The xml data type and associated methods help integrate XML into the relational framework of Server.
7.What do you mean by Leaf Nodes?
Ans: A Leaf Node is bassically type of Container which is contain the Index terms and horizontal pointer also for other leaf nodes .Which can be many .
8.What do you mean by Branch Node?
Ans: A Branch Node is bassically contain the Pointers for leaf nodes or the other Branch nodes , Which can be two or more.
9.What is the mean of Root Node?
Ans: A Root Node is bassically use for containing the node Pointers to branch node which can be only one.
10.What is the mean of UNIONALL?
Ans: UNIONALL is bassically a command, It is much like a UNION COMMAND, But it is some diff'es like : THis command is select all values.
Ans: Many Diff are there :
1.Active/Active : It is the bassically use for the default nodes, Here first node will be default and second node will be named instance. Both node will be active.
Its Move group from cluster administration is possible for both side.
System performance will go down, if both resources are in one node.
2.Active/Passive : Its also basically use for nodes But in this case Only one Active node with default instance. No system performance degradation will be there for this case even if we switchover to the other node. Both have same configuration.
2.What is Data Compression?
Ans: In the new version of SQl Server 2008 are diff type of Data Compressions :
1. Row Compression
2. Page Compression
3. Dictionary Compression
3.What is the mean of Row Compression?
Ans: Row compression changes the format of physical storage of data. It minimize the metadata
In SQL SERVE 2008 Data Com column information, length, offsets etc .associated with each record. Numeric data types and fixed length strings are stored in variable-length storage format, just like Varchar.
4.What is the Page Compression?
Ans: Its is bassically use for the sharing of the two common data b/w rows of the given page. Its have a many tecniques for the compression of the data :
1. Row Compression
2. Prefix Compression
5.What is the mean of Dictionary Compression?
Ans: Dictionary Compression is bassically use for the searching . Seaching bassically the duolicat This Dictionary mainly work is the differentiate between prefix and dictionary compression is that prefix is only restricted to one column while dictionary is applicable to the complete page. value thoroughout the page,and stores them to CI
6.What is Xml Datatype?
Ans: Xml is the bassically that type of Datatype which is use for SQL Server Datatype, Its a Xml documents and fragments in a Sql server. Xml bassically a instances that is missing a single top-level element. we can create columns and variables of the xml type and store XML instances in them. The xml data type and associated methods help integrate XML into the relational framework of Server.
7.What do you mean by Leaf Nodes?
Ans: A Leaf Node is bassically type of Container which is contain the Index terms and horizontal pointer also for other leaf nodes .Which can be many .
8.What do you mean by Branch Node?
Ans: A Branch Node is bassically contain the Pointers for leaf nodes or the other Branch nodes , Which can be two or more.
9.What is the mean of Root Node?
Ans: A Root Node is bassically use for containing the node Pointers to branch node which can be only one.
10.What is the mean of UNIONALL?
Ans: UNIONALL is bassically a command, It is much like a UNION COMMAND, But it is some diff'es like : THis command is select all values.
| Previous | Next |
:: Click the links below for similar type Questions and answers ::
Posted in: 
0 comments:
Post a Comment