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 can be the maximum size of an access database?

836

Difference between superior keys and candidate keys?

965

You are required to create a macro that can run action query. What steps will you take?

878

At what levels can data validation be done in microsoft access database?

1048

How are queries run in ms access? List different ways.

782

List some file extensions of microsoft access.

960

What are the protection features in ms access?

893

Explain superior keys and candidate keys. How are they different?

859

What are the uses of append query?

867

Create an append query?

795

The long and short date option in ms access does not show 4 digit years. How would you achieve the mm/dd/yyyy format?

806

How is a developer added to a trusted publishers list?

855

Explain replication manager.

840

I assigned a primary key to my table in microsoft access, I was expecting my data to be sorted. Is that a right approach?

951

What is dynasets in ms access?

899

Un-Answered Questions { Databases }

How to delete multiple rows from a table in oracle?

1078

what is the scenario where you take the database to NoArchivelog mode?

2347

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2369

Name few of the dcl commands in sql?

1025

What is buffer cash and log cache in sql server?

1137

Explain the purpose of indexes?

993

Explain view?

1057

What is latest version of mysql?

1043

What is a csv table?

1020

How to start your 10g xe server from command line?

1082

How do I create a stored procedure in sql server?

1051

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? : Sql server administration

990

Are null values same as that of zero or a blank space?

1043

What do you mean by subquery?

1099

Which is fastest database?

914

For More Un-Answered { Databases } Questions Click Here