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;

What is an Oracle Instance?

1122

---

How to count groups returned with the group by clause in oracle?

1077

---

How many types of table in Oracle?

1124

---

what is reindexing?

1678

---

How to create a new view in oracle?

1078

---

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1786

---

How to update values on multiple rows in oracle?

1034

---

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2051

---

What is a sub query and what are the different types of subqueries?

1125

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2133

---

What is raw datatype?

1136

---

How to use values from other tables in update statements using oracle?

1080

---

Explain the function of optimizer in oracle?

1143

---

How to get a list of all background sessions in the database?

993

---

Difference between varchar and varchar2 data types?

1184

---