Oracle Dba Interview Question and Answers
31. |
What is the major difference between the clob and blob data types in Oracle Database 1Og? |
|
The clob stores only alphanumeric data, whereas the blob can accommodate any type of data, including sound and video. |
|
|
32. |
What is the difference between an index cluster and a hash cluster? |
|
An index cluster is a cluster that has an index on the cluster key, whereas the hash cluster uses a hashing function to access the cluster key. |
|
|
33. |
What is a recovery catalog? |
|
Recovery catalog is an inventory of the backup taken by RMAN for the database.It is used to restore a physical backup, reconstruct it, and make it available to the server. |
|
|
34. |
What are architectural components of RMAN? |
|
Following are the architectural components of RMAN : - RMAN executable
-
Server processes
-
Channels
-
Target database
-
Recovery catalog database (optional)
-
Media managements layer (optional)
-
Backups, backup sets, and backup pieces.
|
|
|
35. |
What is load balancing? |
|
Load balancing is a server process that monitors loading on all of the forms servers. Each of the forms servers runs a load balancing client which keeps the load balancing server apprised of its load. |
|
|