Answer Posted / hannan oca

collection of similar datatypes or group of same datatypes
are called collections.Basically they are 3 types
1.Index-by tables,
2.Nested tables
3.Varrays
collection of different datatypes are known as Records.

Explain the difference between triggers and constraints?

1023

---

What are the qualities of 2nf?

1096

---

What is a ddl command?

1154

---

What is %s in sql?

1076

---

What are sql built in functions?

979

---

What is benefit of creating memory optimized table?

1032

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1086

---

How do I order by ascending in sql?

1078

---

What are the differences between implicit and explicit cursors?

1109

---

Can I create table without primary key?

1044

---

How can you create an empty table from an existing table?

1127

---

What is a sql trace file?

1085

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4058

---

how to see the create table statement of an existing table? : Sql dba

1058

---

what are all different types of collation sensitivity? : Sql dba

1028

---