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 is slow query log in mysql?

1121

How we can see all indexes defined for a table in mysql?

949

In mysql, what is joins? Explain

982

Who developed mysql?

1034

What is view in mysql?

982

How do I find my mysql username and password?

971

Explain the difference between procedure and function in mysql?

1002

How to delete the repeated records from a table?

990

What is the default port for mysql and how it can change?

1075

What is triggers and how it can be used in mysql?

984

what is the difference between between and in operators in mysql?

1041

What is the difference between timestamp and datetime in mysql?

1063

What are procedures in mysql? Explain

992

Explain the different types of constraints?

959

What are the difference between and myisam and innodb?

1036

Un-Answered Questions { Databases }

query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp

2079

how to do partition in sqlserver

2489

Is primary key an index?

1000

What is the size of mysql database?

952

How to prevent concurrent access to my data?

1043

How do I pipe the output of isql to a file in sybase?

901

You are required to create a macro that can run action query. What steps will you take?

878

What are the restrictions on external table columns?

1068

Which table is left in join?

988

What are the different ways to optimize a sql query?

958

What is database design and development?

1026

How long can an error message be in raiseerror function?

1017

Can you tell which of the following where clauses is faster?

924

what are the types of indexes? : Sql server database administration

1136

Can you type more than one query in the query editor screen at the same time?

1026

For More Un-Answered { Databases } Questions Click Here