Answer Posted / amar_kondla

select * from emp----- is a query;


and

co-related query is sub one of sub qury( sub qury
means--whose returning values are filtering the condition
of the main query)
ex; SELECT * FROM EMP E
WHERE E.SAL>( SELECT AVG(SAL) FROM EMP F
WHERE E.DEPTNO= F.DEPTNO);


SO HERE WE R FINDING THE EMPLOYEE WHO HAS GETTING MORE THAN
AVG(SAL) OF RESPECTING DEPTNO.

AND CO RELATED SUB QUERY ALWAYS USE ALIAS NAME FOR TABLE, IT
SIMILAR LIKE JAIN(SELF JOIN)

What is rtm stands for?

671

---

What does the acronym acid stand for in database management?

672

---

Is sql developer case sensitive?

635

---

how to decrement dates by 1 in mysql? : Sql dba

676

---

how to do backup entire database? : Transact sql

773

---

---

explain access control lists. : Sql dba

633

---

What does := mean in pl sql?

654

---

what is a control file ? : Sql dba

659

---

How to run sql commands in sql*plus?

684

---

Why use stored procedures?

685

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

667

---

What are the dml statements?

775

---

Is primary key is clustered index?

612

---

Mention what is the use of function "module procedure" in pl/sql?

689

---

what is sql profiler? : Sql dba

681

---