Answer Posted / vijay_1994

declare
cursor
user defined exception
variable
begin
sql statement
plsql statement (application wise/business logic)
exception
end;

What is a primary key called that is made up of more than one field?

793

---

What is rollback?

581

---

How to sort the rows in sql.

600

---

Mention what are the benefits of pl/sql packages?

534

---

Is not null in sql?

560

---

---

What is replication id?

518

---

Why do we use procedures in pl sql?

518

---

Is record in pl sql?

515

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

770

---

What is use of trigger?

510

---

What is sequence in sql?

506

---

How do I create a memory optimized filegroup?

527

---

how to fetch alternate records from a table? : Sql dba

592

---

What is an intersect?

650

---

what is oracle database ? : Sql dba

557

---