Sql Server Interview Questions and Answers (1758) - Page 48

Latest and authentic Interview questions. You can also post an interview question and win monthly prizes as well as gain community credit points.

1758 records found.

Interview Experiences |

Interview FAQs |

Online Interviews |

Exclusive Questions

Get 650+ Questpond's Interview videos on discount

When does below error occur? Msg 208, Level 16, State 1, Line 1 Invalid object name 'dbo.employee_master'.

When we have not set DB, in which the associated table has been created.Then we must set DB first,then we can use query.For setting DB,we can have "USE" keyword followed by DB_Name as shown below:-

Use DB_Name
Select * from db.employee_master;

Then above error will not come, and query will produce result.

Can we have WHERE CLAUSE in SELF JOIN?

Yes. We can write Where Clause in Self Join. As self join joins table itself. So it will produce result based on condition,which we supply in where clause.

For example:-

Select * from employee_master a,employee_master b where a.employee_id = b.employee_id;

How to create Table without using Create Statement?

With the help of Select * Into statement, we can create new table along with rows.

For ex:-

Select * into test from employee_master;

What will be the output of below query? select try_parse('111' as int) as 'Number1',try_parse('222.000' as int) as 'Number2',try_parse(.abcD1234E.000' as int) as 'Number3';

NOTE: This is objective type question, Please click question title for correct answer.

What will be the output of below query? select * from employee_master; go select top 100 percent * from employee_master; If employee_master is having 100 records; go

Both query will give us the same record means 100 records will be displayed.
100 percent means total records.

What will be the output of below query? Select Top 50 Percent * From Employee_Master; If Employee_Master is having 11 record.

NOTE: This is objective type question, Please click question title for correct answer.

What will be the output of below query? Select Top 50 * From Employee_Master Order by employee_id desc; If Employee_Master have only 25 records.

NOTE: This is objective type question, Please click question title for correct answer.

How to execute below stored procedure? create procedure load_employee_details as Go begin select * from employee_master where status = 'AA'; end

With the help of EXEC in-built SQL Server function we can Execute any user defined Stored Procedures as well as system Stored Procedures.

Syntax is:-

Exec <procedure_name>(parameter_name1,parameter_name2,.....);

For above SP,we will write:-

Exec load_employee_details;

Press F5 to execute SP.

What will happen,if we run below query? Select Round(employee_name,0) from employee_master; Here,column_name 'employee_name' is a Varchar(50) datatype in employee_master table.

NOTE: This is objective type question, Please click question title for correct answer.

What will be the output of below query? Select Round(rate,0) From Opportunity_Creation; If Opportunity_Creation contains 2 rows in Rate column as 200.50,101.00

NOTE: This is objective type question, Please click question title for correct answer.

How can you run a job using SQL Server Agent?

NOTE: This is objective type question, Please click question title for correct answer.

How to delete the CLR assembly from SQL Server

NOTE: This is objective type question, Please click question title for correct answer.

What is the purpose of msdb in SQL server?

msdb is a system database available in SQL Server, mainly used by SQL Server Agent to schedule jobs, creating alerts to get the status from jobs and recording operators.
Scheduling information used by SQL Server Agent will be lost in the case of msdb corruption. In turn results to the failure of all scheduled activities.

Microsoft have renamed the tool which provided an IDE for building solutions for the Business Intelligence components in SQL 2008: Analysis Services, Reporting Services, and Integration Services. What is the name of this tool in SQL Server 2012?

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following is a component of SQL Server Agent?

NOTE: This is objective type question, Please click question title for correct answer.

What is the purpose of MODEL database?

model is a system database which is available in SQL server. It is used as a template for future user-defined databases. whenever you supposed to create a database in SQL Server model database will provide some default configurations/options.
To check the same thing do the following:
1) Change Recovery Model of model database to FULL ( SQL Server object explorer--> access model db properties --> go to Options Page )
2) Create one sample stored procedure in model database
3) Then, Create new database in SQL Server
4) Now you will get to know that your newly created database will have sample SP which is created in model database and also check the recovery model too

Which of the following is NOT stored in the master database?

NOTE: This is objective type question, Please click question title for correct answer.

DECLARE @UntPrice MONEY = 12345.6789; SELECT FORMAT(@UntPrice, 'C', 'en-US'); What is the output of the above statement

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following functions is a new logical function introduced in SQL Server 2012?

NOTE: This is objective type question, Please click question title for correct answer.

How to write recursive query in SQL Server?

NOTE: This is objective type question, Please click question title for correct answer.

1
...
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
...
88

More SQL SERVER Exclusive Interview Questions & Answers here

Found this useful, bookmark this page to the blog or social networking websites.

GooglePlus

StumbleUpon

Delicious

Reddit

Email

Bookmark It

Interview Questions and Answers Categories

.NET Certifications

ASP.NET Web API

Data Structures & Algorithms

Design Pattern & Practices

DotNetFunda.Com

Entity Framework

Error and Solution

Function Points (FPA)

Interview Questions

Mobile Development

MSBI (SSIS, SSRS, SSAS)

News and Community

Product Reviews

Project Management

Regular Expressions

Web Services, Remoting