Oracle General Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies, Accenture,

2 17903

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

Wipro, BeBo Technologies,

7 63794

What are inner join and outer join?

3 9192




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

CSC, TCS, Amdocs,

29 64654

what are Triggers?

TCS,

6 9819

what are stored procedures?

TCS, Wells Fargo,

7 8023

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

TCS, Green Info Solutions,

7 13047

what are views?

TCS,

8 14720




Define 'view' advantage ?

TCS, AZTEC,

2 8915

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

4 8867

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

4 10780

What is a Tablespace?

5 5597

What is SYSTEM tablespace and When is it Created?

2 4948

Explain the relationship among Database, Tablespace and Data file?

4 8475

What is schema?

Cognizant, HCL, Bodhi Global Services,

41 40454


Post New Oracle General Questions






Un-Answered Questions { Oracle General }

Explain about functional dependency and its relation with table design?

48


Explain a data segment?

74


What is the difference between translate and replace in oracle?

69


Calculate difference between 2 date / times in oracle sql?

51


How to count duplicated values in a column in oracle?

46






Explain the use of consistent option in exp command.

54


Can you tell me how to add new column in existing views?how?How is possible?

370


What is the difference between truncate & delete command?

64


What is a private synonym?

545


How to connect asp pages to oracle servers?

52


What is a user role in oracle?

55


What is a trigger and what are its types?

60


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

46


What are the most common interview questions on ETL Testing for experience?

89


What is control file used for?

63