Oracle 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 9820

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

what is the difference between oracle 81,91,11i

Oracle, i2,

2 15541

How client makes connection with server in client/server architecture?

CA,

1 3037

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 3625

For web applications from which version of Oracle is suitable?

1 3523

What are the main diff. between oracle 7.3 and oracle 8i?

1 3371

What is Statement Auditing ?

2 2831

What are the use of Roles ?

3 3231







Un-Answered Questions { Oracle }

How to view all columns in an existing table?

55


What do you understand by oracle forms and why are they required?

59


How to pass parameters to procedures in oracle?

62


What is the purpose of scan?

1


What are the types of locks in database?

1






Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1056


What is the difference between pre-select and pre-query?

69


What are the parameters that we can pass through a stored procedure?

50


What is package and main advantages?

1


Is truncate autocommit in oracle?

24


How to shutdown your 10g xe server?

59


Mention in rac what files should be created on shared storage?

1


How to export several tables together?

60


How do we represent comments in oracle?

60


How does oracle handle read consistency?

62