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 the physical representation for a many-to-many relationship?

1091

What is an application role and explain a scenario when you would use one?

1031

Which data type cannot be used as a parameter in a udf?

987

In which database can extended stored procedures be added?

914

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

978

How you can make a parameterized view?

1032

Can an extended stored procedure be called from inside a user-defined function?

1086

How long can an error message be in raiseerror function?

1020

Write the fastest query to find out how many rows exist in a table?

1145

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

1032

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

1022

Explain the cube operator?

1024

How would you design a database for an online site, which would average a million hits a day?

1029

What are the constraints on severity level in raiseerror?

1007

Why does this query return 0?

1025

Un-Answered Questions { Databases }

What are reports usually used for?

1054

how Neo4j can be helpful in detecting Brute Force Attack?

What is server replication?

1010

Can we have multiple index on a table?

924

What is Record-at-a-time?

852

How is sql server used?

973

What is pdo in php mysql?

957

How can we identify the resources for which the sessions are waiting?

Can group functions be used in the order by clause in oracle?

1017

What is microsoft access runtime?

865

Can we call stored procedure in trigger?

960

How to determine who is and change the owner of database?

952

Do I need to pay for mysql?

914

What is System R? What are its two major subsystems?

836

Explain the difference between procedure and function in mysql?

1007

For More Un-Answered { Databases } Questions Click Here