52.  What is RDBMS KERNEL?

            Two important pieces of RDBMS architecture are the kernel, which is the software, and the data dictionary, which consists of the system-level data structures used by the kernel to manage the database

            You might think of an RDBMS as an operating system (or set of subsystems), designed specifically for controlling data access; its primary functions are storing, retrieving, and securing data. An RDBMS maintains its own list of authorized users and their associated privileges; manages memory caches and paging; controls locking for concurrent resource usage; dispatches and schedules user requests; and manages space usage within its table-space structures

.

53.  Name the sub-systems of a RDBMS

            I/O, Security, Language Processing, Process Control, Storage Management, Logging and Recovery, Distribution Control, Transaction Control, Memory Management, Lock Management

 

54.  Which part of the RDBMS takes care of the data dictionary? How

            Data dictionary is a set of tables and database objects that is stored in a special area of the database and maintained exclusively by the kernel.

 

55.  What is the job of the information stored in data-dictionary?

            The information in the data dictionary validates the existence of the objects, provides access to them, and maps the actual physical storage location.

 

56.  Not only RDBMS takes care of locating data it also

            determines an optimal access path to store or retrieve the data

 

57.  How do you communicate with an RDBMS?

            You communicate with an RDBMS using Structured Query Language (SQL)

 

58.  Define SQL and state the differences between SQL and other conventional programming Languages

SQL is a nonprocedural language that is designed specifically for data access operations on normalized relational database structures. The primary difference between SQL and other conventional programming languages is that SQL statements specify what data operations should be performed rather than how to perform them.

 

59.  Name the three major set of files on disk that compose a database in Oracle

There are three major sets of files on disk that compose a database. All the files are binary.  These are

Ø      Database files

Ø      Control files

Ø      Redo logs

The most important of these are the database files where the actual data resides. The control files and the redo logs support the functioning of the architecture itself.

All three sets of files must be present, open, and available to Oracle for any data on the database to be useable. Without these files, you cannot access the database, and the database administrator might have to recover some or all of the database using a backup, if there is one.

Advertisements