Answer Posted / welcomeashwin

PASS-BY-VALUE(FUNCTION)
1)All parameters must be write-only using the IN mode
2)Parameters are locally scoped that cannot be changed
3)Any parameters can use any valid SQL or PL/SQL datatype.
Only functions with parameter lists that use SQL datatypes
work with SQL statements.
4)Any IN parameter can have a default value
5)The formal return values can use any SQL or PL/SQL
datatype, but pipelined return tables must use SQL.
6)Any system cursor is not writeable and must be passed as a
IN parameter

PASS-BY-REFERENCE (FUNCTION)
1)You must have one parameter as read-only or read-write
2)All formal parameters are locally scoped variables that
you can change during operation inside the function
3)Any parameters can use any valid SQL or PL/SQL datatype.
Only functions with parameter lists that use SQL datatypes
work with SQL statements.
4)Any IN parameter can have a default value
5)The formal return values can use any SQL or PL/SQL
datatype, but pipelined return tables must use SQL.
6)Any system cursor is not writeable and must be passed as a
IN parameter

PASS-BY-VALUE (PROCEDURE)
1)All parameters must be write-only using the IN mode
2)Parameters are locally scoped that cannot be changed
3)Any parameters can use any valid SQL or PL/SQL datatype.
4)Any IN parameter can have a default value
5)Any system cursor is not writeable and must be passed as a
IN parameter

PASS-BY-REFERENCE (PROCEDURE)
1)At least one parameter must be defined as read-only or
read-write.
2)Parameters are locally scoped that can be changed
3)Any parameters can use any valid SQL or PL/SQL datatype.
4)Any IN parameter can have a default value
5)Any system cursor is not writeable and must be passed as a
IN parameter

What is the difference between unique and primary key constraints?

1066

---

What is vector point function?

1048

---

Can a primary key be a foreign key?

1018

---

What are sql indexes?

993

---

Name the different types of indexes in sql and define them.

1144

---

What is a file delimiter?

1083

---

What is nosql db?

964

---

What is the difference between the sql*loader and import utilities? : aql loader

1035

---

How can one get sql*loader to commit only at the end of the load file? : aql loader

1055

---

What is the purpose of cursors in pl/sql?

1134

---

How do you drop a trigger?

984

---

Can I learn sql in a week?

1059

---

Cite the differences between execution of triggers and stored procedures?

1075

---

How does an execution block start and end in pl sql?

950

---

What is the use of <> sql?

973

---