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

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

The Information in a redo log file is used only to recover the database from a system or media failure prevents database data from being written to a database's data files.

Dinesh Chandra

• Aug 27th, 2012

Redo log records the changes made in database. Redo logs is mainly used to recover data.

rohitmisri

 Profile Answers by rohitmisri Questions by rohitmisri

• Jun 17th, 2010

Hi,Redo log information is the one of the major pard of the database , at any time if the oracle server instance get aborted and then it need recovery, so at that time redo log plays a role to recover...

Answer Question  Select Best Answer

A rule defined on a column (or set of columns) in one table that allows the insert or update of a row only if the value for the column or set of columns (the dependent value) matches a value in a column of a related table (the referenced value). It also specifies the type of data manipulation allowed on referenced data and the action to be performed on dependent data as a result of any action on referenced...

ddf_dba

 Profile Answers by ddf_dba Questions by ddf_dba

• Dec 21st, 2007

Referential integrity is a relationship between two tables, one being the 'parent' and the other being the 'child'.  The 'child' table references values in the 'parent...

sivamurugan9182

 Profile Answers by sivamurugan9182 Questions by sivamurugan9182

• Dec 14th, 2007

Sorry i not here to give the answer.But i just want to mention as i was a beginner in the learning of OracleDB,i was quite confused of the answers given by the beloved forum members(not all)...

Answer Question  Select Best Answer

Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace.

swetashashi

 Profile Answers by swetashashi Questions by swetashashi

• Apr 16th, 2009

Databases, tablespaces, and datafiles are closely related, but they have important differences:1) An Oracle database consists of at least two logical storage units called tablespaces, which collective...

swetashashi

 Profile Answers by swetashashi Questions by swetashashi

• Apr 16th, 2009

Each databases logically consists of one or moretablespaces One or more data files are explicitly createdfor each tablespace.

Answer Question  Select Best Answer

A schema is collection of database objects of a User.

ARUN BHUKKER

 Profile Answers by ARUN BHUKKER Questions by ARUN BHUKKER

• Oct 19th, 2012

A schema is the set of objects (tables, views, indexes, etc) that belongs to an user account. It is often used as another way to refer to an Oracle account. Most Oracle database installations traditio...

Mohammad Mujeeb

• Oct 25th, 2011

Schema is a collect of object (table,view,cluster etc) that belongs to an user account.

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

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

mmaz2002

 Profile Answers by mmaz2002 Questions by mmaz2002

• Jul 15th, 2009

All Extent info is maintained in Dictionary which is infact a dis-advantage, Also in case of a huge insert operation undo is generated.

deep chandan

 Profile Answers by deep chandan Questions by deep chandan

• Dec 30th, 2008

The main advantage of using dictionary managed tablespaces is that in this we can give the size of the extents according to our need. We can modify extent size but in locally managed tablespace extents are of uniform size.

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

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

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

sanjayoracle

 Profile Answers by sanjayoracle Questions by sanjayoracle

• Apr 25th, 2008

Just in simple words.....Ora01555 error occurs when a transation fails when it cannot able to find read consistence image in rollback segment. To solve this problem: Increse the Undo_RetentionCheers :)

Mohammed Abdul Afroze

• Mar 25th, 2007

Answer: Avoiding Snap Shot too old error-(oerr ora 01555).   First thing here we understood how is the rbs works.This will work in circular fashion by looping around the reuse of the ex...

Answer Question  Select Best Answer

How we can determine the physical architecture of oracle?

ranjithsv

• Oct 2nd, 2013

Datafiles(*.dbf),
Controlfiles(*.ctl),
Redologfiles(*.log),
Archivelogfiles(*.arc)

ARUN BHUKKER

 Profile Answers by ARUN BHUKKER Questions by ARUN BHUKKER

• Oct 19th, 2012

Oracle architecture consist of four structures: 1. Memory structure (SGA, PGA) 2. Process structure (user process, server process, background process) 3. Physical structure (data files, redo log files...

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

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

A view is a virtual table. Every view has a Query attached to it. (The Query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)

pravesh28

 Profile Answers by pravesh28 Questions by pravesh28

• Mar 27th, 2010

View means virtualit is virtual table drived from base tableview doesnt contain any data view is mirrar image of data that we  can set the its size

C.Ramesh

• Oct 17th, 2007

View is a Virtual Table. It likes like a table. View provide additional level tabel security and providing selected columns only and it accessing different tables no need to joins of different tables. Views also stores data like (Materialized Views) it can be referesh methods like fast, complete.

Answer Question  Select Best Answer

How does the SMON process performs recovery after instance failure?

ranjithsv18

• Oct 2nd, 2013

When hardware failure, software failue and shutdown abnormally happen... SMON taking care of Instance failure, coalesce failure space and deallocating temp segment start to recover instance Roll fw...

Nagaraj OCP

• Dec 27th, 2011

When shutdown abort happens, oracle server gets crashed. To recover from the crash, SMON will check the online Redo data files and last SCN no in the Redo log files and SCN number in the undo tablespa...

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

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