Answer Posted / sree

pl/sql tables are temporary array like objects in pl/sql
block.pl/sql tables have one column and one primary key.the
size of pl/sql tables unconstrained i.e the number of rows
can be increased by dynamically

Explain the order of sql statement execution?

987

---

What is the purpose of the sql select top clause?

1034

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

966

---

Can sql function call stored procedure?

962

---

What is the reports view in oracle sql developer?

934

---

What is the function that is used to transfer a pl/sql table log to a database table?

960

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

902

---

What is record data type?

865

---

what is foreign key? : Sql dba

977

---

How many sql statements are used? Define them.

989

---

How is data stored in sql?

1007

---

what is a relationship and what are they? : Sql dba

1037

---

What is the difference between count 1 and count (*) in a sql query?

921

---

can a stored procedure call itself or recursive stored procedure? : Sql dba

967

---

What is a column in a table?

1072

---