Answer Posted / annu rajput

Data Dictionary contains the informartion about the objects
there are severel data_dictionary in oracle database
for infomation about the tables in database there is a
data dictionary called user_tables
we can get the information about all the tables using the
statement

select * from user_tables;

Explain the use of parfile option in exp command.

1134

---

What is columnar storage what is the advantage?

1119

---

How can windows applications connect to oracle servers?

1115

---

What is bulk collect in oracle?

1051

---

Explain view?

1081

---

What is the difference between a hot backup and a cold backup in oracle?

1072

---

What is ASM (Automatic Storage Management) in Oracle?

1240

---

How to divide query output into groups in oracle?

1029

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2383

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1432

---

What's dateware house and what's clustor with practicle example

2231

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2188

---

What are the attributes of the cursor?

1057

---

How to list all tables in your schema?

1112

---

What is a data dictionary and how can it be created?

1232

---