Answer / Vishal Prayani

A System Database is a set of databases created during the SQL Server installation process, which are used by SQL Server to manage its own internal tasks. Examples include 'master', 'model', 'msdb', 'tempdb'. A User Database is any database created for end-user applications or data storage purposes. These databases are owned and managed by users other than the system administrator.

What is oltp (online transaction processing)?

1 Answers  

---

What is similarity and difference between truncate and delete in sql?

1 Answers  

---

Can sql server 2016 run on windows 7?

1 Answers  

---

Can sql server be linked with other servers like oracle?

1 Answers  

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1 Answers  

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1 Answers  

---

In the primary key have a multiple field or not?

8 Answers   TCS,

---

Introduction of rollup clause using sum and group by clause?

1 Answers  

---

Determine how to use the inserted and deleted pseudo tables?

1 Answers  

---

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

6 Answers   Broadridge,

---

What is the command used to get the version of sql server?

1 Answers  

---

How to replace null values in expressions using isnull()?

1 Answers  

---