Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3259)
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

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1087

What is use of attributehierarchyenabled? : sql server analysis services, ssas

1257

What are types of scd? : sql server analysis services, ssas

1038

What is perspective, have you ever created perspective? : sql server analysis services, ssas

936

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

1094

What are the types of processing and explain each? : sql server analysis services, ssas

1167

What is attribute? : sql server analysis services, ssas

1031

Explain the flow of creating a cube? : sql server analysis services, ssas

1070

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

980

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1085

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

1022

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

995

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

1007

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

995

How many types of attribute relationships are there? : sql server analysis services, ssas

1094

Un-Answered Questions { Databases }

How to run a sql statement?

1039

what is hash nonclustered index

987

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

984

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1885

What is the difference between distinct and unique in sql?

964

What triggers long term care?

1060

How can be determining the size of the log files?

594

What is oracle d2k? Why we use it?

What is sql resultset?

1008

What are the grouping functions?

947

How do I find information about the install locations for the various instances running on a computer?

1097

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1123

What privilege is needed for a user to create tables in oracle?

964

Explain what are the different type of segments?

981

What is the importance of three tier architecture?

1111

For More Un-Answered { Databases } Questions Click Here