What is Schema in Database?

1 Answers   Cap Gemini,

---

please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 Answers  

---

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

---

How many categories of functions based their return modes?

0 Answers  

---

Explain how many normalization forms?

0 Answers  

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

0 Answers  

---

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  

---

What is DAC? what is the use of it?

1 Answers   Wipro,

---

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 Answers  

---

What are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

Call by value and call by reference in procedure and function, with NOCOPY.

0 Answers   Nagarro,

---

Advantages and Disadvantages of Cursor?

15 Answers   Polytechnic, TCS, Zenith,

---