What is the parameter mode that can be passed to a procedure?

0 Answers  

---

What does a Control file Contain ?

2 Answers  

---

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 Answers  

---

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

1 Answers  

---

How do we know whether an index is created on a table ???

2 Answers   TCS,

---

Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?

2 Answers  

---

Differnce between view and index

3 Answers  

---

Explain about your project and its relation to the current job position you are applying to?

0 Answers  

---

Explain enable novalidate constraint.

0 Answers  

---

Explain the use of grant option in exp command.

0 Answers  

---

What is the difference between count (*), count (expression), count (distinct expression)?

0 Answers  

---

Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

4 Answers   JPMorgan Chase,

---