What the different components of Replication and what is their use?

1068

what is a join? : Sql server database administration

1247

Define full outer join in sql server joins?

989

What is the difference between ddl,dml and dcl commands?

1112

What is an example of a foreign key?

975

Can select statements be used on views in ms sql server?

1065

Which table keeps the locking information?

922

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1010

What is a linked server in sql server?

1075

What does the on delete cascade option do?

1017

How is table type constraint applied to a table?

979

How many databases can we create in a single server?

207

What is wide table?

948

in the physical file layout, where should the transaction log be stored in relation to the data file?

994

How to delete exactly duplicate records from a table?

1063