-
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...
-
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...
-
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...
-
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. ...
-
DBMS Relation
In DBMS, What is a relation?
-
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
-
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...
-
RMAN Backup
-
What is the advantage of specifying WITH GRANT OPTION in the GRANT command?
vinoth
- Jul 15th, 2011
Giving privilege to the user
sreekanth.g
- Jun 22nd, 2011
Assume that table 'emp' is created by user scott.by using grant command he can grant privileges to other users.If he want to provide a privileges to grant the privileges to other usershe has to grant a privileges with grant option.
-
Private,Public database link
How to give private and public database links ?What is syntax for that ?What means mutation in oracle??
dbxplorer
- Jul 21st, 2011
Database link is the pointer that allow users to access other user's object in remote database. This is one way communication path using database links. Private db links: CREATE DATABASE LINK link_na...
-
Repair TNSnames.ora File
How to repair the tnsnames.ora file.
File is completely corrupted and you get network adapter errors and TNS resolve error after restarting the machine.dbxplorer
- Jul 21st, 2011
Delete or rename the older file and try to recreate it using "netmgr" using proper information of your database.
-
RMAN Catalog
What is the use of catalog and no catalog in RMAN?
gyanudba
- Jul 29th, 2011
Rman with catalog means our target database registered in catalog and its used for recovery purpose. its containing metadata about to database.
rman with no catalog means metadata stored in controlefile through the controlfile we can do the recovery. -
Bdump, cdump & udump
Explain in detail what are bdump, cdump & udump?
gyanudba
- Jul 29th, 2011
background dump (bdump) :--. > bdump is used for all the issues raised related to background process in our database. its also contain alert .log which contain all activities and issues related to da...
-
Remote Backup
What is meant by Remote Backup?
gyanudba
- Jul 29th, 2011
Suppose as a client u connected to server with the help of some third party tool and you are going to take backup from your server then that is called remote backup.
-
How do I delete responsibility in Oracle 11i from backend and frontend? How is backend going to effect ?
Oracle Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans