In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---

What is execution plan in sql?

0 Answers  

---

What is bulk compiling in pl/sql.?

0 Answers   MCN Solutions,

---

What is a sql profiler?

0 Answers  

---

How many rows will return from dual table?

4 Answers   Fujitsu,

---

How to use sql*plus built-in timers?

0 Answers  

---

Why do we use sql constraints? Which constraints we can use while creating database in sql?

0 Answers  

---

In a package if we have 10 procedures or functions,How to know which will execute first?

1 Answers   Sollet Soft,

---

Is sql scripting language?

0 Answers  

---

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

4 Answers   CGI, IBM,

---

What is the benefit of foreign key?

0 Answers  

---

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

---