What are the ddl commands?

0 Answers  

---

Can we group by two columns in sql?

0 Answers  

---

Name some usages of database trigger?

0 Answers  

---

What is meant by Materialized view?

2 Answers   iGate, Marlabs, Polaris,

---

Can we insert data in view?

0 Answers  

---

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---

what command is used to create a table by copying the structure of another table including constraints ?

6 Answers   CMC, eicc,

---

When would you denormalize?

8 Answers   MBT, Microsoft, MMU,

---

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

---

explain the difference between bool, tinyint and bit. : Sql dba

0 Answers  

---

what is self join and what is the requirement of self join? : Sql dba

0 Answers  

---

What is the most restrictive isolation level? : Transact sql

0 Answers  

---