1.What are the properties and different Types of Sub-Queries?
Ans: Properties of Sub-Query
1.A sub-query must be enclosed in the parenthesis.
2.A sub-query must be put in the right hand of the comparison operator, and
3.A sub-query cannot contain an ORDER-BY clause.
4.A query can contain more than one sub-query.
Types of Sub-Query
1.Single-row sub-query, where the sub-query returns only one row.
2.Multiple-row sub-query, where the sub-query returns multiple rows,. and
3.Multiple column sub-query, where the sub-query returns multiple columns
2.What is SQL Profiler?
Ans: SQL Profiler is a graphical tool that allows system administrators to monitor events in an instance of Microsoft SQL Server. You can capture and save data about each event to a file or SQL Server table to analyze later. For example, you can monitor a production environment to see which stored procedures are hampering performances by executing too slowly.
Use SQL Profiler to monitor only the events in which you are interested. If traces are becoming too large, you can filter them based on the information you want, so that only a subset of the event data is collected. Monitoring too many events adds overhead to the server and the monitoring process and can cause the trace file or trace table to grow very large, especially when the monitoring process takes place over a long period of time.
3.Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible?
Ans: Yes. Because Transact-SQL supports recursion, you can write stored procedures that call themselves. Recursion can be defined as a method of problem solving wherein the solution is arrived at by repetitively applying it to subsets of the problem. A common application of recursive logic is to perform numeric computations that lend themselves to repetitive evaluation by the same processing steps. Stored procedures are nested when one stored procedure calls another or executes managed code by referencing a CLR routine, type, or aggregate. You can nest stored procedures and managed code references up to 32 levels.
4.What is SQLCMD?
Ans: SqlCmd is bassically a very important for that SQL Server It can be work with two modes :
1. BATCH and
2. Intractive Mode
It is the Enhaceversion of isql which is depricated Eventuallyand osql which is not include in SQL Server 2005 RTM, It is the Better replacement of OSQL and ISQL. It provides way more functionality that other two options.
5.What is the Dirty Read?
Ans: Dirty Read is bassically a type of error its generate when two operations access in the same time for the example Two oprations says,read and write occurs togethergiving the incurrect.
6.What is Pivot and Unpivote?
Ans: A pivot table is bassically use for the sorting the table, and also doing the work in table like a counting and totalling the data which is stored in one table or spread sheet and its also creat the second table for the display the sumrized data,It can be turns the value of a specified column into column names, effectively rotating a table. but in case of Unpivote Its a exactly opposit to the pivote.
7. What is Catalouge Views?
Ans: Catalouge Views is basssically use for the returing the information, it is used by the SQL Server Database Engine.It is the very importnt general interface catalouge to the matadata and Its provide the most efficient way to obtain ,transform, and present costomised forms of this information .all user available catalouge matadata is exposed through catalouge views.
8.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
9.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
10.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.
11. 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
>
Ans: Properties of Sub-Query
1.A sub-query must be enclosed in the parenthesis.
2.A sub-query must be put in the right hand of the comparison operator, and
3.A sub-query cannot contain an ORDER-BY clause.
4.A query can contain more than one sub-query.
Types of Sub-Query
1.Single-row sub-query, where the sub-query returns only one row.
2.Multiple-row sub-query, where the sub-query returns multiple rows,. and
3.Multiple column sub-query, where the sub-query returns multiple columns
2.What is SQL Profiler?
Ans: SQL Profiler is a graphical tool that allows system administrators to monitor events in an instance of Microsoft SQL Server. You can capture and save data about each event to a file or SQL Server table to analyze later. For example, you can monitor a production environment to see which stored procedures are hampering performances by executing too slowly.
Use SQL Profiler to monitor only the events in which you are interested. If traces are becoming too large, you can filter them based on the information you want, so that only a subset of the event data is collected. Monitoring too many events adds overhead to the server and the monitoring process and can cause the trace file or trace table to grow very large, especially when the monitoring process takes place over a long period of time.
3.Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible?
Ans: Yes. Because Transact-SQL supports recursion, you can write stored procedures that call themselves. Recursion can be defined as a method of problem solving wherein the solution is arrived at by repetitively applying it to subsets of the problem. A common application of recursive logic is to perform numeric computations that lend themselves to repetitive evaluation by the same processing steps. Stored procedures are nested when one stored procedure calls another or executes managed code by referencing a CLR routine, type, or aggregate. You can nest stored procedures and managed code references up to 32 levels.
4.What is SQLCMD?
Ans: SqlCmd is bassically a very important for that SQL Server It can be work with two modes :
1. BATCH and
2. Intractive Mode
It is the Enhaceversion of isql which is depricated Eventuallyand osql which is not include in SQL Server 2005 RTM, It is the Better replacement of OSQL and ISQL. It provides way more functionality that other two options.
5.What is the Dirty Read?
Ans: Dirty Read is bassically a type of error its generate when two operations access in the same time for the example Two oprations says,read and write occurs togethergiving the incurrect.
6.What is Pivot and Unpivote?
Ans: A pivot table is bassically use for the sorting the table, and also doing the work in table like a counting and totalling the data which is stored in one table or spread sheet and its also creat the second table for the display the sumrized data,It can be turns the value of a specified column into column names, effectively rotating a table. but in case of Unpivote Its a exactly opposit to the pivote.
7. What is Catalouge Views?
Ans: Catalouge Views is basssically use for the returing the information, it is used by the SQL Server Database Engine.It is the very importnt general interface catalouge to the matadata and Its provide the most efficient way to obtain ,transform, and present costomised forms of this information .all user available catalouge matadata is exposed through catalouge views.
8.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
9.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
10.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.
11. 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
>
Posted in: 
0 comments:
Post a Comment