sri

• Aug 4th, 2005

It consists of - one or more data files  - one or more control files  - two or more redo log files  The database contains - Multiple users/schema's  - ...

Answer Question  Select Best Answer

sri

• Aug 4th, 2005

Temporary Segments are created by ORACLE when a SQL statement needs a temporary work area to complete execution. When the statement finishes execution, the temporary segments extents are released to the system for future use.

Answer Question  Select Best Answer

Maheen

• Jul 9th, 2005

Oracle creates the index segment for an index or an index partition when you issue the CREATE INDEX statement. In this statement, you can specify storage parameters for the extents of the index segmen...

Answer Question  Select Best Answer

Maheen

• Jul 9th, 2005

A segment is a set of extents that contains all the data for a specific logical storage structure within a tablespace. For example, for each table, Oracle allocates one or more extents to form that ta...

Answer Question  Select Best Answer

Rani Rathna

• Jul 9th, 2005

When an Oracle network uses Oracle Names, the names servers in the system automatically create and manage global database links for every Oracle database in the network. All users and PL/SQL subprogra...

Answer Question  Select Best Answer

Rani Rathna

• Jul 9th, 2005

Oracle allows you to create private, public, and global database links.    Private Database Link: You can create a private database link in a specific schema of a database. Only the own...

Answer Question  Select Best Answer

Rani Rathna

• Jul 9th, 2005

hash cluster --> preallocated based on number of keys and key size.  index cluster --> not preallocated  in both cases, you want to get the key size (amount of data associated with...

soccer_champ

• Jun 20th, 2005

Hash clusters are useful in cases where : (i) There is a uniform, even and predictable no. of key values. (ii) Queries using equality predicates. (iii) The table is NOT growing constantly, and the keys are rarely updated.

Answer Question  Select Best Answer

Mane

• Jul 8th, 2005

It can be, the only required option is that your tablespace have quota assigned to any user that want to store objects in it.

S.Velusamy Raja

• Jul 6th, 2005

Wish to know It can be or can not be. 

Answer Question  Select Best Answer

sandhya

• Jun 27th, 2005

Segment is the collection of extents allocated to paricular object like table and index. Table segment and index segment

Answer Question  Select Best Answer

ramesh khanna

• Jun 27th, 2005

Collecion of objects

Answer Question  Select Best Answer

soccer_champ

• Jun 20th, 2005

The primary block size is defined by the Initiaization parameter DB_BLOCK_SIZE.

Answer Question  Select Best Answer

soccer_champ

• Jun 20th, 2005

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...

Answer Question  Select Best Answer

soccer_champ

• Jun 18th, 2005

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

Answer Question  Select Best Answer

Amit

• May 7th, 2005

Use dbms_shared_pool procedure. EXECUTE DBMS_SHARED_POOL.KEEP(OBJECTNAME); 

Answer Question  Select Best Answer

Answer for this questions is NO. Standby database must be on same version of database and same version of Operating system.

Manoj

• May 2nd, 2005

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. 

Answer Question  Select Best Answer

IRINA

• Apr 10th, 2005

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...

Answer Question  Select Best Answer

Karthikeyan.M

• Apr 6th, 2005

Block is the smallest unit of storage in the logical structure of the database where  actual table rows are stored.

Answer Question  Select Best Answer

krantideepak_v

• Apr 1st, 2005

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.  

Answer Question  Select Best Answer

 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.

 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  (Database  buffer,  Dictionary  Cache  Buffers, Redo log buffers, Shared...