Oracle Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies,

2 11756

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

Wipro, BeBo Technologies,

7 52920

What are inner join and outer join?

3 5965

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

CSC, TCS, AMDOC,

27 54283

what are Triggers?

TCS,

4 5931

what are stored procedures?

TCS,

6 4330

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

TCS, Green Info Solutions,

6 8959

what are views?

TCS,

7 10433

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

Oracle, i2,

2 12557

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

CA,

1 1357

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

2 2094

For web applications from which version of Oracle is suitable?

1 2363

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

1 2231

What is Statement Auditing ?

2 1674

What are the use of Roles ?

2 1864



Un-Answered Questions { Oracle }

1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD

530


If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

623


What is an SQL FORMS ?

1201


WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

640


what is reindexing?

46


where the dff data will be stored

786


when All datafiles related to a Tablespace are removed ?

619


How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

645


What are the built-in functions used for sending Parameters to forms ?

1780


what is insert all statement in sql

3302


what is difference between inner join & nested query or subqueries

1334


How many number of columns can a RECORD GROUP have ?

658


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

429


what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

752


what is the scripts in data base?

525