Answer / valli

where startwith having

Can you drop an index associated with a unique or primary key constraint?

0 Answers  

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

---

Explain about functional dependency and its relation with table design?

0 Answers  

---

how to find the second highest salary in a given table????

5 Answers  

---

What are advantages fo Stored Procedures?

1 Answers  

---

SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me

6 Answers   TCS,

---

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6

2 Answers   TCS,

---

State the difference between a primary key and foreign key?

0 Answers  

---

you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??

2 Answers   BirlaSoft,

---

What is the relation of a user account and a schema?

0 Answers  

---

Please explan Why static query is more faster than dynamic query ?

2 Answers  

---

Can we store pictures in the database and if so, how it can be done?

0 Answers  

---