MCA - Advanced Database Administration

Find Question?

Explain various stages of Oracle database startup ?

You construct an instance of a database when you start it up, and you determine the database's state. In most cases, you begin by mounting and opening the database. As a result, any valid user can connect to the database and conduct standard data access operations.

to starting up an
Continue reading →

What do you mean by multiplexing of Redo logs ?

The redo log, which consists of two or more preallocated files that hold all changes made to the database as they occur, is the most important structure for recovery operations.
Every Oracle Database instance has a redo log that protects the database in the event of an instance failure.

What are Schema Objects ?

Schema objects are logical structures that refer to database data directly.
Tables, views, sequences, synonyms, indexes, clusters, database triggers, procedures, functions packages, and database linkages are all schema objects.

What is Implicit explicit cursor

Implicit cursor

As long as your code does not use an explicit cursor, PL/SQL creates an implicit cursor anytime you execute a SQL statement directly in your code.
Because you, the developer, do not explicitly specify a cursor for the SQL statement, it is called a
Continue reading →

Explain Varrays with example

VARRAY is a variable array type that is commonly used when storing a small number of instances. It consists of a number of data pieces, all of which are of the same data type. The number of elements is determined by the size of VARRAY.

Example:
Defining a VARRAY object
CREATE
Continue reading →

Write in brief about all oracle object privileges

When many users have access to database items, privileges can be used to regulate authorization. Every object has a person who owns it. Privileges determine whether a user can edit an object that belongs to another user. The instance administrator, a user with the ADMIN privilege, or, in the
Continue reading →

1