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

Is ssrs support other database except ms sql server?

1 152

What are drilldown reports?

1 176

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

1 136

What are sub reports and how to create them?

1 156

What is snapshot report?

1 184

What are the limitations/drawbacks or ssrs 2008 r2?

1 166

What is query parameter in ssrs?

1 180

What is a dataset and what are the different types of datasets?

1 151

List out what other servers you can use with ssrs?

1 161

What is tablix?

1 180

What is reportserver and reportservertempdb ?

1 175

What is encryption key?

1 153

What is cached report?

1 160

What are parameterized reports? What are cascading parameters in ssrs reports?

1 181

What is the name of reporting services config file and what’s it’s used for?

1 166

Un-Answered Questions { Databases }

what is spatial nonclustered index

1048

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

2545

Can we do dml on views?

1024

Is microsoft getting rid of access?

877

what is collation? : Sql dba

1211

What is self contained sub query?

1131

How to start an oracle instance?

1086

What are the properties of the transaction?

1059

How to put more than 1000 values into an oracle in clause?

1095

How do I find query history in sql server?

1005

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?

1841

How did mongodb get its name?

Can we shrink data file in sql server?

1112

What is a coalesce function?

1261

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

1053

For More Un-Answered { Databases } Questions Click Here