Oracle General Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies, Accenture,

2 17731

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

Wipro, BeBo Technologies,

7 63526

What are inner join and outer join?

3 9078




What are joins..how many types of joins are there?

CSC, TCS, Amdocs,

29 64254

what are Triggers?

TCS,

6 9640

what are stored procedures?

TCS, Wells Fargo,

7 7852

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

TCS, Green Info Solutions,

7 12871

what are views?

TCS,

8 14510




Define 'view' advantage ?

TCS, AZTEC,

2 8864

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

4 8788

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

4 10689

What is a Tablespace?

5 5531

What is SYSTEM tablespace and When is it Created?

2 4891

Explain the relationship among Database, Tablespace and Data file?

4 8352

What is schema?

Cognizant, HCL, Bodhi Global Services,

41 40144


Post New Oracle General Questions






Un-Answered Questions { Oracle General }

What are a cluster and non-cluster index?

35


What is a relational database management system?

33


Differentiate between post-database commit and post-form commit?

41


What is a read only transaction in oracle?

41


What happens to the current transaction if the session is killed?

32






Who developed oracle & when?

30


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.

2351


What do you mean by cdb and pdb in oracle 12c?

32


How a tablespace is related to data files?

39


Please explain oracle data types with examples?

39


What is system global area (sga) in oracle?

35


Is postgres faster than oracle?

7


What is the oracle implicit cursor?

38


Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

816


How to save query output to a local file?

37