What is dense_rank in sql?

0 Answers  

---

how to get a list of all tables in a database? : Sql dba

0 Answers  

---

while loading data into database how can u skip header and footer records in sql*loader

1 Answers   Oracle,

---

What are the disadvantages of not performing database normalization?

0 Answers  

---

How to fetch records from a partitioned table?

2 Answers   HSBC,

---

---

Is drop table faster than truncate?

0 Answers  

---

What is diff between bulk collect and forall

3 Answers   Metric Stream,

---

Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

10 Answers   TCS,

---

What is a composite primary key?

0 Answers  

---

Is grant a ddl statement?

0 Answers  

---

Explain what is sql*plus?

0 Answers  

---

How do I count duplicates in sql?

0 Answers  

---