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 deploy, process and build? : sql server analysis services, ssas

1 1193

How will you hide an attribute? : sql server analysis services, ssas

1 1043

What is role playing dimension with two examples? : sql server analysis services, ssas

1 1077

What is cube dimension? : sql server analysis services, ssas

1 1069

What is named query? : sql server analysis services, ssas

1 1042

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1 1093

What is rolap and its advantage? : sql server analysis services, ssas

1 1373

Illustrate physical database architecture in brief? : sql server architect

1 844

Explain what are the database objects? : sql server architect

1 1020

Explain the truncate command? : sql server architect

1 960

Do you know what the restrictions applicable while creating views are? : sql server architect

1 868

What is model database? : sql server architect

1 979

What are page splits? : sql server architect

1 997

What is raid and what are different types of raid configurations? : sql server architect

1 1042

Explain what are the restrictions that views have to follow? : sql server architect

1 909

Un-Answered Questions { Databases }

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1897

Equi join and non equi join is possible with sql server?

1131

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1847

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

1903

What is the difference between upgrade and migration in sql server?

1180

How can we solve concurrency problems?

1120

What is a view in sql?

1038

How to connect php with different port numbers?

1181

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

1145

Can delete statement be rollbacked?

1053

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

1063

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

8227

What are the kinds of subquery?

1103

What kind of problems occurs if we do not implement proper locking strategy?

1495

Have you created fact table and dimension tables?

710

For More Un-Answered { Databases } Questions Click Here