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 are the properties and different types of sub-queries?

1026

Is the log file is a part of file group?

1057

What is attribute relationships, why we need it? : sql server analysis services, ssas

990

What is the maximum size of a dimension? : sql server analysis services, ssas

1063

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

1030

What is measure group, measure? : sql server analysis services, ssas

1035

What is data mart? : sql server analysis services, ssas

1078

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

1023

How will you make an attribute not process? : sql server analysis services, ssas

1108

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1069

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1176

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1280

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

973

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1034

What are translations and its use? : sql server analysis services, ssas

1058

Un-Answered Questions { Databases }

What is Sqlpaging in SqlServer 2005 ?

1078

What are the LKM types?

612

How to create a postgresql database?

932

What are built in functions?

1044

Explain the difference between a dynamic and materialized view.

921

what are database files, control files and log files. How many of these files should a database have at least? Why?

881

What are the differences between char and nchar in oracle?

1109

Explain the wait events in statspack report 'db scattered read'?

593

how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.

925

Does mongodb handle application level caching?

Why should I use postgresql?

1029

What is the advantage of index in sql?

989

What is rename in sql?

986

How does pl sql work?

979

Does windows server 2016 come with sql server?

947

For More Un-Answered { Databases } Questions Click Here