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 the authentication modes in sql server? : Sql dba

1082

what does it mean to have quoted_identifier on? : Sql dba

1161

what are the different tables present in mysql? : Sql dba

1006

how to extract a unit value from a date and time? : Sql dba

1009

explain commit and rollback in mysql : sql dba

1045

what is unique key constraint? : Sql dba

1065

describe mysql connection using mysql binary. : Sql dba

1084

what is a materialized view? : Sql dba

1083

describe transaction-safe table types in mysql : sql dba

1024

how to add a new column to an existing table in mysql? : Sql dba

1093

what is the difference between union and union all? : Sql dba

1037

what are string data types? : Sql dba

1058

what is blob? : Sql dba

1170

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

984

what is a foreign key ? : Sql dba

1090

Un-Answered Questions { Databases }

what is the difference between primary key and unique key? : Sql dba

1052

What is “namespace” in mongodb?

Explain the wait events in statspack report 'db scattered read'?

602

Name the different type of indexes in sql?

995

What is 1nf in database?

1031

Provide a brief explanation of the functions in postgresql.

825

Why stored procedure is better than query?

968

What do you understand by intension and extension?

934

Can we use views in stored procedure?

1054

How we can create an index in mongodb?

Explain differentiate between a having clause and a where clause?

929

How to find table changes in sql server?

1144

What is the job of the information stored in data-dictionary?

827

what are the types of connection load-balancing?

1019

i am writing a query select EmpNo from Emp how can i call in after parameter form

2145

For More Un-Answered { Databases } Questions Click Here