Answer Posted / kiran

authorization is the process of granting some privileges to
a particular object

authentication is the process of validation - if he is
allowed to access something-

How to pass parameters to procedures in oracle?

1023

---

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2325

---

How to list all tables in your schema?

1026

---

In oracle there is column command, how will you explain that?

1020

---

How to declare a local variable?

1097

---

How to define a record variable to store a table row?

1041

---

Explain what does a control file contain?

1083

---

Compare and contrast between sql and sql server and explain its various functions?

949

---

How to work with data objects interactively?

959

---

How to set a transaction to be read only in oracle?

1076

---

Is oracle an operator?

912

---

how to make an oracle object

2339

---

What are a collation and state the different types of collation sensitivity?

1149

---

What is the difference between a primary key & a unique key?

1071

---

How to delete a column in an existing table?

1059

---