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

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

The data dictionary of an ORACLE database is a set of tables and views that are used as a read-only reference about the database.It stores information about both the logical and physical structure of the database, the valid users of an ORACLE database, integrity constraints defined for tables in the database and space allocated for a schema object and how much of it is being used.

Sudhakar

• Sep 27th, 2007

Data Dictionary is a read-only set of tables that provides information about the database. in order to avoid the I/O cost, these data dictionary views are used

Mohammed Abdul Afroze

• Mar 25th, 2007

Answer.  Oracle continously requests and update the information in the data dictionary of the database.To minimize the performance of the system internal operation,data dictionary cache holds the dictionary information.

Answer Question  Select Best Answer

ORACLE database's data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk.

matabrez

 Profile Answers by matabrez Questions by matabrez

• Jan 10th, 2011

Smallest logical of Oracle database. In Oracle 10g default data block size is 8192 byres means 8k.
Other data block size are 2k, 4k, 8k, 16k, 32kWe have only these available data blocks in oracle database.

C.Ramesh

• Oct 27th, 2007

Oracle Data Blocks is logical storage unit of Oracle and One Oracle Data Blocks containts multiple of Operating system Blocks. Data blocks contains contigous of Bytes.

Answer Question  Select Best Answer

Where does the process dumps information about the error?

ARUN BHUKKER

 Profile Answers by ARUN BHUKKER Questions by ARUN BHUKKER

• Oct 19th, 2012

Errors are stored in alert.log file it can be shecked using the parameter background_dump_dest

Use show parameter background_dump_dest
for path of the alert.log in trace directory

matabrez

 Profile Answers by matabrez Questions by matabrez

• Jan 10th, 2011

Alerts will log to alert.log  and alert trace files will be saved in  $ORACLE_HOME/admin/bdump directory.

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

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

Rollback Segments are used :To generate read-consistent database information during database recovery to rollback uncommitted transactions for users.

Mohammed Abdul Afroze

• Sep 18th, 2007

Rollback Segment Stores Undo Information and are used for the following purposes.1. To undo the previous command2. For read consistency and3. For crash recovery.

vijay

• Jun 15th, 2007

Transaction rollback:  Suppose if you  are updating the data, now you want to rollback so the old image will read from rollback segments.  You are old image from rollback segment.Transa...

Answer Question  Select Best Answer

The set of Redo Log files for a database is collectively known as the database's redo log.

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• May 21st, 2008

Oracle maintains logs of all transactions against the databse. These transactions are recorded in files called Online Redo log files.These logs are used to recover the database's transaction in th...

sampath kumar

• May 17th, 2006

Red log file store the changes in the data file.it mainly used for recovery purpose..

Answer Question  Select Best Answer

A Control file records the physical structure of the database. It contains the following information.Database NameNames and locations of a database's files and redolog files.Time stamp of database creation.

Mohammed Abdul Afroze

• Sep 20th, 2007

The controlfile contains :1. Name and Location of Datafiles, Redo Logfiles.2. Timestamp of Database Creation.3. Current log sequence number is recorded when log switches are occur.4. Checkpoint inform...

nagabhushan reddy

 Profile Answers by nagabhushan reddy Questions by nagabhushan reddy

• Mar 7th, 2006

control file is a binary filewhich having information 1.database name2.database creation3.checkpoint information4.no of datafiles5.redolog files

Answer Question  Select Best Answer

raghu2110

 Profile Answers by raghu2110 Questions by raghu2110

• May 20th, 2008

Blob datatype is used for storing large Binary data Like Photos,signatures etc Clob datatype is used for stoeing large character data upto 4GB like resume and other docs

manish hoiyani

• Sep 14th, 2006

Clob, blob, used to unstructured data and binary data respectively.

Answer Question  Select Best Answer

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 segment extents are released to the system for future use.

manish hoiyani

• Sep 14th, 2006

temporary segments are basically used for sort operations in oracle,,when the user tries to execute the query through order by clause. so system needs an space for an sort operation, and system   will use temporary segments  for this query.

manu

• Apr 7th, 2006

  To execute any program in Computer it needs memory area(RAM), Oracle allocates some memeory  for processing SQL statement. After execution this memory is released for future use. This one call Temporary work area.

Answer Question  Select Best Answer

Every ORACLE database has one or more physical data files. A database's data files contain all the database data. The data of logical database structures such as tables and indexes is physically stored in the data files allocated for a database.

sendhur

• Mar 15th, 2007

The data of logical database, say tables,indeses etc are stored in datafile.they can be associated with only one database. once created their size can not be altered. but we can add new data file to the table space.

Priya

• Sep 25th, 2006

Actually we can alter the size of the datafile by using the below syntaxSyntax :ALTER DATABASE DATAFILE RESIZE ;

Answer Question  Select Best Answer

When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.

Mohammed Abdul Afroze

• Oct 16th, 2007

Uses of a Controlfile:1.It is used to identify the names and locations of datafiles,redologfiles.2.Redo History is recorded during log switches.3.Checkpoint information is recorded at ckpts are m...

Lalit Vasuja

• Jan 4th, 2006

Control file contain the physical structure of database.it also contain the current log sequence number.when database mount ->open then oracle server check the consistency of the database through the control fie.

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

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

Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name in a SQL statement or in the definition of the owner's views or procedures.

Ravikumar

• Oct 18th, 2011

Database link is created by a user in his schema,it has 2 types

1.private database link
2.public database link /global

private database link is access the object in separate user

syntax:

create database link connect to username identified by password using 'db_name';

kailasTile

 Profile Answers by kailasTile Questions by kailasTile

• Oct 14th, 2011

Private database link is created by a user in his schema. While creating the link, the keyword GLOBAL is not used. The syntax for creation is CREATE DATABASE LINK myPrivateDBLink connect to identified by using ;
Private DB links can not be used by other schema's.

Answer Question  Select Best Answer