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

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 5164

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

Wipro,

1 2376

7. Repeat query (7) but also display all clients who have never ordered anything.

Wipro,

1 4270

8. Display the client name and order date for all orders using the natural join keywords.

Wipro,

1 3760

9. Display the client name and order date for all orders using the JOIN . . . USING method.

Wipro,

2 4576

10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.

Wipro,

3 6988

11. Display the client number and name and the client number and name of the person who referred that client.

Wipro,

1 2404

12. Display the client name in upper case only and in lower case only.

Wipro,

1 3955

13. Display the second to fifth characters in each client name.

Wipro,

2 4747

14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth

Wipro,

1 5677

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

Wipro,

1 2365

16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string .

Wipro,

1 4162

17. Display the order number and average item cost for each order.

Wipro,

1 4026

18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client has placed orders to the value of

Wipro,

2 5727

19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.

Wipro,

2 6608

Un-Answered Questions { Databases }

Why and when do stored procedure recompile?

1044

How did mongodb get its name?

how to start mysql server? : Sql dba

1249

How to select all columns of all rows from a table in oracle?

1108

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1180

How raid can influence database performance?

1095

If a cursor is open, how can we find in a pl/sql block?

1228

Is primary key clustered index?

1003

how many tables will create when we create table, what are they? : Sql dba

1131

Explain “row_number()” in sql server with an example?

1062

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2174

what is spatial nonclustered index

1050

Where can you add custom error messages to sql server?

1190

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

2545

how to use regular expression in pattern match conditions? : Sql dba

1096

For More Un-Answered { Databases } Questions Click Here