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

Mention what are different methods to trace the pl/sql code?

1 1337

What problem one might face while writing log information to a data-base table in pl/sql?

1 1281

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1 1209

What is the plv (pl/vision) package offers?

1 1125

What is the function that is used to transfer a pl/sql table log to a database table?

1 1088

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1 1071

Mention what is the function that is used to transfer a pl/sql table log to a database table?

1 1053

How can you save or place your msg in a table?

1 1061

What are the benefits of pl/sql packages?

1 1182

What are different methods to trace the pl/sql code?

1 1188

What pl/sql package consists of?

1 1162

What does plv msg allows you to do?

1 1201

Mention what is the plv (pl/vision) package offers?

1 1184

What is the use of function "module procedure" in pl/sql?

1 1257

When you have to use a default "rollback to" savepoint of plvlog?

1 1267

Un-Answered Questions { Databases }

How to Change a users password from unix shell.

1208

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1207

What are different types of constraints?

995

Have you created fact table and dimension tables?

696

what is dbms? : Sql dba

1053

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

1184

What is a coalesce function?

1275

what is schema? : Sql dba

1127

What is your daily office routine?

2333

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

1041

How do I remove duplicates in two columns?

1174

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?

1901

How to rebuild the master database?

1154

what are aggregate and scalar functions? : Sql dba

1122

How to connect php with different port numbers?

1171

For More Un-Answered { Databases } Questions Click Here