Oracle General Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies, Accenture,

2 17068

What is the difference between SQL, DDL, and DML?

Wipro, BeBo Technologies,

7 62538

What are inner join and outer join?

3 8763

What are many types of joins are there?

CSC, TCS, Amdocs,

29 62954

what are Triggers?


5 9072

what are stored procedures?

TCS, Wells Fargo,

6 7332

what are many types of index's are there and what are they?

TCS, Green Info Solutions,

7 12377

what are views?


7 13906

Define 'view' advantage ?


2 8680

What are the components of Physical database structure of Oracle Database?

4 8465

What are the components of Logical database structure of ORACLE database?

4 10344

What is a Tablespace?

5 5251

What is SYSTEM tablespace and When is it Created?

2 4714

Explain the relationship among Database, Tablespace and Data file?

4 7924

What is schema?

Cognizant, HCL, Bodhi Global Services,

41 38700

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

how to clone 9i Database on to 10g Database.


1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE


Which environment variables are absolutely critical in order to run the OUI?


What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar


WHAT IS ecc 6.0


if you ctreate table identity


I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.


Hi Can any one tell me what are the API's used in requisition import.


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?


ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process


what's query optimization and without use of IN AND Exist can we get another way data from query


1) Does oracle have any table which contain all the exceptions and it's code internally?


How can we create the complete backup of data in the oracle.


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?


What is snapshot is too old? Give and example for better understand.