Answer Posted / richa

In pl/sql we have two types of datatypes
1. scalar
2. composite.

In scalar u can store only one value at a time and
ex is a number(10),name char(1) etc.

While in Composite u can store whole row mean if one row
have 3 columns so u can store 3 values in a composite
datatype variable at a time.
Ex. emp employees%rowtype ;
Mean if enployees have 3 columns so in variable emp u can
store 3 values of 3 columns at a time .

How many anonymous blocks can be defined?

1104

---

Difference between varchar and varchar2 data types?

1118

---

Can you assign multiple query result rows to a variable?

933

---

Can we insert data in view oracle?

963

---

Can we commit inside a function in oracle?

920

---

Explain the use of consistent option in exp command.

974

---

How to create a server parameter file?

1081

---

What is bulk copy or bcp in oracle?

1046

---

Which is faster join or subquery in oracle?

934

---

What are the oracle built-in data types?

1011

---

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2251

---

Explain how you would restore a database using RMAN to Point in Time?

2098

---

How can you use check constraints for self referential integrity?

920

---

What are the different types of failures that occur in Oracle database?

1016

---

What is the scope of a local variable?

998

---