Answer / pradeep

Schema is a logical set of data. It contains tables, views,
Packages, constraints. This is treated as a whole database.
This has assigned with a unique id called as SID i.e.
System ID. Because of this ID one can create n number of
DBs on a single DB server. Obviously within the limit of
the hardware of DB server.

What is scheduled job and how to create it?

0 Answers  

---

What are the tool windows in sql server management studio? : sql server management studio

0 Answers  

---

What is ms sql server triggers?

0 Answers  

---

Can you roll back the ddl statement in a trigger?

0 Answers  

---

How can you find out how many rows returned in a cursor?

0 Answers  

---

---

How would we use distinct statement? What is its use?

0 Answers  

---

write sql program to get the detail of student in a class?

2 Answers  

---

What are the requirements for sql server 2016?

0 Answers  

---

What is an entity-relationship diagram (erd)?

0 Answers  

---

How many primary keys are possible in a table?

0 Answers  

---

Can we call stored procedure in trigger?

0 Answers  

---

Whether the updations made to the views reflect the original records in the table

5 Answers   NIIT,

---