In DBMS, What is a relation?

tarpeg

 Profile Answers by tarpeg Questions by tarpeg

• Nov 30th, 2010

Relation is defined as a set of tuples that have the same attributes.

Answer Question  Select Best Answer

What is the difference between SGA_target and SGA_maxsize?

shreya_phadnis

 Profile Answers by shreya_phadnis Questions by shreya_phadnis

• Oct 1st, 2008

SGA_target if set to positive value enables automatic shared memory mgmt. with this you do not have to set memory for the 5 auto tuned memory parameters like - shread pool, large pool, Java pool, stre...

Answer Question  Select Best Answer

What type of value does a global variable support ?

Habib.Ur.Rehman

 Profile Answers by Habib.Ur.Rehman Questions by Habib.Ur.Rehman

• Apr 2nd, 2008

Global variable are forms specifice variable. it can store character value upto 255, for all usages. We can initialize it when we declare, otherwise give error if we did not assign it any value.Oracle 10g it can take upto 4000 bytes.

Answer Question  Select Best Answer

What is the function of SMON ?

sameh.ebeid

 Profile Answers by sameh.ebeid Questions by sameh.ebeid

• May 5th, 2008

perfrom instance recovery when the database is responded after instance fail

Answer Question  Select Best Answer

How to create LOV dynamically at runtime & attach to text field?

SHAHNAWAZ MUZAFFAR

• Mar 10th, 2012

We can use Dynamic LOV through assigning into a global variable and using this global variable into our sql statement.

Answer Question  Select Best Answer

How to estimate the size of a tablespace according to the size of the database size

chandubtech

 Profile Answers by chandubtech Questions by chandubtech

• Jun 30th, 2009

Select sum(bytes/1024/1024) mb from dba_data_files where tablespace_name='XXXXXX'

Answer Question  Select Best Answer

How many layers are there in the shared pool? What are they?

amahalakshmimca

 Profile Answers by amahalakshmimca Questions by amahalakshmimca

• May 13th, 2009

There are two layers in shared pool 1. Library cache2. Data Dictionary cache

Answer Question  Select Best Answer

What is the difference between pair wise & non pair wise comparison in a multiple column subquery. In which case are these used?

todeepakmalhotra

 Profile Answers by todeepakmalhotra Questions by todeepakmalhotra

• Sep 30th, 2008

In pair wise comparison we write like this:"where (MGR_ID, DEPT_ID) IN (SUBQUERY)"IN non pair wise comparison we write like this:"where (MGR_ID) IN (SUBQUERY)and (DEPT_ID) IN (SUBQUERY)...

Answer Question  Select Best Answer

While creating a new user we set his password as identified globally, what does it mean?

Paramjeet Singh

 Profile Answers by Paramjeet Singh Questions by Paramjeet Singh

• Dec 12th, 2008

We dont set user's password as "identified globally". We write "identified globally" to decide user's scope.Details:In Oracle, we can create user in three ways:1. local user2. external user3. Global u...

Answer Question  Select Best Answer

Lets follow the following structure of granting priviledge..A -> B -> C -> D -> EIf we revoke priviledge from C, then what happens with D and E.

rajendra_thanekar

 Profile Answers by rajendra_thanekar Questions by rajendra_thanekar

• Oct 21st, 2008

hi, It depends upon the type of privilege you are revoking. Is it object priviledge or system priviledge. There is one major difference in the revocation of object privileges and system privileges. Wi...

Answer Question  Select Best Answer

What is the main difference between the functions of DB_BUFFER_CACHE and LIBRARY_CACHE?

sumer77

 Profile Answers by sumer77 Questions by sumer77

• Oct 24th, 2008

DB Buffer cache:  when a query is executed then server process looks for block in buffer cache. If the block is not available in buffer cache then server process reads the block from data files.L...

Answer Question  Select Best Answer

Which one gives better performance,
co-related subquery or inline views? Why?

Lakshmi84

 Profile Answers by Lakshmi84 Questions by Lakshmi84

• Aug 12th, 2009

Inline views works better than correlated subqueries in 8i. But things have changed in 9i.  This is because Oracle has changed their logic while processing a correlated  subquery.

Answer Question  Select Best Answer

How can we create control file, when it is lost?

bismita

 Profile Answers by bismita Questions by bismita

• Jan 22nd, 2009

If other files like datafile and log files are intact then take the back up of the control file to trace directory as follows. 1. Open the database in nomount mode i.e. startup nomount; 2. Take t...

Answer Question  Select Best Answer

What are Synonyms and Sequence?

Punithavel

 Profile Answers by Punithavel Questions by Punithavel

• Mar 3rd, 2009

Synonym - Giving alias of the existing database object. The need of synonym is to access the other schema objects easily.. (for Eg.. If you want to access gl_list table from GL schema object, you usua...

Answer Question  Select Best Answer

How many redo log group are there in Oracle 10g database? What are they?

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Feb 17th, 2009

At Least 2 groups. To protect against a failure involving the redo log itself, Oracle Database allows a multiplexed redo log, meaning that two or more identical copies of the redo log can be automatic...

Answer Question  Select Best Answer

Can we create tablespace without segments if yes then how?

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Mar 4th, 2009

For what reason you want to create tablespace without segments. Answer is no

Answer Question  Select Best Answer

When we trace the control file how many datafiles are created?

mbreddy5

 Profile Answers by mbreddy5 Questions by mbreddy5

• Mar 16th, 2009

No data files are created when we trace a control file. Tracing will create a word format of control file with all the information of data base (datafiles, log switching etc).

Answer Question  Select Best Answer

How to convert dictionary managed tablespace to locally managed tablespace?

mohibalvi

 Profile Answers by mohibalvi Questions by mohibalvi

• Mar 14th, 2009

You can use DBMS_SPACE_ADMIN package to convert DMT to LMT. exec dbms_space_admin.Tablespace_Migrate_TO_Local('ts_dm');where ts_dm is the name of tablespace that need to be converted to locally managed tablespace.

Answer Question  Select Best Answer

What difference does it make to a Oracle developer while using RAC ? Would/Should he realise that it is a RAC Database ?

suji

 Profile Answers by suji Questions by suji

• Mar 21st, 2011

It makes no difference for the developer and RAC technology is server side and affects the way DBA do they day to day job. Thanks, Suji

Answer Question  Select Best Answer

What is an Oracle Instance? Where it is present and How does it perform?

prajwal.achar

 Profile Answers by prajwal.achar Questions by prajwal.achar

• Jul 15th, 2009

Oracle Instance is a memory component of Oracle server which is a combination of memory structure and background processes..It is a means to access data in a database i.e., it is a path way to access data.

Answer Question  Select Best Answer