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

Write a query to create a database and a table?

1 970

How to determine the location of the data directory?

1 1033

What is the purpose of -> in the mysql terminal?

1 1198

What you can use regular expression for in mysql? Support your answer with an example?

1 987

How would concatenate strings in mysql?

1 1124

What is difference between mysql_connect and mysql_pconnect?

1 1134

what is the procedure to configure the application of mysql?

1 1139

Where’s database data actually stored? Is there a way to see the files which are stored?

1 1052

Write a query to stop mysql in unix

1 1123

What does the file with the extension: frm, myd, and myi contain?

1 1010

What are enums used for in mysql?

1 1070

How database are managed?

1 1079

When to use order by in delete statement?

1 1101

Why to use char instead of varchar in the database?

1 1323

How can you make a database as your current database?

1 1175

Un-Answered Questions { Databases }

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

2211

Have you written applications to retrieve stored images in a table?

1087

Why we use the openxml clause?

1075

How to define array in mongoose schema?

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

2052

Why use identity in sql server?

1195

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2090

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?

1914

Disadvantages of the indexes?

1222

When should you use an instead of trigger?

1049

Have you used lexical parameters in reports?

what is dbms? : Sql dba

1061

Can sql servers link to other servers like oracle?

915

Is microsoft getting rid of access?

885

List out the different types of locks available in sql server?

1049

For More Un-Answered { Databases } Questions Click Here