1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

Polaris,

6 14814

explain different types of jions with examples briefly?

Zensar,

1 5675

explain different types of jions with examples briefly?

Accenture, Excellence, Zensar,

2 7720

explain different types of jions with examples briefly?

Zensar,

3 9249

can we call functions from stored procedure in SQL Server 2005 ? How?

 3 10781

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

HP,

17 45235

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

 3 4597

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

 5 6227

Difference between Triggers and Stored Procedure

Claimat, HCL, Protech, Silgate,

23 66829

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

 6 5588

How to list all tables having unique constraints in any of the columns in a database.

 1 3878

Advantages and Disadvantages of Cursor?

Polytechnic, TCS, Zenith,

15 95359

Write a query to delete duplicate records in SQL SERVER

Infosys,

36 67404

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

 6 7923

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

 8 7165

Un-Answered Questions { SQL Server }

What do you understand by triggers?

512

How to backup encryption key ?

123

How to see the event list of an existing trigger using sys.trigger_events?

560

What is difference between join and natural join?

470

what are candidate key, alternate key and composite key? : Sql server database administration

485




What is a trace frag?

628

What is filtered index?

645

How can you tell if a database object is invalid?

604

What is the difference between the 2 operating modes of database mirroring?

570

When does a workload on SQL Azure get throttled?

113

How to disable a login name in ms sql server?

580

What is identity?

540

Why the trigger fires multiple times in single login?

715

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

559

What are the types of subscriptions in SQL Server replication?

539

For More Un-Answered { SQL Server } Questions Click Here