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

What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?

1 4049

What is RULE-based approach to optimization ?

1 5441

What is COST-based approach to optimization ?

5 9110

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

2 7470

What is a Procedure ?

3 8268

What is difference between Procedures and Functions ?

Hi Caliber IT,

6 10750

What are the differences between Database Trigger and Integrity constraints ?

4 18499

What is Distributed database ?

2 9791

What is Two-Phase Commit ?

3 6086

Describe two phases of Two-phase commit ?

2 4482

What is the mechanism provided by ORACLE for table replication ?

1 3981

What is a SQL * NET?

2 4739

What are the basic elements of Base configuration of an oracle Database ?

1 5883

What are the factors causing the reparsing of SQL statements in SGA?

1 4266

What is the use of Snapshot?

2 5470

Un-Answered Questions { Databases }

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? IBM 1. What is virtual dataset? 2. How do you handle reject link to a peek stage? 3. What is transaction table? 4. Which one is the efficient from the following? a. ODBC enterprise b. Oracle enterprise 5. How can you extract data from excel sheet? Do you know how to parameterize, this option? 6. Six pages of complex query I have, how do you simplify this query? 7. Difference between dataset and lookup file set?

1976

Can delete statement be rollbacked?

1050

What is a view in sql?

1035

What are the two main functions of queries in databases?

1522

Why should you use or avoid select * statements?

1103

What is the difference between for xml raw and for xml auto?

1108

how to start mysql server? : Sql dba

1258

How do I remove duplicates in two columns?

1177

what is dbms? : Sql dba

1057

Disadvantages of the indexes?

1217

how many tables will create when we create table, what are they? : Sql dba

1139

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

1008

what is the difference between openrowset and openquery?

1186

do you know how to configure db2 side of the application? : Sql server database administration

1117

Why use identity in sql server?

1189

For More Un-Answered { Databases } Questions Click Here