ORACLE INTERVIEW QUESTION & ANSWERS
| 66. |
What is Join? |
| |
- Join combines columns and data from two or more tables.
- Join is a query in which data is retrieved from two or more table.
- A join matches data from two or more tables, based on the values of one or more columns in each table.
|
| 67. |
What are the different types of joins? |
| |
The different types of joins are : - Equi Join
- Cartesian Join
- Inner join
- Outer Join
|
| 68. |
What Oracle object is used for recovery operations? |
| |
The redo log files and the archive log files are used for database recovery. |
| 69. |
What is Partial Backup ? |
| |
A Partial Backup is any operating system backup short of a full backup, taken while the database is open or shut down. |
| 70. |
What are the types of privileges? |
| |
Oracle has two kinds of privileges :
- System Privileges
- Object Privileges
|
