What are the types of model in sql server and explain

Question Posted / mirjawad

Answers were Sorted based on User's Feedback

What are the types of model in sql server and explain..

Answer / laxman

i think that may be recovery model

simple
bulk-loged
full

Is This Answer Correct ?

4 Yes

1 No

What are the types of model in sql server and explain..

Answer / yjreddy

there are 3 types

full
simple
bulk logged

Is This Answer Correct ?

0 Yes

0 No

More SQL Server Interview Questions

What are rows and columns?

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?

Explain about builtinadministrator?

How do I partition a table in sql server?

What will happen if a column containing char type data is changed to the nchar data type?

In clustered and non clustered indexes which one is faster while executing a query ?

Can I run multiple instances of sql server 2000 at the same time on one computer?

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

What is the command used to recompile the stored procedure at run time?

Explain important index characteristics?

what is the different types of backups available in sql server? : Sql server database administration

How can you find out which stored procedures are recompiling?

For more SQL Server Interview Questions Click Here