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 has stored procedures in sql and how we can use it?

1129

What is rdbms data?

973

What is action query?

950

Which are the several popular graph databases?

Why do we need database management?

1022

What is sub-query in sql server? Explain its properties.

1134

What is the size of transaction log file?

989

What is rank () in sql?

999

How to enter numeric values as hex numbers?

1037

Define fragmentation.

939

How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

1091

How do I exclude a column in sybase?

947

Where the procedures are stored in database?

892

Does google use mongodb?

How to create a login account in ms sql server to access the database engine using "create login" statements?

1198

For More Un-Answered { Databases } Questions Click Here