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 are bind variables?

1 1168

what is the sequence of firing triggers in forms?

1 1713

What is a relationship and what are they?

1 1264

What is the difference between having clause and where clause?

1 1137

What are the types of join and explain each?

1 1136

What is the difference between local and global temporary table?

1 1109

When are we going to use truncate and delete?

1 1049

what is bcp? When is it used?

1 1205

Compare sql & pl/sql

1 1246

When is the update_statistics command used?

1 1213

What is cte?

1 1043

What are all the different types of indexes?

1 1216

What is the syntax and use of the coalesce function?

1 1247

Explain correlated query work?

1 1131

Explain the steps needed to create the scheduled job?

1 1120

Un-Answered Questions { Databases }

How to select all columns of all rows from a table in oracle?

1124

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?

2560

How do I find the sql server version?

1099

How do I create a trace in sql server?

1113

What is oracle latest version?

1171

What are different types of constraints?

996

What are the advantages of database?

1010

What are the two main functions of queries in databases?

1525

What are the source of constraints?

1006

What kind of problems occurs if we do not implement proper locking strategy?

1494

What is the difference between upgrade and migration in sql server?

1179

what are the advantages of sql ? : Sql dba

1139

what is sql server agent? : Sql dba

1179

What is your daily office routine?

2340

How do I find query history in sql server?

1020

For More Un-Answered { Databases } Questions Click Here