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 a data source or ds? : sql server analysis services, ssas

1 1072

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1 1080

What are the types of database schema? : sql server analysis services, ssas

1 1227

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

1 1116

What is attribute hierarchy? : sql server analysis services, ssas

1 1093

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1 1133

What is amo? : sql server analysis services, ssas

1 1156

What are the difficulties faced in cube development? : sql server analysis services, ssas

1 1121

What is data source view or dsv? : sql server analysis services, ssas

1 1081

How will you add a dimension to cube? : sql server analysis services, ssas

1 1154

How you provide security to cube? : sql server analysis services, ssas

1 1034

What is partition, how will you implement it? : sql server analysis services, ssas

1 1134

What is factless fact table? : sql server analysis services, ssas

1 1115

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1 1275

What is surrogate key? : sql server analysis services, ssas

1 1175

Un-Answered Questions { Databases }

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

8226

what is schema? : Sql dba

1138

What are the properties of the transaction?

1069

How to define array in mongoose schema?

Which statement is used in a select query for partial matching?

1239

How can we solve concurrency problems?

1120

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1208

what are aggregate and scalar functions? : Sql dba

1124

Have you used lexical parameters in reports?

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

1061

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

1013

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

Were you involved in any data conversion, which one?

Can one drop a column from a table?

1082

Are you familiar with user exits in reports?

For More Un-Answered { Databases } Questions Click Here