Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

Wipro,

2085

23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.

Wipro,

3 5546

24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.

Wipro,

2 5251

25. Display the client number and the value of the highest value order placed by that client.

Wipro,

2 5540

26. Display the earliest shipping date in the format: DD/MON/YYYY

Wipro,

5 8363

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

Wipro,

1 4435

2. Display the post code and the total number of purchase orders placed with creditors in that post code.

Wipro,

2105

3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.

Wipro,

2264

4. Using a set operator, display the creditor number of all creditors who have ever been paid.

Wipro,

2 5240

5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.

Wipro,

6 8141

What is the difference between RBBMS & DBMS?

4 9306

THE MAIN CONCEPT OF PROGRAMMIN TYPE?

1 4382

Which Oracle App Is Most Popular One ?

3 5382

whats the difference between join command and Cartesian product using example?

1 5380

what is domain in database and its benefits?

2387

Un-Answered Questions { Oracle }

How to install oracle database 10g xe?

1066

What is a proxy object?

1111

Is java required for oracle client?

1049

How can you determine the number of sqlnet users logged in to the unix system?

614

How to assign query results to variables?

1102

How to use subqueries in the from clause in oracle?

1170

Â What are the oracle DML commands possible through an update strategy?

1109

How to upsert (update or insert into a table)?

1044

What is a system tablespace and when it is created?

1020

Explain oracle 12c new features for developers?

1127

What is background process in Oracle?

1142

How to write date and time interval literals in oracle?

1087

What is oracle archived redo log?

639

What is the difference between formal parameters and actual parameters?

1160

How can we find out the current date and time in oracle?

1134

For More Un-Answered { Oracle } Questions Click Here