Answer Posted / raffi.shaik

Primary key is unique
primary key is not NULL and

foreign key is NULL
foreign key reference as Primary key in another table

Primary key is unique key but foreign key always refers to
primary key

primary key is used to identify a row and it does not allow
null values. It avoids duplication of rows.

whereas foreign key refers to a column or combination of
columns included in the definition of referential integrity.

In the context of relational databases, a foreign key is a
referential constraint between two tables.[1] The foreign
key identifies a column or a set of columns in one
(referencing) table that refers to a column or set of
columns in another (referenced) table. The columns in the
referencing table must form a primary key or unique key.

Explain the difference between a procedure and a function? What do you understand by those terms?

1134

---

How to create an oracle testing table?

1126

---

What is raw datatype?

1188

---

What is materialized view in Oracle?

1114

---

What types of joins are used in writing subqueries?

1030

---

Explain mutating triggers.

1088

---

Whats the benefit of dbms_stats over analyze?

2064

---

How to Truncate Table in Oracle

1211

---

How to execute a stored program unit?

1128

---

How to delete an existing row from a table in oracle?

1129

---

How to estimate disk space needed for an export job?

1105

---

How to delete multiple rows from a table in oracle?

1114

---

How to assign a tablespace to a users in oracle?

1088

---

What is the usage of merge statement?

1202

---

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

2007

---