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 language structure to add a record to a table?

1 1098

What are the tables in sql?

1 1178

Explain contrast amongst grouped and non-bunched records?

1 1107

How do you open a cluster administrator?

1 1116

What is relationship? What number of sorts of relationship are there?

1 1250

What is database black box testing?

1 1098

What are the transaction properties?

1 1094

What are the different types of normalization?

1 1252

What is the difference between char, varchar and nvarchar?

1 1102

What is the contrast between sql and pl/sql?

1 1218

What authentication modes does sql server support?

1 1184

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1 1150

What do you mean by subquery?

1 1167

What number aggregate functions are accessible there in sql?

1 1156

Define indexes?

1 1108

Un-Answered Questions { Databases }

Why should you use or avoid select * statements?

1105

What is a concurrency problem in dbms?

1049

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

1065

What are the steps in creating a database?

1004

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8225

What are the properties of the transaction?

1069

what are aggregate and scalar functions? : Sql dba

1122

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?

1905

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2346

What is your daily office routine?

2340

What is subquery? Explain the properties of a subquery?

1056

How many concurrent programs you have customized, can you name some of them?

How do I find the sql server version?

1099

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1947

When should you use an instead of trigger?

1042

For More Un-Answered { Databases } Questions Click Here