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

How many ways we can we find the current date using MySQL?

5 13026

How can increase the performance of MySQL select query?

RV Technologies, Span Systems,

3 12122

The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id

2 4959

What are the advantages and disadvantages of MySQL?

Satyam,

3787

What is the difference between GROUP BY and ORDER BY in Sql?

Creative, Renault Nissan, Trikon Networks,

12 79552

What is the difference between char and varchar data types?

6 48388

How to load data from a text file into a table?

Sasaa,

7 16061

How can we know the number of days between two given dates using MySQL?

Base2 Infotech, Webworks,

2 7858

How can we change the name of a column of a table?

7 11204

How can we change the name and data type of a column of a table?

Google,

9 26714

What are the differences between drop a table and truncate a table?

10 26435

A select query over a large table runs very slow because of the growing number of entries in that table. What different measures could be taken to improve speed?

5 15139

A company wants to store their invoices in a database. They already have their customers and articles in that database. Both customer and article are each identified by an unique integer value. Please create the SQL statements for creating the necessary table(s) for storing the invoices in a MySQL database. An invoice should hold information like invoice number, customer, date, article(s) and quantity etc.

1 4621

For the database from the previous question, please give an SQL query which returns the invoice number of all invoices which contain the article with the number ?1234?. The query should be able to run under a MySQL 4.0 database.

1 3859

How would you backup and restore a big MySQL database? What are the advantages of the approach which you have taken over the others?

4 11276

Un-Answered Questions { Databases }

What is the latest version of postgresql?

949

What are the different types of subquery?

1228

How can I check that whether automatic statistic update is enabled or not?

1108

What is normalization and what are the advantages of it?

1052

What is oracle latest version?

1169

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

1235

What are the types of database explain each of them briefly?

1050

1. Tell me about your self? 2. Latest Project Introduction? 3. Difference between server jobs and parallel jobs? 4. Seq-Seq Explain its behavior and execution mode and which parallelism technique is used? 5. What is padding characters? 6. Seq-Seq, Seq-Copy-Seq which one is the best and efficient? 7. How many reject links do we have to a transformer? 8. How many reject links to join stage? 9. Difference between join and lookup? 10. How to design PX routine? 11. How can we call job in another job? 12. Difference between batch and sequencer? 13. Which Database is used? 14. What is change capture? Give briefing of that? 15. What is change Code? Explain? 16. How you call UNIX in Ds? 17. How do you call JCL in UNIX? 18. How do you pass the job status of one job to another job? Have designed any job sequencer? 19. How do you find a file in existed directory? 20. How can you call parallel jobs in transformer? 21. Execution of jobs in command line? 22. Tuning of sql queries? 23. What is orchestrating metadata? 24. What are junk dimension? 25. What are the third party tools you are used? 26. What are the system variables you have used?

1905

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1124

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1895

How raid can influence database performance?

1110

What is in place upgrade in sql server?

1121

what is schema? : Sql dba

1135

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

1106

Is primary key clustered index?

1013

For More Un-Answered { Databases } Questions Click Here