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 5134

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

Wipro,

2368

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

Wipro,

1 4239

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

Wipro,

1 3751

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

Wipro,

2 4562

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 6970

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

Wipro,

2394

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

Wipro,

1 3945

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

Wipro,

2 4726

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

Wipro,

1 5662

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

Wipro,

2361

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

Wipro,

1 4132

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

Wipro,

1 4011

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 5705

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 6583

Un-Answered Questions { Databases }

How to use sql*plus built-in timers?

1270

What is use of trigger?

992

What are different types of joins in sql?

1102

What is procedure and function in sql?

1049

Can the old files in the ‘movechunk’ directory be removed?

How are sql commands classified?

1145

What is a behavioral trigger?

1027

How to insert large data in mongodb?

How do I setup a database connection?

1060

How to connect Azure federated root database and apply federation in entity framework?

109

Tell me what is the difference between locking and multi-versioning?

1090

What are referenced objects? Explain the importance of referencing.

What do you mean by dba?

611

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

2014

What is assignment operator in pl sql?

1091

For More Un-Answered { Databases } Questions Click Here