Oracle General Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies, Accenture,

2 17274

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

Wipro, BeBo Technologies,

7 62839

What are inner join and outer join?

3 8883




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

CSC, TCS, Amdocs,

29 63440

what are Triggers?

TCS,

6 9279

what are stored procedures?

TCS, Wells Fargo,

7 7525

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

TCS, Green Info Solutions,

7 12587

what are views?

TCS,

8 14123




Define 'view' advantage ?

TCS, AZTEC,

2 8747

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

4 8581

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

4 10482

What is a Tablespace?

5 5370

What is SYSTEM tablespace and When is it Created?

2 4784

Explain the relationship among Database, Tablespace and Data file?

4 8096

What is schema?

Cognizant, HCL, Bodhi Global Services,

41 39266


Post New Oracle General Questions






Un-Answered Questions { Oracle General }

why dont we assign not null constraint as table level constraint.

1676


how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

1345


What are the various oracle database objects?

28


What the is the diff between local index and global index. give some example.

553


Why use resource manager in Oracle?

18






Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

1169


query optmization techniques and quwry analyser+projects+ppts

1231


What is SQL Tuning Advisor in Oracle?

18


What are the common oracle dba tasks?

8


In what script is snap$ created? In what script is the scott/tiger schema created?

1540


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

919


Explain an extent?

19


Explain how you would restore a database using RMAN to Point in Time?

1018


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

2640


what happened to the global index when I truncate the data in one of the partition?

928