The related columns of the tables in a cluster is called the Cluster Key.

Dheemathi

• Mar 4th, 2019

Cluster is a schema object that contains data from one or more tables, all of which have one or more columns in common. Oracle database stores together all the rows from all the tables that share the same cluster key.

pradeep

• May 5th, 2015

The related columns of the table in the cluster are called the cluster key

Answer Question  Select Best Answer

What is high watermark in oracle ?

Prabhat Sahu

 Profile Answers by Prabhat Sahu Questions by Prabhat Sahu

• Oct 15th, 2018

-- High Level Watermark: ------------------------- --> HLW is a term used with table segment in DB to show the amount of datablock occupied(level) by the table data. --> As per PCTUSED and PCTFREE ...

Prabhat Sahu

• Oct 4th, 2017

-- High Level Watermark: ------------------------- --> HLW is a term used with table segment in DB to show the amount of datablock occupied(level) by the table data. --> As per PCTUSED and PCTFREE ...

Answer Question  Select Best Answer

Souravi

• Jun 6th, 2018

No , new columns cannoot be added in view. The view is just a select query so it should be dropped and recreated for any such requirement.

patelmosin

• Jan 18th, 2018

Yes

Answer Question  Select Best Answer

ORACLE database is comprised of three types of files. One or more Data files, two are more Redo Log files, and one or more Control files.

Naresh

• Feb 14th, 2018

Use DBMS_CRYPTO for encrypt and decrypt the objects

Harshad Khuspe

• Dec 27th, 2015

Components of Physical Databases are Oracle files which are in disk. i.e. Datafiles, Online Redolog files, Archive log files, Parameter file, Password File, Controlfile etc.

Answer Question  Select Best Answer

Which parameter specifies the number of DBWn processes?

mosinpatel

• Jan 18th, 2018

SQL> show parameter db_writer_processes
NAME TYPE VALUE
------------------------------------ ----------- -------
db_writer_processes integer 1

srinivasarao

• Mar 22nd, 2015

DB_WRITER_PROCESS=""

Answer Question  Select Best Answer

Tablespaces and the Database's Schema Objects.

mosin

• Jan 18th, 2018

Tablespace
Segments
Extent

Heena

• Sep 17th, 2017

Tablespaces, Segments, Extent, Data blocks

Answer Question  Select Best Answer

How will you identify database size when you create a database first time?

Caesar Dutta

• Nov 6th, 2017

Select sum(bytes) from dba_segments

SURAJ BANSODE

• Oct 14th, 2016

To find the size of database we need to Sum (datafiles+redo log files+temp files+control files)

Answer Question  Select Best Answer

When does the LGWR writes all redo-enteries to the redo-log buffer?

Suresh

• Oct 31st, 2017

1) When user hits commit
2) When there is 1/3rd full in redo log cache
3) One every 3 seconds

During this above situation LGWR writes redo log entries into redo log files from redo log cache !!

Mayur Pimpalkar

• Dec 24th, 2015

Lwgr process writes redo entries to online redolog files not to redobuffer.

Answer Question  Select Best Answer

Prabhat Sahu

• Oct 21st, 2017

B-Tree Index:
1. Oracle Default index.
2. Cardinality is High, means less duplicate(more unique records) (i.e. Rowid)

Bitmap Index:
1. Cardinality is Low, means more duplicate.(most of the values are repetative)
2. Flag related columns ( i.e. M/F, Y/N, 1/0 )

Vineet

• Oct 12th, 2017

1. B-tree Index has high cardinality values, where as Bitmap Index has low Cardinality values.

Answer Question  Select Best Answer

Heena

• Sep 17th, 2017

Database writer process(DBWn)

sriram

• May 17th, 2016

DBWR is one of the BG processed of Oracle DB. It writes modifies the data in data base buffer cache

Answer Question  Select Best Answer

SID (System Identifier)  :  A SID (almost) uniquely identifies an instance.  Actually, $ORACLE_HOME, $ORACLE_SID and $HOSTNAME identify an instance uniquely. The SID is 64 characters, or less; at least on Oracle 9i. The system identifier is included in the CONNECT_DATA parts of the connect descriptors in a tnsnames.ora file. The SID defaults to the database name. Global Database Name...

pavan

• Jul 4th, 2017

Can a database name can be same across multiple instances, and can the instances number be same? If yes what is SID in that case?

shaikhannan

 Profile Answers by shaikhannan Questions by shaikhannan

• Feb 3rd, 2010

SID = identifies the database instance (database name + instance number). So if your database name is somedb and your instance number is 3, then your SID is somedb3. DB Name = Name of the database (d...

Answer Question  Select Best Answer

What is the difference between log sequence number and checkpoint id? How it is used for instance recovery?

vishal gajage

• Jun 21st, 2017

Log Sequence Number is assigned to every redo log file after full the redo log file....and SCN number is generated after every commit

aditya verma

• May 11th, 2017

Logs sequence no is the value which is mention in header of every datafile. Below is the situations when SCN changed.
After every commit the transaction.
Log switch.
Backup completion.

Answer Question  Select Best Answer

Sarkar

• Mar 29th, 2016

I want to know about wrap background logic.

akebono

 Profile Answers by akebono Questions by akebono

• Jan 30th, 2009

DBMS_OBFUSCATION_TOOLKIT package is  a simple API for data encryption

Answer Question  Select Best Answer

Each Non-clustered table has a data segment. All of the table's data is stored in the extents of its data segment. Each cluster has a data segment. The data of every table in the cluster is stored in the cluster's data segment.

Harshad Khuspe

• Dec 27th, 2015

Tablespace is made up of Segment. Segment is made up of extents and extents are made up of contiguous oracle blocks. Segments are nothing but a table. i.e. Table Emp is nothing but segment emp. You can check things from data dictionary view DBA_Segments.

pradeep

• May 5th, 2015

A data segment is a set of extents allocated to a certain logical structures

Answer Question  Select Best Answer

What are the advantages & disadvantages of both two.

Harshad Khuspe

• Dec 27th, 2015

In case of RAC (Real Application Cluster) use of GNS will be helpful if we have more than 10 node cluster. GNS need not to be assign IP addresses and it select automatically with the help of DHCP

frankie Lester

• Aug 11th, 2015

GNS uses DNS and DHCP to assign IP address on the network.

Answer Question  Select Best Answer

Yes.

mayur

• Dec 24th, 2015

No, at a time only one tablespace as default can be allocate to any user. If we want to store objects of one user to multiple tablespace then assign that tablespaces as a default tablespace for user at a time

matabrez

 Profile Answers by matabrez Questions by matabrez

• Jan 10th, 2011

Yes objects of the same schema can reside in different tablepaces. Becuase when we create any schema (user) we can assign many tablespaces to one shcema so objects (eg. tables) will create in different tablespaces.

Answer Question  Select Best Answer

A database link is a named object that describes a "path" from one database to another.

Vinod Karuturi

• Nov 16th, 2015

A database link is a schema object in one database that enables you to access objects on another database. The other database need not be an Oracle Database system. However, to access non-Oracle systems you must use Oracle Heterogeneous Services.

Madhu Alampalli

• Sep 24th, 2015

Cluster key is a related column of tables in the cluster. For example, in Table EMP which has (EMP NO, EMP NAME, DEP NO, etc ) and DEPT which has (DEPT NAME, DEPT NO etc), DEPT NO is the cluster key in this cluster.

Answer Question  Select Best Answer

Harshad Khuspe

• Feb 26th, 2015

Virtual Tables are contains information about the base tables in oracle. Like V$database is virtual table which provide information of database name, open mode etc. or v$log will provide redo log members etc.

ARUN BHUKKER

 Profile Answers by ARUN BHUKKER Questions by ARUN BHUKKER

• Oct 19th, 2012

Either virtual table is a temporary table or v$ or Xv$ views

Answer Question  Select Best Answer

A data file can be associated with only one database. Once created a data file can't change size.One or more data files form a logical unit of database storage called a tablespace.

ranjithsv18

• Oct 2nd, 2013

Block size available from 2k,4k,8k,16k and 32k.

As per oracle point of view Default (or) standard block size is 8k for Data files.The initialization parameter

db_block_size=8k (8192)remaining size are non-standard blok size. Extents size 64k.

(Datafile

NAGARAJ OCP

• Dec 27th, 2011

In data files, we cant change the extent management, type of it. But we can change the storage space for it if we need after the database (tablespace) creation.

Answer Question  Select Best Answer

ranjithsv

• Oct 2nd, 2013

Its relation between SGA and 5 Mandatory Background process
SMON,PMON,DBWR,LGWR,CKPT

ARUN BHUKKER

 Profile Answers by ARUN BHUKKER Questions by ARUN BHUKKER

• Oct 19th, 2012

A background process maintain relationship between memory structure and physical structure of Oracle server. Started when Oracle instance is started. Consist of 5 mandatory and some optional backgro...

Answer Question  Select Best Answer