doc123

 Profile Answers by doc123 Questions by doc123

• Mar 22nd, 2012

Exactly View is logical identity.Oracle only stores definition of View in metadata. Using view, we can hide some columns of tables from users, we can hide original table name from user. Using view we can perform complex query in single statement.

ROHAN MAKODE

• Feb 25th, 2012

Assume that the dba is modifying a tables and the same time developer want to use that database a then dba can provide him the view for that tables.

Code
 

Answer Question  Select Best Answer

If Materialized view contains the actual data and has to be re-created every time the original table data is changed and we intent to refresh the data in the view.then what is the actual use of materialized view, why can't we create another table by itself by running the same query ?

doc123

 Profile Answers by doc123 Questions by doc123

• Mar 23rd, 2012

Materialized view is useful in replication and data warehousing environment where every time data extracting and data loading from another sites,databases. Materialized view also useful for maintaining complex queries because it uses query rewrite feature.

Answer Question  Select Best Answer

doc123

 Profile Answers by doc123 Questions by doc123

• Mar 23rd, 2012

Dear friend, it is not RAP but it is WRAP. Using this utility of Oracle, we can hide our PL/SQL code from user.

Answer Question  Select Best Answer

What are the common problems while taking backups? What are the necessary steps to take backup on to tapes and disks in real time?

sundarasaravanan

• May 4th, 2012

For a cold backup :shutdown oracle first and then proceed the cold(offline) back up. once you shutdown the oracle database insert the external tape/disk.pls ensure the tape/disk is in good condition. ...

doc123

 Profile Answers by doc123 Questions by doc123

• Mar 23rd, 2012

Some Common issues with Backup. If you are taking backup from no-archive log: then your database doesn't bring down due to some processes are running. If you are taking hot backup then may be newly ...

Answer Question  Select Best Answer

Explain what are Oracle Catalog and Oracle Archive log?

Sriniv@s..

• May 23rd, 2012

Oracle catalog contain the metadata of objects.
RMAN catalog maintain the backup information.
Redo data persistently stored in archive logs,for recovery..

pandish

 Profile Answers by pandish Questions by pandish

• Dec 31st, 2010

Catalog term is used in 2 ways.Catalog - All tables/views stores information about database and all objects in it.RMAN Catalog - Schema where RMAN executable stores/reads/writes the information about ...

Answer Question  Select Best Answer

kirankumar c.s

• May 26th, 2012

Server process

baala

 Profile Answers by baala Questions by baala

• Aug 11th, 2008

DBWR only writes to the data files. So the answer is Server Process.

Answer Question  Select Best Answer

Sriniv@s..

• Jun 2nd, 2012

SGA(system global area) & PGA(program global area) are two memory structures in oracle. SGA::is used to store shared information.It having Buffercache,Redolog buffer,Shared pool,java pool,Larg pool an...

AJU JOHNSON

• Apr 29th, 2005

PGA Program global area Contains  Session variables ,Stack space,Cursor status ,Sort Areas

Answer Question  Select Best Answer

Sriniv@s..

• Jun 5th, 2012

Rollback segment is a database object,containing before image of data written to the database.It is used to..
:Undo changes when the transaction is rolled back.
:Recover the database in case of failures.
:Uncommitted changes made to the database,this will protected by it.

Ram

• Jul 9th, 2005

ROLLBACK INFORMATION NOTES:   Segment Name - Name of the rollback segment.  Owner - Owner of the rollback segment.  Tablespace - Name of the tablespace containing the rollback...

Answer Question  Select Best Answer

Sriniv@s..

• Jun 5th, 2012

Schema is a set of objects own by particular user.
Tables,indexes,Triggers,constraints etc..are schema objects..

Jacob

• Jul 9th, 2005

A schema is a collection of database objects. A schema is owned by a database user and has the same name as that user. Schema objects are logical structures created by users. Objects may define areas ...

Answer Question  Select Best Answer

Sriniv@s..

• Jun 8th, 2012

SQLNET.ORA :: It is the optional network configuration file.it contain network configuration details.
LISTINER.ORA : It is the listener file for creating at server side
TNSNAMES.ORA:client side configuration file.it was matched with listener file.it for remote access.

Patrick McShea

• Nov 15th, 2006

SQLNET.ora tells you what path to take in resolving the name of an instance (among other things). In the context of this question, the NAMES.DIRECTORY_PATH parameter specifys the order of the naming methods used for client name resolution lookups. (TNSNAMES, ONAMES...)

Answer Question  Select Best Answer

 The set of objects owned by user account is called the schema.

Sriniv@s..

• Jun 20th, 2012

Schema is a set of objects own by a Particular user..

msabuu

 Profile Answers by msabuu Questions by msabuu

• Nov 6th, 2007

Schema is collection of database object.

Answer Question  Select Best Answer

iv4122

• Jul 3rd, 2012

Using the storage options can bring further performance gains by using the techniques available for regular tables, including parallel option, partitioning or nologging for the table that holds the materialized view data.DRDPW

Sriniv@s.

• May 11th, 2012

Materialized views are useful for fast REPLICATION purpose..

Answer Question  Select Best Answer

venu

• Sep 1st, 2012

SCN is generated by oracle when a transaction is successfully commited. This is referred to as SystemChangeNumber. We can think of it as a transaction id generated when we make some transaction in an ...

SANTHOSH

• Aug 15th, 2012

SCN no is a number which is generated by the oracle, when we made any changes to the data that statements will be recorded in redo log files and every committed statement will be given this SCN no by oracle.

Answer Question  Select Best Answer

venu

• Sep 1st, 2012

The transportabel tablespaces enable us to transport data objects across different platforms.

Backing up or recovering a particular user/schema objects or data objects or tablespaces or entire databases is possible, which cannot be done using other backup techniques.

Sriniv@s..

• Jun 2nd, 2012

Moving data using transportable tablespace can be much faster than performing either export/import or unload/load of the same data.Bcz transporting a tablespace only requires the copying of datafiles & integrating the tablespace structural information.

Answer Question  Select Best Answer

venu

• Sep 1st, 2012

Code
 

will give the required result.

Wildy

• Jul 18th, 2011

Select instance_name, status, database_status, startup_time from v$instance;

Answer Question  Select Best Answer

Can you take online backup of a Control File If yes, How?

venu

• Sep 1st, 2012

Code
 

Specify the path where you want to store the controlfile backup.

neha.awasthi1

 Profile Answers by neha.awasthi1 Questions by neha.awasthi1

• May 18th, 2011

We can do this by suding RMAN:configure control file auto backup on;

Answer Question  Select Best Answer

hanuman

• Sep 4th, 2012

View does not consume space and materialized view consume space

manoj100

 Profile Answers by manoj100 Questions by manoj100

• Aug 26th, 2012

A view is a simple select statement executed each time user runs query against it A materialized view is a physical persistent object used for performance improvement of summary data or replication. ...

Answer Question  Select Best Answer

Nony

• Oct 7th, 2012

Alter table move tablespace USERS

chandrasekar.s

• Jun 1st, 2012

Using alter table command we can move one table from one schema to other

Code
 

Answer Question  Select Best Answer

In exception handling we have some NOT_FOUND and OTHERS. In inner layer we have some NOT_FOUND and OTHERS. While executing which one whether outer layer or inner layer will check first?

AK Badola

• Dec 17th, 2012

Inner layer

Answer Question  Select Best Answer

How would you plan for an Oracle upgrade? What are the prerequisites?

deepak subramoniam

• Aug 3rd, 2014

Ensure the nls Characterset of the parent and child database are same
Ensure the editions of both the database are same.
Ensure UTL_SMTP,UTL_HTTP,UTL_FILE Packages are available. (for 10g to 11g se)
wm_concat needs to be changed in the 11g because in 11g the function will not be supported by Oracle

rohith

• Jul 21st, 2014

if u want to any up-gradation in oracle first we need to check version compatibility like if u want to upgrade from 10g to 11g the 10g version should be 10.2.0.4 or 10.2.0.5. then install the 11g sof...

Answer Question  Select Best Answer