-
Row Chaining
How to detect and prevent row chaining?
-
Oracle Instance
What is an Oracle Instance? Where it is present and How does it perform?
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.
-
Oracle Database Size
How we can increae Oracle Database Size?
-
Purpose of Redo Log Files
What is the purpose of redo log files?
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.
-
Different values for SYSTEM.MESSAGE_LEVEL
What are the different values for :SYSTEM.MESSAGE_LEVEL and its impact?
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...
-
What are the date, character, converstion functions in oracle?
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...
-
Query Performance
Which one gives better performance,
co-related subquery or inline views? Why?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.
-
Multi Row Sub-Queries
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
- 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
- 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.
-
PGA_AGGREGRATE_TARGET Parameter
What is PGA_AGGREGRATE_TARGET parameter?
-
-
What are the components are in The System Global Area
-
Offload Query Processing
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?
-
How we can insert the structure of given table in another table?
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...
-
How to check intact, state of a particular index, what are the impacts of invalid index? How to recover it?
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.
-
Oracle Stand Alone Procedure
How does a stand alone procedures differ from that of other procedures?
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...
-
Identify DML Error
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
- 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
- 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)
-
Parent Table
A table which consist of atleast one primary or Unique key is called as Parent Table.
True / False (Justify)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
- 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
-
Control File Restore
How to restore the control file by using RMAN backup?
aravindhreturns
- Apr 22nd, 2010
Use these two methods to get the control file from autobackup:- (This applies only if you have configured AUTOBACKUP ON)One:-First, Login to RMAN (RMAN Target /)Set the DBID by querying v$database (SE...
-
Start Up Information
In which file we can see start up information?
aravindhreturns
- Apr 22nd, 2010
I will give you three options as im unsure of what your requirement is:-If you're talking about a flatfile which contains the startup information, Well it is obviously the alert logfile. It can be fou...
-
TableSpace Space
How to find out how much space a tablespace has remaining?
aravindhreturns
- Apr 22nd, 2010
The total size of the tablespace can be determined through DBA_DATA_FILES. Likewise, free size of the tablespace can be determined through DBA_FREE_SPACE. So you can simply do this, Subract you can si...
Oracle Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans