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

4 8462

What is a view?

6 9599

What is an Index?

Yardi Software,

3 9850

What are the types of indexes available with SQL Server?

Standard Bank,

2 8157

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

Infogain,

9 38507

What are cursors?

8 11527

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 19084

Which TCP/IP port does SQL Server run on?

2 10070

From where can you change the default port?

3 7115

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

15 25634

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

Shriram,

2 10389

What is the use of DBCC commands?

NA,

4 9482

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,

2587

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 4830

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

World Tech, Yardi Software,

11 29992

Un-Answered Questions { Databases }

How do I open an access 2007 file?

887

How to create a new table in oracle?

1239

How do you set a primary key?

1074

How do you delete a table?

1126

How to check if a record exists in a mysql database php?

940

What is table valued function and scalar valued functions?

1168

Is it ok to shrink transaction log?

1060

In mysql, what is the default storage engine?

1064

List out the components of logical database structure of oracle database.

1098

How to enable/disable indexes?

1129

how do you tune the slow running queries in oracle db , explain the methodology

3247

Is mongodb orm?

What are the types of stored procedures in an sql server?

1040

Do you know exporting and importing utility?

1112

What is update locks?

940

For More Un-Answered { Databases } Questions Click Here