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 are myisam tables? : Sql dba

1032

how to increment dates by 1 in mysql? : Sql dba

978

what is sql in mysql? : Sql dba

1192

how to show all tables with 'mysql'? : Sql dba

1118

how many columns can be used for creating index? : Sql dba

946

how to rename an existing table in mysql? : Sql dba

1064

Mention the differences between substr and charindex in sql server.

1050

Write an sql query to find first weekday of the month?

919

What do you understand by triggers and mention the different types of it?

936

When do you think a developer should use sql server-based cursors?

1047

Mention the differences between having and where clause.

1057

Explain the usage of floor function in sql server.

964

What do you understand by replication in sql server?

1061

What do you understand by hotfixes and patches in sql server?

991

Mention the different authentication modes in sql server.

1055

Un-Answered Questions { Databases }

How many types of normalization? What is the use of it?

1138

What is foreign key in access?

855

Is mongodb object oriented?

What is merge replication?

1105

Can we insert data if clustered index is disabled?

939

What is SDL (Storage Definition Language)?

800

How to see the create table statement of an existing table?

1048

What are the types of Knowledge Modules?

596

How many types of privileges are available in sql?

1350

What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?

563

How big can a postgres database be?

915

How to add a new column to an existing table in mysql?

995

List some of the rules that apply to creating and using a ‘view’

888

What are temporal tables in sql server 2016?

883

how to enter binary numbers in sql statements? : Sql dba

972

For More Un-Answered { Databases } Questions Click Here