-
Archive Files
What are archive files? What are the uses with archive files?
pardhudb
- Mar 23rd, 2011
Before discussing ?about archive files we will be discuss about redolog files ,these redologfiles records every operation done on the database, ?so when the datafiles are damaged, we can get complet...
GAUTAMJANGRA
- Mar 16th, 2011
Archives files are files which are placed together in a bunch for any particular work. Benefit of this is there is no chance of missing of files while transfer from one place to another, also you...
-
RAC Database
What difference does it make to a Oracle developer while using RAC ? Would/Should he realise that it is a RAC Database ?
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
-
DBMS Relation
In DBMS, What is a relation?
-
What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?
mrrichardson
- Jul 12th, 2010
Structured Query LanguageSQL- Is a languagekeywords cannot be abbreviatedSQL *PLUS - More complex than SQLIs a command line tool propietary to Oracle where you can run both SQL and PL/SQL stateme...
Jeremy
- Aug 24th, 2007
SQL*Plus is a client program and interactive interpreter designed for interacting with Oracle databases. SQL is a standard data access language used to describe data access to a variety of databases. ...
-
Drop a Datafile
How to drop or delete a datafile which has been miskenly added to a tablespace?
aravindhreturns
- Apr 23rd, 2010
In most environments, this is done using Oracle Import/Export utility since certain privileges are restricted to the DBAs. Steps are below:- 1) Export the data 2) Drop the Tablespace, 3) Import the da...
-
Database size
How to see the Database size and version and RMAN size and version?
aravindhreturns
- Apr 23rd, 2010
To find the ORACLE database size, you need to make a small calculation. The result of these two syntaxes below can be used to find the total allocated size of the database:- select sum(bytes)/10737418...
-
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...
-
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...
-
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...
-
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
-
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)
-
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...
-
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.
-
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...
-
What are the components are in The System Global Area
-
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.
-
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.
-
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...
-
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...
-
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.
Oracle Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans