What are views in sql?

0 Answers  

---

What does the hierarchical profiler does?

0 Answers  

---

Can we use out parameter in function?

4 Answers   Infosys,

---

Explain the uses of control file.

0 Answers  

---

What is a cursor ? Why Cursor is required ?

3 Answers  

---

---

Explain the select statement in sql?

0 Answers  

---

Does truncate require commit?

0 Answers  

---

What is the advantage of index in sql?

0 Answers  

---

Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

15 Answers   Satyam,

---

what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?

1 Answers   Metric Stream,

---

What is Highwatermark?

3 Answers   Thermotech,

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---