Answer Posted / avi007

We can create a user defind datatype by using abtract
datatype.

create type address_type as object
( street varchar2(10),
pincode number(6);
);

This is used in

create table emp
(Empname varchar2(20),
Adress address_type);

// address_type is user defined datatype

What is difference between table and view?

1054

---

Explain architecture of sql server notification services?

1059

---

Why do we use subquery?

1012

---

What is the best partition size for windows 10?

1001

---

Does sql between include endpoints?

1009

---

How do you pronounce sql?

1008

---

Why do we use procedures?

955

---

What is clustered index in sql?

1051

---

Is sql better than access?

1014

---

Is sql a backend language?

1092

---

What is the difference between sql and isql*plus?

1094

---

What are views in sql?

987

---

How do I view a table in sql?

1006

---

Advantages and disadvantages of stored procedure?

1122

---

How does a trigger work?

1067

---