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 triggers can be used in mysql?

1025

What are the advantages of mysql?

1007

How to create table with same structure of student table in mysql?

962

Write a query to fetch common records between two tables using mysql?

1038

What is the use of concat() in mysql?

1011

What are the difference between now and current_date in mysql?

1 1453

How to change the database engine in mysql?

1007

How to get a version of mysql?

1060

In mysql, what is the default storage engine?

1023

How to get nth highest salary from table in a mysql?

962

How to create and drop view in mysql?

924

In which year mysql created?

986

How can we get total number of records by query in mysql?

921

What is the difference between char and varchar in mysql?

1131

What is regex in mysql?

1102

Un-Answered Questions { Databases }

What is an explain plan and how does it help in optimizing the sql query?

What does information_schema contain?

823

Which tcl commands are available on the sql server?

1097

What is the difference between inner join and outer join?

1007

Does partitioning improve performance sql server?

995

What are mongodb shards?

How different is ms access and oracle?

1059

You see multiple fragments in the system tablespace, what should you check first?

597

Explain the steps to create and execute a user-defined function in the sql server?

987

How many rows can postgresql handle?

943

How to delete an existing column in a table?

962

what are the nonstandard string types? : Sql dba

1157

Explain oracle insert into command?

1122

Does unique index improve performance?

828

What is a postgresql schema?

860

For More Un-Answered { Databases } Questions Click Here