Answer Posted / shilpa.oracle

Yes, we can relate tables of different schemas provided we
should have privileges on that table

create table test_emp
(empno number(5),deptno number(5),constraint dept_ref
foreign key (deptno) references schema.dept(deptno))

difference between anonymous blocks and sub-programs.

1095

---

explain the advantages and disadvantages of stored procedure? : Sql dba

971

---

Explain the difference between rename and alias?

984

---

What are sql ddl commands?

1053

---

Is sql a scripting language?

943

---

Why do we use joins in sql?

927

---

Does sql*plus also have a pl/sql engine?

1046

---

State few characteristics of pl/sql?

944

---

How does sql*loader handles newline characters in a record? : aql loader

1007

---

What are functions in sql?

924

---

List the ways to get the count of records in a table?

875

---

what are the join types in tsql? : Transact sql

1015

---

What are the popular database management systems in the it industry?

944

---

Can you have a foreign key without a primary key?

920

---

What is sql procedures and functions?

974

---