Oracle DBA Interview Questions
A Cluster is made up of a table, or group of tables that share the same data blocks, which are grouped togather because they share common columns and are often used together.
In case of any doubt, mail me :
bobby_1020@hotmal.com
Use dbms_shared_pool procedure.
EXECUTE DBMS_SHARED_POOL.KEEP(OBJECTNAME);
Is it possible to configure primary server and stand by server on different os?
Answer for this questions is no. Standby database must be on same version of database and same version of operating system.
Yes you can configure your stand by server with Advance Replication provided by Oracle 8i onwards on different OS. But the Oracle version should be same.
My Current senario Primary DB is on Unix and Secondary DBs are on Windows.
What are memory structures in Oracle?
The basic memory structures associated with Oracle include: • System Global Area (SGA), which is shared by all server and background processes and holds the following: o Database bu...
Block is the smallest unit of storage in the
logical structure of the database where
actual table rows are stored.
Synonyms are used to : Mask the real name and owner of an object.
Provide public access to an object
Provide location transparency for tables,views or program units of a remote database.
Simplify the SQL statements for database users.
the related columns of the tables are called the cluster key. the cluster key is indexed using a cluster index and its value is stored only once for multiple tables in the cluster.
What are the basic element of base configuration of an Oracle database ?
it consists ofone or more data files.One or more control files.Two or more redo log files.The database containsmultiple users/schemasone or more rollback segmentsone or more tablespacesdata dictionary tablesuser objects (table,indexes,views etc.,)the server that access the database consists ofsga ...
How materialized views work with object types and collections
This is extract from Oracle10g advanced replication book. How materialized views work with object types and collectionsOracle object types are user-defined datatypes that make it possible to model complex real-world entities such as customers and orders as single entities, called objects, in the database....
User Panel
Categories
Interview Coaching
Ads
Connect
Ads
Interview Question
Latest Questions
Ads
Interview & Career Tips
Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.
NH
An index cluster uses an index to maintain data within the cluster. The structure of a cluster index is similar to a normal index. Although a normal index does not store NULL key values, and inde...