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 35499

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

BeBo Technologies, Wipro,

7 73586

What are inner join and outer join?

3 25250

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

Amdocs, CSC, TCS,

29 95804

what are Triggers?

TCS,

7 28150

what are stored procedures?

TCS, Wells Fargo,

7 26531

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

Green Info Solutions, TCS,

7 31138

what are views?

TCS,

8 34602

Define 'view' advantage ?

AZTEC, TCS,

2 11495

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

4 12988

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

4 14599

What is a Tablespace?

5 9724

What is SYSTEM tablespace and When is it Created?

2 7450

Explain the relationship among Database, Tablespace and Data file?

4 12422

What is schema?

Bodhi Global Services, Cognizant, HCL,

41 61639

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to convert a string to a date in oracle database?

999

What is a user account in oracle?

1063

What is the recommended interval at which to run statspack snapshots, and why?

2860

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?

1861

What are the attributes of cursor?

987

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2070

Explain what does a control file contain?

1030

How can I combine multiple rows into a comma-delimited list in oracle?

998

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1843

Is oracle a programming language?

934

How to use "in out" parameter properly?

997

Use of an integrity constraint is better to validate data. Explain

973

What are the tools for Oracle ?

1005

What privilege is needed for a user to create tables in oracle?

900

How to apply filtering criteria at group level in oracle?

985

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