Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

How to create DSN..Explain?

Accenture, BeBo Technologies, Infosys,

2 35717

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

BeBo Technologies, Wipro,

7 73981

What are inner join and outer join?

3 25470

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

Amdocs, CSC, TCS,

29 97066

what are Triggers?

TCS,

7 28438

what are stored procedures?

TCS, Wells Fargo,

7 26877

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

Green Info Solutions, TCS,

7 31487

what are views?

TCS,

8 34975

Define 'view' advantage ?

AZTEC, TCS,

2 11659

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

4 13195

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

4 14801

What is a Tablespace?

5 9962

What is SYSTEM tablespace and When is it Created?

2 7577

Explain the relationship among Database, Tablespace and Data file?

4 12624

What is schema?

Bodhi Global Services, Cognizant, HCL,

41 63188

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a oracle database?

1055

Please explain oracle data types with examples?

1069

How to view the data files in the current database?

1098

How to drop an index?

959

Explain enable novalidate constraint.

1081

Â How to use an oracle sequence generator in a mapping?

1075

What is the difference between postgresql and oracle?

1048

Difference between varchar and varchar2 data types?

1184

what is the scenario where you take the database to NoArchivelog mode?

2331

What is a trace file and how is it created in oracle?

1058

Can multiple columns be used in group by in oracle?

988

List out the difference between commit, rollback, and savepoint?

1031

What is Library Cache in Oracle?

1142

How to join two tables in a single query using oracle?

997

How to commit the current transaction in oracle?

1120

For More Un-Answered { Oracle General } Questions Click Here