ORACLE INTERVIEW QUESTION & ANSWERS
| 96. |
What is privileges? |
| |
A privilege gives a user permission to perform certain tasks or access specific
objects in the database. |
| 97. |
What are the types of privileges? |
| |
There are two types of privileges are :- System Privileges : These give a user the capability to do something in the database, such as create tables or create views.
- Object Privileges : These give a user access to the data in an object, such as the privilege to select or update rows in a specific table.
|
| 98. |
What is subquery? |
| |
A subquery is an SQL statement called from another query or another subquery. Subqueries can return various result sets and can be defined based on what they return. |
| 99. |
What are the types of subqueries? |
| |
- Single Row / Single Column
- Multiple Rows / One Column Each
- Multiple Columns / Single or Multiple Rows
|
| 100. |
What is correlated subqueries? |
| |
While a subquery is evaluated only once for each table, a correlated subquery is
evaluated once for each row. |
