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,

1 2263

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,

1 2178

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,

1 2090

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 5567

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 5273

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

Wipro,

2 5551

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

Wipro,

5 8387

1 01 101 01010

1 2114

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

RealPage,

13 26288

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

Wipro,

1 4440

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

Wipro,

2110

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

Wipro,

2276

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

Wipro,

2 5253

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 8185

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

BNP Paribas,

4 22372

Un-Answered Questions { Databases }

What are the properties of the transaction?

1059

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2202

What is sql server query analyzer?

1112

please send me oracle pl/sql exp resume. and also faqs...

2554

What is the current version of postgresql?

1144

Can sql servers link to other servers like oracle?

900

What is a scheduled job or what is a scheduled task?

1022

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2035

what are all the common sql function? : Sql dba

1114

Disadvantages of the indexes?

1207

Can we rollback truncate?

1059

How to put more than 1000 values into an oracle in clause?

1095

How did mongodb get its name?

What is the current version of sql?

1082

What is the best sql course?

1031

For More Un-Answered { Databases } Questions Click Here