Oracle General Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Accenture, BeBo Technologies, Infosys,

2 22970

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

BeBo Technologies, Wipro,

7 72271

What are inner join and outer join?

3 12574

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

Amdocs, CSC, TCS,

29 80581

what are Triggers?

TCS,

7 15112

what are stored procedures?

TCS, Wells Fargo,

7 13707

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

Green Info Solutions, TCS,

7 18155

what are views?

TCS,

8 21368

Define 'view' advantage ?

AZTEC, TCS,

2 10889

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

4 12123

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

4 13836

What is a Tablespace?

5 8860

What is SYSTEM tablespace and When is it Created?

2 6889

Explain the relationship among Database, Tablespace and Data file?

4 11689

What is schema?

Bodhi Global Services, Cognizant, HCL,

41 57480


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to use "for" statements in oracle?

827


I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2104


What is the use of file param in imp command?

928


How to calculate date and time differences in oracle?

792


How to experiment a data lock in oracle?

826


Explain about your project and its relation to the current job position you are applying to?

793


What are the differences between interval year to month and interval day to second?

795


How to fetch the row which has the max value for a column?

773


How to view existing locks on the database?

800


Is there any function in oracle similar like group_concat of mysql?

831


What are the differences between primary key and unique key?

764


What privilege is needed for a user to insert rows to tables in another schema?

817


How to call a sub procedure?

842


What is difference between cartesian join and cross join?

822


When do you get a .pll extension in oracle? Explain its importance

807