Answer Posted / madhuri

%type and %rowtype provides data independence,reduces
maintainance cost and allows programs to adapt as the
database changes due to new business requirements.

%rowtype is used to declare a record with the same types as
found in the specified database table,view or a cursor.

%type is used to declare a field with the same type as found
in the specified table's column.

What is a primary key? Explain

538

---

How much does sqlite cost?

553

---

What is sql data?

546

---

Why do we use joins?

563

---

What is before trigger?

550

---

---

Is primary key a clustered index?

533

---

What is the source code of a program?

505

---

Explain what is sql?

606

---

What is graph sql?

524

---

what is a trigger in mysql? : Sql dba

599

---

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

522

---

What is replication id?

518

---

Is nosql relational?

546

---

What is output spooling in sql*plus?

549

---

give the syntax of grant and revoke commands? : Sql dba

610

---