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 stored procedure would you use to view lock information?

1 1036

What are information schema views?

1 1055

What is an entity-relationship diagram (erd)?

1 1352

What is the difference between for auto and for nested?

1 1087

Why it is recommended to avoid referencing a floating point column in the where clause?

1 1036

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1 1148

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

1 1016

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1 1132

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

1 1169

If a table does not have a unique index, can a cursor be opened on it?

1 986

Indexes are updated automatically is the full-text index also updated automatically?

1 1079

How you can minimize the deadlock situation?

1 1105

Can a database be shrunk to 0 bytes, if not, why?

1 1184

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

1 1191

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1 1083

Un-Answered Questions { Databases }

Is there some bulk load or other way to import a lot of data fast?

929

What is the best sql course?

1043

Explain “row_number()” in sql server with an example?

1071

Does group by remove duplicates?

1109

What is sql server query analyzer?

1122

What is a view in sql?

1035

What is standby servers? Explain types of standby servers.

1070

Can delete statement be rollbacked?

1050

How did mongodb get its name?

Can sql servers link to other servers like oracle?

910

what are the advantages of sql ? : Sql dba

1136

What is acid mean in sql server?

1234

What are the advantages of database?

1009

Why and when do stored procedure recompile?

1052

What are the kinds of subquery?

1099

For More Un-Answered { Databases } Questions Click Here