Answer / neha_gupta

The index for a table is selected , if there is a column
which is getting repetedly called in your queries.
On the data of the table the type of index can be selected.

Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.

0 Answers   Amazon,

---

What is the difference between data source and database?

0 Answers  

---

Is it possible to update AS400 database record while reading it with no lock

1 Answers  

---

what is the role of auditor in auditing data oriented applications?

0 Answers  

---

define primary key index, bitmap index, hash index,virtual indwx

0 Answers   Cap Gemini,

---

---

how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.

0 Answers  

---

hai i want to learn oracle apps and i want to put the fake exp of one year so could you please suggest me which is best institute in hyderabad to learn oracle with real time project experience?

2 Answers  

---

can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?

0 Answers  

---

What is replicaset?

0 Answers  

---

Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.

0 Answers   Amazon,

---

What do you mean by foreign key and primary key?

0 Answers   Zensar,

---

What are different types of blocks used in stored procedure?

0 Answers   C DAC, CDAC,

---