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

How to select distinct on multiple columns?

874

what is table? : Sql dba

1078

what is text? : Sql dba

1086

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1204

how to use myisamchk to check or repair myisam tables? : Sql dba

988

what is an alias command? : Sql dba

1129

how to select unique records from a table? : Sql dba

1132

how to install mysql? : Sql dba

1134

what is the different between now() and current_date()? : Sql dba

1049

what is normalization? : Sql dba

1096

write an sql query to find names of employee start with 'a'? : Sql dba

1056

what are the authentication modes in sql server? How can it be changed? : Sql dba

1456

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1150

what is the difference between clustered and non clustered index in sql? : Sql dba

1150

what are the advantages of using stored procedures? : Sql dba

1124

Un-Answered Questions { Databases }

Why use stored procedures?

1106

You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.

602

5. Explain about relational algebra.

2205

What is cascade in sql?

981

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1023

What is a ‘namespace’?

What are the various editions of sql server 2017 that are available in the market?

910

What is snapshot replication?

1073

Explain what are commit and rollback in sql?

951

I am designing an Access database form. how can I get my next control in the form to be automatically selected?

854

How to select an oracle system id (sid)?

1086

can you tell the order of sql select statement? : Mysql dba

929

Explain parameter file in oracle.

1056

Explain the structure of objectid in mongodb.?

Data table as parameter in sql server?

1073

For More Un-Answered { Databases } Questions Click Here