Answer Posted / guest

An integrity constraint defines a business rule for a table
column which automatically takes care by Oracle internally.
Intefrity Constraints are NOT NULL,UNIQUE,CHECK ,PRIMARY
KEY,FOREIGN KEY.


A database trigger is a procedure written in PL/SQL and
Will run implicitly when data is modified or when some user
or system actions occur.Triggers are database objects which
gets stored in database and get fires when INSERT or UPDATE
statement attempts to violate the integrity rule, Oracle
must roll back the statement and return an error if trigger
exists.Database triggers are BEFOR/AFTER/{BEFORE|AFTER}
{row|statement etc.

What is the clause we need to add in function body to return variable?

975

---

how can we find the number of rows in a table using mysql? : Sql dba

1036

---

What is data definition language?

1050

---

What is number function in sql?

921

---

Why left join is used in sql?

925

---

Explain what is table in a database?

1016

---

What does truncate mean in sql?

966

---

What is the trigger in sql?

910

---

What is rename command in sql?

960

---

Why is sql important?

1034

---

What are the advantages of pl sql?

1078

---

what are the different type of normalization? : Sql dba

977

---

What is the command used to fetch first 5 characters of the string?

1342

---

what are the advantages and disadvantages of views in a database? : Sql dba

1002

---

how to enter characters as hex numbers? : Sql dba

998

---