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

Can you load data into multiple tables at once? : aql loader

1 1143

Can one improve the performance of sql*loader? : aql loader

1 1122

Can you selectively load only those records that you need? : aql loader

1 1128

How does one use sql*loader to load images, sound clips and documents? : aql loader

1 1257

How can you get sql*loader to commit only at the end of the load file? : aql loader

1 1085

How does sql*loader handles newline characters in a record? : aql loader

1 1109

What is the difference between the conventional and direct path loader? : aql loader

1 1217

Can you skip header records while loading? : aql loader

1 1125

How can you load multi line records? : aql loader

1 1148

What is sql*loader and what is it used for? : aql loader

1 1291

How can one get sql*loader to commit only at the end of the load file? : aql loader

1 1146

What is the difference between the conventional and direct path loads? : aql loader

1 1511

How you improve the performance of sql*loader? : aql loader

1 1085

How can you load microsoft excel data into oracle? : aql loader

1 1252

When I run the sql server 2000 setup, it just hangs. What do I do?

1 1162

Un-Answered Questions { Databases }

How to convert numeric expression data types using the cast() function?

1145

What is a view in sql?

1036

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

1061

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?

1983

How can we solve concurrency problems?

1120

What are the different subsets of sql?

1648

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2350

Are you familiar with user exits in reports?

Can we do dml on views?

1032

How raid can influence database performance?

1114

What are different types of constraints?

996

how to start mysql server? : Sql dba

1263

Have you created fact table and dimension tables?

709

What is clustered index

1083

Does group by remove duplicates?

1112

For More Un-Answered { Databases } Questions Click Here