Answer / kiran r

NO SQL VIEWS ARE NOT GONNA COMPILED AS APROCEDURE

Does truncate remove indexes?

0 Answers  

---

Define join and name different types of joins?

0 Answers  

---

What is the difference between mdf and ndf files?

0 Answers  

---

What is row_number () in sql?

0 Answers  

---

Can we join more than 2 tables in sql?

0 Answers  

---

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

0 Answers  

---

Which are the different types of indexes in sql?

0 Answers  

---

What is bulk compiling in pl/sql.?

0 Answers   MCN Solutions,

---

What is normalization and types of normalization?

22 Answers   Etisbew, F-TEC, Microsoft, TechProcess,

---

What are all the different normalizations?

0 Answers  

---

What is the difference between distinct and unique in sql?

0 Answers  

---

Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 Answers  

---