SHIVPRASAD KOIRALA .NET INTERVIEW QUESTIONS 6TH EDITION PDF FREE DOWNLOAD? : YES GET FREE HARDCOPY

I am in my final year of engineering
I need this book on the first preference.

Email:gshashi239@gmail.com

This comment has been removed by the author.

hi Sir i am regular reader of your website for interview questions and i have selected in HCL
thanking you for providing a good platform for preperation of interview but i have some queries for SQL
these are given below.
1.Q select 8*8 from employee
2.Q which join is fast
A.Inner join
B.Left Outer Join
C.Cross Join
D.right outer join
????
3.Question select (8+2,7) from Student table

???
4.Whats the Output of these queries

select (8*2+'a') from student

select (8+2) from student

select * from (select 1 as abc ) abc

select * from (select 1 abc)

5. Question : How to display coma separated value in different column (i have a cell which have values like [a,b,c,d,e,f]) now i want output like

a b c d e f

Answers : Hi sir i have emailed all questions answers in details please check it

@@@@@@@@@
@@@@@@@@@ Manish Kumar
Congrats!!!!!!!!! You are selected as a winner,

We like your Sql Query interview questions/answers set...
But lot of diff. in the questions which you posted here as a comment and the well mannered/written questions set (5) which you sent me by email.
I like the well written questions set which you sent me by email, which you posted here is need some improvement... so always post best/well written set.
Anyway... you has won the book, I have order it to your address.. Please check and confirm me...

Please send it to me at gshashi239@gmai.com

Shashi

First of all thanks for giving me book i am so exited that as you announced me winner
I have also need of your help as i want to learn ssis and ssrs so please write some artical on these topic

Hi Please send those questions (sql questions) along with the answers to fawaz.ahmed157@gmail.com

1) What is Using Common Table Expressions?

Answer : A common table expression (CTE) can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. A CTE is similar to a derived table in that it is not stored as an object.
A CTE can be self-referencing and can be referenced multiple times in the same query.

Example

;WITH expression_name [ ( column_name [,...n] ) ]
AS
( CTE_query_definition )
Example
USE AdventureWorks2008R2;
GO
-- Define the CTE expression name and column list.
WITH Sales_CTE (SalesPersonID, SalesOrderID, SalesYear)
AS
-- Define the CTE query.
(
SELECT SalesPersonID, SalesOrderID, YEAR(OrderDate) AS SalesYear
FROM Sales.SalesOrderHeader
WHERE SalesPersonID IS NOT NULL
)
-- Define the outer query referencing the CTE name.
SELECT SalesPersonID, COUNT(SalesOrderID) AS TotalSales, SalesYear
FROM Sales_CTE
GROUP BY SalesYear, SalesPersonID
ORDER BY SalesPersonID, SalesYear;
GO

2) Can you explain about buffer cash and log Cache in sql server?


Answer :

Buffer Cache: Buffer cache is a memory pool in which data pages are read. It performance of the buffer cache is indicated as follows: 95% indicates that pages that were found in the memory are 95% of time. Another 5% is needed for physical disk access.

If the value falls below 90%, it is the indication of more physical memory requirement on the server. Log Caches: Log cache is a memory pool used to read and write the log pages. A set of cache pages are available in each log cache. The synchronization is reduced between log and data buffers by managing log caches separately from the buffer cache.

3)What is a Trace frag? Where do we use it?


Answer :
Temporary setting of specific server characteristics is done by trace tags. DBCC TRACEON is the command to set the trace flags. Once activated, trace flag will be in effect until the server is restarted. Trace frags are frequently used for diagnosing performance issues. For example, the trace flag 3205 is used for disabling hard compression for tape drives, when an instance of SQL Server starts.


4)Explain how to store pdf file in sql server

Answer : Create a column as type ‘blob’ in a table. Read the content of the file and save in ‘blob’ type column in a table. Or store them in a folder and establish the pointer to link them in the database.

5)What are the advantages and disadvantages of merge replication?

Answer :

Advantages

It provides built-in and custom conflict resolution capabilities.
It allows for the synchronization of data from multiple tables at one time.
It provides rich data replication options like selection of article types and filtering and identity range management.

Disadvantages
Merge replication requires more configuration and maintenance at the server

Download shivprasad koirala's MVC interview question for the same

http://www.codeproject.com/Articles/556995/ASP-NET-MVC-interview-questions-with-answers

sir i am from Extc background steal i want to make my carrier in .net so plz give me idea what should i do and so i can get a job

Hello Sir
I am regular reading of your website and book for interview questions.I have good experience and motivate to do smart work.Thanks sir for providing the good platform.

Maulik Gohel.(maulikgohel166@gmail.com)

Send me pdf version of this book at
cloudxack@gmail.com

msraju56@gmail.com

Ahsansrf@gmail.com
Ur book is really helpful thank you