difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,

---

What is the difference between rename and alias?

0 Answers  

---

If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

3 Answers  

---

What are local and global Indexes and where they are useful.

0 Answers  

---

What types of commands can be executed in sql*plus?

0 Answers  

---

---

What is the difference between union and union all command?

0 Answers  

---

What is the difference between the conventional and direct path loads? : aql loader

0 Answers  

---

Mention what are the benefits of pl/sql packages?

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 are the uses of sysdate and user keywords?

0 Answers  

---

How many subqueries can be nested in a statement?

0 Answers  

---

How many aggregate functions are available there in sql?

0 Answers  

---