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

What is a data source or ds? : sql server analysis services, ssas

1023

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

1026

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

1148

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

1058

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

1035

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

1075

What is amo? : sql server analysis services, ssas

1108

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

1055

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

1027

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

1110

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

986

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

1071

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

1049

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

1219

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

1125

Un-Answered Questions { Databases }

What happens on checkpoint?

1042

Can sql servers link to other servers like oracle?

858

Why are sql stored procedures used?

1070

what is index? : Sql dba

1012

What is the use of count function in mysql?

1043

What is the source code of a program?

1084

What skills do you need to be an administrator?

582

What is pg server?

912

how to write customizations in po

1631

What port does mongodb use?

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

631

Does user triggers have entry for trigger with compilation errors?

1049

What is difference between sid and service name in oracle?

973

how you can move data or databases between servers and databases in sql server? : Sql server administration

998

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

2016

For More Un-Answered { Databases } Questions Click Here