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

Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

20. Using a set operator, display the client number of all clients who have never placed an order.

Wipro,

2252

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

Wipro,

2173

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 01 101 01010

2108

Find top Nth employee from each department in terms of salary?

RealPage,

13 26204

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 8143

How can we add a column to a table without altering the same?

BNP Paribas,

4 22353

Un-Answered Questions { Databases }

What is blob data type in oracle?

1211

What is embedded sql with example?

1099

How many ways to get the current time?

1015

Explain the advantages of rdbms?

981

what do u mean by canvases and alerts?

2061

How do I stop a postgresql console?

928

Explain relationship between jdbc and sybase.

953

How do I view a trc file?

982

How can one get sql*loader to commit only at the end of the load file? : aql loader

1121

Is it possible to have multiple layouts in a report?

1095

What are the various normalizations in database?

1052

How mongodb is better than other sql server databases?

What is key set driven?

1011

How to apply cascading referential integrity in place of triggers?

1096

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1127

For More Un-Answered { Databases } Questions Click Here