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

Whether any commands are used for months calculation? If so, what are they?

1 1167

What is difference between truncate and delete?

1 1131

What are the benefits of ordbms?

1 1162

What is a oracle database?

1 1136

What are the various oracle database objects?

1 1218

Explain the characteristics of oracle dba?

1 1202

Explain integrity constraint?

1 1235

In which language oracle has been developed?

1 1157

Difference between varchar and varchar2 data types?

1 1304

What is hash cluster in oracle?

1 1287

What is the parameter mode that can be passed to a procedure?

1 1133

How many memory layers are in the oracle shared pool?

1 1287

What are nested tables?

1 1252

How do we get field detail of a table?

1 1151

What are the roles of dba?

1 1161

Un-Answered Questions { Databases }

what is schema? : Sql dba

1138

What are the kinds of subquery?

1101

Design database draw er diagram for a certain scenario ?

4650

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

1129

what is spatial nonclustered index

1054

What is temporary table in sql server? Why we use temp table?

1013

Were you involved in any data conversion, which one?

Are you familiar with user exits in reports?

Explain system functions or built-in functions? What are different types of system functions?

1060

What is oracle latest version?

1171

How do I find query history in sql server?

1020

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?

1208

Can you index views?

953

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?

1908

How can you append an identity column to a temporary table?

1067

For More Un-Answered { Databases } Questions Click Here