What is bcnf normalization form?

0 Answers  

---

What is the most common type of join?

0 Answers  

---

Which databases are part of SQL server default installation? Explain the usage of each?

2 Answers   Accenture,

---

What is the security principal at the database level that represents your session?

0 Answers  

---

How to see existing views in ms sql server?

0 Answers  

---

---

What do you understand by a view?

0 Answers  

---

What is the difference between varchar and nvarchar?

0 Answers  

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

What is subquery? Explain the properties of a subquery?

0 Answers  

---

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

13 Answers   Patni,

---

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

0 Answers  

---

How can a user-defined datatype be created?

0 Answers  

---