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 is a trigger?

4 8333

What is a view?

6 9436

What is an Index?

Yardi Software,

3 9710

What are the types of indexes available with SQL Server?

Standard Bank,

2 8054

What is the basic difference between clustered and a non-clustered index?

Infogain,

9 38225

What are cursors?

8 11228

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 18910

Which TCP/IP port does SQL Server run on?

2 9989

From where can you change the default port?

3 6996

Can you tell me the difference between DELETE & TRUNCATE commands?

15 25205

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

Shriram,

2 10277

What is the use of DBCC commands?

NA,

4 9329

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

iSoft,

2527

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 4744

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

World Tech, Yardi Software,

11 29686

Un-Answered Questions { Databases }

What is default value database?

1018

What does it mean to be in union?

936

Which is faster subquery or join?

1228

What is compression - row-level and page-level compression?

921

What is the main component of ms access database?

789

How to write pl sql in postgresql?

910

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1077

Explain what is row_number function?

1046

How large can a postgresql database be?

840

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1274

What is the difference between ‘having’ clause and a ‘where’ clause?

1042

What is default password for postgres?

874

Can you explain the 'between' clause?

1132

how can we know the count/number of elements of an array? : Sql dba

1066

What is sql select statement?

1038

For More Un-Answered { Databases } Questions Click Here