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

Mention the 3 ways to get a count of the number of records in a table.

1 1032

Mention a few common trace flags used with sql server?

1 986

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

1 1032

What do you understand by coalesce in sql server?

1 1140

What do you understand by mirroring and mention the advantages of the mirroring?

1 1130

Mention the differences between local and global temporary tables.

1 1115

What do you understand by check constraint in sql server?

1 1030

What is the tcp/ip port on which sql server runs?

1 1255

What do you understand by intent locks?

1 1068

Explain log shipping and mention its advantages.

1 1099

Explain log shipping?

1 1084

What do you understand by the analysis services in sql server?

1 993

What are the steps you must follow to hide sql server instances?

1 1037

What are the advantages of mirroring?

1 1048

What do you understand by user-defined function in the sql server?

1 1016

Un-Answered Questions { Databases }

Can you index views?

946

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

1000

How do I remove duplicates in two columns?

1162

Why and when do stored procedure recompile?

1042

What are the types of database explain each of them briefly?

1038

Do we need to rebuild index after truncate?

1112

How efficient you are in oracle and SQL server?

1234

What is acid mean in sql server?

1218

what is dbms? : Sql dba

1048

What are the advantages of database?

1003

What is the latest version of postgresql?

941

What are the kinds of subquery?

1087

Is primary key clustered index?

1000

What is sql server query analyzer?

1111

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

For More Un-Answered { Databases } Questions Click Here