1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT

College School Exams Tests, DELL,

5 8686

What is integrity and what is constraint??Explain with example

Google,

1703

difference between procedures and function?

IBM,

7 8069

wirte the syntax of update query?

IBM,

3 4267

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

 1443

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

 3352

where we have to use ON clause and where we have to use USING clause in JOINS

 2 3231

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

Wipro,

1368

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.

Wipro,

1652

1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.

Wipro,

2 5375

2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.

Wipro,

2 3802

3. Display all the client numbers in the ORDER table. Remove duplicates.

Wipro,

1 3538

4. Display the order number and client number from the ORDER table. Output the result in the format. Client ordered

Wipro,

1 3999

5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.

Wipro,

3 3876

6. Display the client name and order date for all orders using the traditional method.

Wipro,

1753

Un-Answered Questions { Oracle }

How to use attributes of the implicit cursor in oracle?

565

How do you generate file output from sql?

264

What is the most common database language that a db administrator needs to know?

269

What are a cluster and non-cluster index?

577

Differentiate between post-database commit and post-form commit?

545




Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1553

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

1650

How to rename an index?

589

Are These Dff's Flexible?

741

What is the Repository and how many types of repository?

277

You see multiple fragments in the system tablespace, what should you check first?

285

Can we insert data in view oracle?

542

What is auto invoicing? : oracle accounts receivable

663

i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame

2571

What is the use of lockboxes? : oracle accounts receivable

661

For More Un-Answered { Oracle } Questions Click Here