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

Mention the uses of stored procedures.

1011

What is the difference between left and right outer join?

1115

Explain the commands in sql server?

1099

Write an sql query for deleting duplicate rows?

1040

What is difference between clustered index and non clustered index?

1126

Write query to return all rows sql?

1112

What is difference between foreign key and unique key?

1052

State the difference between union and union all?

988

What do you understand by recursive stored procedures?

1048

What are the different types of nosql databases? Give some examples.

What do you mean by a replica set in mongodb?

Write the syntax for creating a collection and dropping a collection in mongodb.

List some alternatives to mongodb?

List the important features of mongodb.

What is the use of a namespace in mongodb?

Un-Answered Questions { Databases }

What are the functions of mysql?

991

How do I connect to postgresql database from windows?

904

How to convert a numeric expression from one data type to another?

1100

Explain the terms database and dbms?

987

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

969

Is mongodb support replication?

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

1006

What is meant by postgresql?

840

What is a join query?

1007

Explain the use of grant option in imp command.

1085

How to use transact-sql statements to access the database engine?

1127

What are triggers mysql?

949

Compare and contrast between sql and sql server and explain its various functions?

1019

What is cursors?

1264

What is the placeholder column?

For More Un-Answered { Databases } Questions Click Here