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

991

What are information schema views?

1000

What is an entity-relationship diagram (erd)?

1236

What is the difference between for auto and for nested?

1025

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

978

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

1076

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

962

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

1056

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?

1122

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

929

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

1038

How you can minimize the deadlock situation?

1057

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

1120

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?

1131

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

1032

Un-Answered Questions { Databases }

What is ims software environment?

924

Why do we use trigger?

1000

What is ISAM?

1134

What is data model in dbms?

928

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2116

Which directory will you copy your new reports, what would be its extension (.rdf or .rex)?

What do you mean by collation recursive stored procedure?

1075

What are aggregate functions in mysql?

1385

What is the difference between executequery () and executeupdate ()?

1059

Equi join and non equi join is possible with sql server?

1037

how to replace not in with not exist?

3750

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2177

Does oracle partitioning improve performance?

1010

How would you configure identities in sybase?

1042

What are indexes in mongodb?

For More Un-Answered { Databases } Questions Click Here