Oracle Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies,

2 14564

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

Wipro, BeBo Technologies,

7 58528

What are inner join and outer join?

3 7418




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

CSC, TCS, Amdocs,

29 59251

what are Triggers?

TCS,

4 7303

what are stored procedures?

TCS,

6 5733

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

TCS, Green Info Solutions,

7 10564

what are views?

TCS,

7 12122

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

Oracle, i2,

2 14029

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

CA,

1 2043

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

2 2628

For web applications from which version of Oracle is suitable?

1 2832

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

1 2725

What is Statement Auditing ?

2 2178

What are the use of Roles ?

3 2406







Un-Answered Questions { Oracle }

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

2786


What is the recommended interval at which to run statspack snapshots, and why?

1456


now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

922


what do u mean by canvases and alerts?

797


Which parameters are optional in init.ora parameter file?

856


what is difference between sql plus and sql*plus? (not sql and sql plus).

2263


Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

847


candidate key is subset of super key but not vice-verse explain

625


Where in the Oracle directory tree structure are audit traces placed?

1011


With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?

1152


Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

638


What is the exact use of Collections?

735


what is meant by magic query

869


QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

730


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

711