Answer Posted / jebastin unnatha raja

Joins-> Joins allow You to view and retrive the data from multible related tables in a single result set.

Primary key-> A primary key is used to uniquely identify each row in a table.A primary key columns can not contain a nULL values.

foriegn key-> A foreign key is a field (or fields) that points to the primary key of another table. The purpose of the foreign key is to ensure referential integrity of the data

super Key-> A superkey is a combination of attributes that can be uniquely used to identify a database record. A table might have many superkeys.

Candidate key-> A candidate key is one that can identify each row of a table uniquely. Generally a candidate key becomes the primary key of the table.

Do you know what is bit data type and whats the information that can be stored inside a bit column?

940

---

Explain trigger classes i.e. Instead of and after trigger?

859

---

What is the sql case statement used for?

1076

---

What are unicode character string data types in ms sql server?

1213

---

Explain tablesample?

978

---

Tell me what is de-normalization and what are some of the examples of it?

993

---

What is RMS migrations?

2120

---

what method you can use to reduce the overhead of Reporting Services data sources?

250

---

How to create a store procedure with encryption?

982

---

What are the different types of sub-queries?

1026

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

1567

---

How to create a view using data from another view?

938

---

Explain steps of normalization?

973

---

Explain timestamp datatype?

946

---

What is normalization 1nf 2nf 3nf?

1040

---