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

What are Meta Links? Describe in detail

Punithavel

 Profile Answers by Punithavel Questions by Punithavel

• Mar 3rd, 2009

Metalinks - Oracle to take care of its customer to solve their technical issues. Once you get the license with oracle they wil provide you the metalink user and password, you can use it to search the ...

Answer Question  Select Best Answer

In which format redo log files stores the changes ?

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Feb 17th, 2009

Good Question. They are not stored in binary format , but in sql.

dheerajdba

 Profile Answers by dheerajdba Questions by dheerajdba

• Aug 7th, 2008

Binary-format

Answer Question  Select Best Answer

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Feb 17th, 2009

Nope I think , and you dont require also. If MAXINSTANCES is greater than the number of free list groups in the table or cluster, then an instance number maps to the free list group associated with. I...

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

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

When a Oracle instance is up, How can we find which parameter file (pfile or spfile) the oracle is using?

chaitra murthy

 Profile Answers by chaitra murthy Questions by chaitra murthy

• Jan 9th, 2009

The command given below will display 3 colums NAME, TYPE, VALUESQL> show parameter spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile ...

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

dnkreddy

 Profile Answers by dnkreddy Questions by dnkreddy

• Nov 30th, 2008

8i-materilized views, instead of triggers, support internet, granting of columns
9i-timestamp, rename of column, new datatypes, rank, dense_rank, 9i joins

Rajendra Thanekar

• Apr 29th, 2007

1)? connect internal (SVRMGR) is not supported in 9i now you can manage database with SQL*plus.2) SPfile in 9i which is not available in previous version. Helpful for those init parameter those need ...

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

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 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 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

madhupriya.nukala

 Profile Answers by madhupriya.nukala Questions by madhupriya.nukala

• Sep 18th, 2008

When the session close,it will lose the data.

soumya_2003

 Profile Answers by soumya_2003 Questions by soumya_2003

• Jul 8th, 2008

The temporary tables retains data till the application referencing it, is active and running.

Answer Question  Select Best Answer

Can you explain What is DUAL table in Oracle?

ashish88

 Profile Answers by ashish88 Questions by ashish88

• Jun 11th, 2008

hello  dual is a table which is created by oracle along with the data dictionary. It consists of exactly one column whose name is dummy and one record. The value of that record is X. sql> desc...

parthokonar

 Profile Answers by parthokonar Questions by parthokonar

• Apr 19th, 2006

Hi,Actually what happens when we issue create database command, Oracle automatically creates the tablespace and tables using the sql.bsq script found in the $oracle_home/rdbms/admin directory this scripts the dual table and is owned by the sys and has one column and one row.

Answer Question  Select Best Answer

sravee123

 Profile Answers by sravee123 Questions by sravee123

• Jun 4th, 2008

Select e.ename,sal from emp e where e.sal>(select avg(sal) from emp where e.deptno=deptno)

askvenki

 Profile Answers by askvenki Questions by askvenki

• Jun 3rd, 2008

SELECT * FROM EMP E WHERE E.SAL>(SELECT AVG(sAL) FROM EMP E1 WHERE E1.DEPTNO=E.DEPTNO); Above is the co-related subquery, I am explaining its executionStep1: The main query executes first and we get ...

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

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 difference between Oracle Application DBA and System DBA?

napster.syed

 Profile Answers by napster.syed Questions by napster.syed

• Feb 27th, 2008

Oracle DBA is basically taking care of the database whereby Oracel Apps DBA is taking care of the database housing Oracle Apps and should be able to map the front end of Oracle Apps to the Backend tab...

Answer Question  Select Best Answer

A view is created on a table then i dropped the base table and created the base table once again with the same name then that view will works or not?

Sant_parkash

 Profile Answers by Sant_parkash Questions by Sant_parkash

• Feb 5th, 2008

The view will be INVALID,so you need to re-compile it after create that base table...

Ashok Kumar choubey

• May 23rd, 2007

It will work either after base table drop and recreate or base table alteration.?Enjoy

Answer Question  Select Best Answer