Answer Posted / suman

IN- The parameter can be referenced by the procedure or
function. The value of the parameter can not be overwritten
by the procedure or function.

OUT- The parameter cannot be referenced by the procedure or
function. The value of the parameter can be overwritten by
the procedure or function.

INOUT- The parameter can be referenced by the procedure or
function. The value of the parameter can be overwritten by
the procedure or function.

Can a commit statement be executed as part of a trigger?

1048

---

How to display the current date in sql?

1071

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1037

---

Can we perform dml in function?

1063

---

define sql delete statement ? : Sql dba

1014

---

Are left and right joins the same?

1078

---

what is primary key? : Sql dba

1023

---

How many sql commands are there?

1114

---

What is coalesce in sql?

1051

---

What is the process of debugging?

1064

---

what is 'mysqldump'? : Sql dba

1108

---

how to enter characters as hex numbers? : Sql dba

1035

---

What is raid? How does it help storage of databases?

1079

---

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

1041

---

What are the types of operators available in sql?

1060

---