Answer Posted / durgarao k

There are two ways in specifying constraints
Table level and Column level
In your question you specified Foreign key constraint as column level constraint.so, at that time you write as
Create table Employee
(
Employee_Id varchar2(8) Constraint emp_id_pk primary key,
FirstName varchar2(50),
LastName varchar2(50),
DeptID Number(5)
Constraint dept_id_fk
References Department(DeptId)
)
if you want to specify Foreign key constraint at table level
you just do as
Create table Employee
(
Employee_Id varchar2(8) Constraint emp_id_pk primary key,
FirstName varchar2(50),
LastName varchar2(50),
DeptID Number(5),
Constraint dept_id_fk Foreign Key(DeptId)
References Department(DeptId)
)

Define oracle database

1025

---

How does the on-delete-cascade statement work?

1087

---

What is a sub query? Describe its types?

997

---

What happens if you lost a data file?

1027

---

What is merge statement used for?

1005

---

How do I find the database name in oracle?

1018

---

How to save query output to a local file?

1004

---

What is the difference between alert log file and tarce file ?

2150

---

Explain joins in oracle?

1022

---

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2030

---

What are the restrictions in a oracle read only transaction?

1007

---

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2298

---

How do I learn what codesets are available in oracle?

1026

---

Explain about integrity constraint?

1108

---

What is a snapshot in oracle database?

1003

---