Answer / kiran r

Yes Index Improves performance of Query

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

0 Answers  

---

What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

3 Answers   TCS,

---

what is the difference between union and union all? : Sql dba

0 Answers  

---

What is the difference between a primary key and a clustered index?

0 Answers  

---

when normalization is required

3 Answers   HCL,

---

How many types of primary keys are there?

0 Answers  

---

Write the alter statement to enable all the triggers on the t.students table.

0 Answers  

---

What is difference between select statement and cursor

3 Answers   JDA,

---

Are pl sql variables case sensitive?

0 Answers  

---

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

---

What is multiple partition?

0 Answers  

---

1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins

6 Answers   Sonata,

---