Answer Posted / shanmukha srinivas

procedure can run in sql block like
begin
sp_procedure_name(input parameters);
end;
function can run in sql block like
select sf_function_name(input paramters)

Is it possible for a table to have more than one foreign key?

586

---

what is subquery? : Sql dba

576

---

Can we create a trigger on view?

491

---

Explain what is dbms?

583

---

What is an inconsistent dependency?

583

---

---

What are the types of subqueries?

577

---

What is an exception in PL/SQL? What are the two types of exceptions?

633

---

What is the difference between an inner and outer join?

543

---

How to rename a column in the output of sql query?

539

---

Can 2 queries be executed simultaneously in a distributed database system?

649

---

What is a system versioned table?

538

---

Can we insert delete data in view?

548

---

What is a mutating table and a constraining table?

575

---

How many types of literals are available in pl sql?

522

---

How do you select unique values in sql?

504

---