Answer Posted / manoj

IN- It will return the value based on the parameter;
e.g. select * from emp where salary in ('1000','3000');

ANY-It will compare with any value that has been returned by
the parameter;

select * from emp where salary > any(select salary from emp
where deptno=10)
the salary will be compared with any value that has been
returned by the subquery.

ALL-It will compare with max/min value that has been
returned by the subquery;

select * from emp where salary > all(select salary from emp
where deptno=10)
the salary will be compared with the longest value that has
been returned by the subquery.

Can we rollback after truncate?

1033

---

How do I order columns in sql?

1012

---

How does rowid help in running a query faster?

1417

---

what are myisam tables? : Sql dba

1032

---

Explain what is table in a database?

1062

---

Explain the difference between sql and mysql.

1066

---

What is the maximum size of sqlite database?

1112

---

What is a data definition language?

1139

---

Is sql developer case sensitive?

1003

---

What do you understand by pl/sql records?

1021

---

How do you define a foreign key?

1008

---

What is a .db file?

988

---

how to use regular expression in pattern match conditions? : Sql dba

1035

---

Explain about various levels of constraint.

949

---

Can we join two tables without common column?

1010

---