Answer Posted / shivainduja

An explain plan is a representation of the access path that
is taken when a query is executed within Oracle.

SQL> explain plan for select * from emp2;

Explained.

SQL> select * from table (DBMS_XPLAN.display);

PLAN_TABLE_OUTPUT
-------------------------------------
Plan hash value: 2941272003

--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost
(%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 15 | 570 | 3
(0)| 00:00:01 |
| 1 | TABLE ACCESS FULL| EMP2 | 15 | 570 | 3
(0)| 00:00:01 |
--------------------------------------------------------------------------

8 rows selected.

Explain what is a view?

997

---

What are transaction and its controls?

967

---

What are the different sql languages?

985

---

Explain the uses of control file.

990

---

what is a tablespace? : Sql dba

1004

---

what are the different functions in sorting an array? : Sql dba

967

---

How is use pl and sql?

1000

---

What is crud diagram?

877

---

What is a .db file?

926

---

What is cold data?

897

---

what are tables and fields? : Sql dba

988

---

State some properties of relational databases?

1001

---

What are the possible values that can be stored in a boolean data field?

947

---

How do rank () and dense_rank () differ?

974

---

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

992

---