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

Write a sql query to delete duplicate records from a table called table1

1 1114

Which data type columns are the best candidates for full-text indexing?

1 1036

What stored procedure can you use to display the current processes?

1 965

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1 1120

What is database replication?

1 1236

Can you force a query to use a specific index?

1 1013

How you can get a list of all the table constraints in a database?

1 1035

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

1 1006

Write a sql query to sort on different column name according to the parameters passed in the function?

1 978

What will happen if a column containing char type data is changed to the nchar data type?

1 1176

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1 1242

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

1 1093

How you can move data or databases between servers and databases in sql server?

1 1119

What is a fill factor?

1 1162

How can you find out which stored procedures are recompiling?

1 977

Un-Answered Questions { Databases }

How many concurrent programs you have customized, can you name some of them?

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

1052

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1127

What is the current version of postgresql?

1168

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1292

Have you used lexical parameters in reports?

Can you index views?

952

What are the kinds of subquery?

1099

How efficient you are in oracle and SQL server?

1251

what is bcp? When does it used? : Sql dba

1053

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1021

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1207

what are all the common sql function? : Sql dba

1125

how to start mysql server? : Sql dba

1260

What is standby servers? Explain types of standby servers.

1072

For More Un-Answered { Databases } Questions Click Here