Answer Posted / shanmugavelu

suppose u have create partition table like,

Sql>Create table Pixel_emp_details(emp_no number,
emp_name varchar2(10))
partition by range (emp_no)
(partition pixel_p1 values less than(10));
Sql>/
Table is created

After that u have use normal insert statement like

Sql> insert into pixel_emp_details partition(pixel_p1)
values(1,'gopi')
SQL> /

1 row created.

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1982

---

What are the ansi data types supported in oracle?

942

---

What is the fastest query method to fetch data from the table?

1352

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1012

---

Difference between pre-select and pre-query

1095

---

What are temporal data types in oracle?

1111

---

Explain the use of Merge statement in oracle 11g

1020

---

Give the constructs of a package, function or a procedure.

1026

---

How to define an anonymous procedure with variables?

1145

---

What do you understand by a database object? Can you list a few of them?

1009

---

How to create a server parameter file?

1128

---

What privilege is needed for a user to connect to oracle server?

984

---

What are the different types of synonyms?

1125

---

How to login to the server without an instance?

1155

---

What is a read write transaction in oracle?

1072

---