A table which consist of atleast one primary or Unique key is called as Parent Table.
True / False (Justify)

psingla

 Profile Answers by psingla Questions by psingla

• Apr 20th, 2010

Parent tables: are tables that are referenced(foreign key) by at least one table(child).As foreign key can reference only primary or unique key,so the only tables containing any of these keys can be parent keys.

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Feb 23rd, 2009

Wrong and RightDepends how you take it. If i have emp table without primary key and i search dept table through emp id. Then this would be wrong. So, depends how you take it all i say is it's not verdict but it's an concept

Answer Question  Select Best Answer

MERGE INTO SAS F USING (SELECT PRODID, PRODID+10 F, DESCRIP FROM PRODUCT) L ON (F.PRODID=L.PRODID) WHEN MATCHED THEN UPDATE SET F.PRODID=L.F WHEN NOT MATCHED THEN INSERT VALUES (L.F, L.DESCRIP)Why does the above give error?

debjit20

 Profile Answers by debjit20 Questions by debjit20

• Apr 5th, 2010

The Error will be:Columns used in ON condition cannot be used in UPDATE.You cannot update the same column which you are using in the ON clause.

Lakshmi84

 Profile Answers by Lakshmi84 Questions by Lakshmi84

• Aug 12th, 2009

I think Error lies in the following statement INSERT VALUES (L.F, L.DESCRIP) THE STATEMENT SHOULD BE LIKE THIS  INSERT (F.PRODID,F.DESCRIP)VALUES(L.F,L.DESCRIP)

Answer Question  Select Best Answer

How does a stand alone procedures differ from that of other procedures?

ayansmile07

 Profile Answers by ayansmile07 Questions by ayansmile07

• Mar 24th, 2010

These are the 4 differences between a Stand Alone Procedure and a Packaged ProcedureCreation - A standalone procedure is created using the CREATE PROCEDURE statement. A packaged procedure is created a...

macca

 Profile Answers by macca Questions by macca

• Mar 5th, 2009

Stand Alone Procedure is not part of an Package.

Answer Question  Select Best Answer

aStewart

 Profile Answers by aStewart Questions by aStewart

• Feb 23rd, 2010

The index status can be found in the dba_indexes, dba_objects, or the equivalent  user_ view. The possibilities are VALID, INVALID, UNUSABLE, or N/A.  Invalid or unusable indexes will not be...

Asim Jamal

• Apr 13th, 2006

The current status and details of an index could be accessed by system table sys.dba_indexes. The status could be VALID,INVALID,N/A.The invalid indexes unnecessarily occupies the space in a Tablespace.

Answer Question  Select Best Answer

venkatagsubbaiah

 Profile Answers by venkatagsubbaiah Questions by venkatagsubbaiah

• Feb 4th, 2010

Create Table Tab1 as select  * from Tab2 where 1=2;

rajiv.sriraj

 Profile Answers by rajiv.sriraj Questions by rajiv.sriraj

• May 9th, 2008

HI if u want to get the same table structure which is already existing in ur database then SQL QUERY IS create table <table name> as select * from <table name which is already in DB> where...

Answer Question  Select Best Answer

Why we need both the SID and the Serial no's to kill the session?How to offload query processing from the Production DB to Standby DBWhy some times startup /as sysdba starts only the instance (Why not opening the DB)Explain the Functionality of sqlplus /nolog?

jpundalik

 Profile Answers by jpundalik Questions by jpundalik

• Dec 26th, 2009

Components of SGA- Shared Pool (Library Cache and Data Dictionary Cache)- Data Base Buffer- Redo Log Buffer

pchandna

 Profile Answers by pchandna Questions by pchandna

• Jul 22nd, 2009

DB buffer cache, Redo Log cache and Shared PoolShared Pool --> data dictionary cache, Library cache and User Global area

Answer Question  Select Best Answer

What is Wrap?

What is PGA_AGGREGRATE_TARGET parameter?

Query 1.
SELECT sal FROM emp e WHERE sal < any (SELECT sal FROM empWHERE empno=e.mgr)
(o/p:11 row)
Query 2.
SELECT SAL FROM emp e WHERE sal < any (SELECT sal FROM empWHERE mgr=e.empno)
(o/p:1 row)
What is the difference between the above 2 queries.

sen_sam86

 Profile Answers by sen_sam86 Questions by sen_sam86

• Aug 27th, 2009

How this query is possible i dont know, how the emp number and manager number will be same, i think the query in meaning less r am not understanding properly i dont know,,,, Let some one explain this...!

todeepakmalhotra

 Profile Answers by todeepakmalhotra Questions by todeepakmalhotra

• Sep 30th, 2008

These both are correlated subqueries.In the first one, we are knowing the salaries of employees who are earning less than there manager.In the second one we are knowing about the salaries of?managers who are earning less than their employees whom they manage.

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

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• Aug 11th, 2009

There are three types of conversions 1-  TO_DATE2-  TO_CHAR3-  TO_NUMBERTO_DATE:use to convert charector into data by giving format mask.TO_CHAR:use to convert number into cha...

Answer Question  Select Best Answer

What are the different values for :SYSTEM.MESSAGE_LEVEL and its impact?

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• Aug 11th, 2009

There are 25 Levels of Message in an Oracle Forms.How much cretical error or message is0 -- all errors or message12...25 -- don't shows anyIf we don't wannat show any error  or message to...

Answer Question  Select Best Answer

What is the purpose of redo log files?

harit79

 Profile Answers by harit79 Questions by harit79

• Aug 2nd, 2009

The purpose of redo log file is to record all changes made to the data during the recovery of database.It always advisable to have two or more redo log files and keep them in a  seperate disk, So you can recover the data during the system crash.

Answer Question  Select Best Answer

How we can increae Oracle Database Size?

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

How to detect and prevent row chaining?

Nehasinha

 Profile Answers by Nehasinha Questions by Nehasinha

• Jul 15th, 2009

By increasing the PCT, Row chaining can be avoided.

Answer Question  Select Best Answer

santosh Panigrahi

 Profile Answers by santosh Panigrahi Questions by santosh Panigrahi

• Jul 12th, 2009

Database Block Gets: Finding matching data block in database buffer cache. Consistent Gets: When data need to fetch are valid or available in buffer. It means data are not being modified when again...

Answer Question  Select Best Answer

santosh Panigrahi

 Profile Answers by santosh Panigrahi Questions by santosh Panigrahi

• Jul 12th, 2009

New Feature of Oracle 10g1.Introduction of sysaux tablespace.2.Temporary tablespace grouping.3.Retention guarantee in undo tablespace.4.Introduction of transportable tablespace.5.Introduction of datap...

Answer Question  Select Best Answer

santosh Panigrahi

 Profile Answers by santosh Panigrahi Questions by santosh Panigrahi

• Jul 12th, 2009

Yes, It can.create database link connect to XX identified by XX ;Database link created.

Answer Question  Select Best Answer