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 indexes in mysql?

1042

In which language it is written?

965

What is mysqlcheck do?

1041

How to use mysqldump to create a copy of the database?

1069

What mysql -u john -p command does?

988

List some mysql advantages and disadvantages?

974

Explain timestamp?

979

What is mysql default port number?

1017

What is “i_am_a_dump” flag in mysql?

1081

What is difference between group by and order by clause?

974

Explain the difference between mysql and mysql interfaces in php?

1106

how many types of object cache in neo4j?

what is object cache in neo4j. how many types of they are?

List some popular graph databases?

what is object cache in neo4j?

Un-Answered Questions { Databases }

Can we insert data into materialized view?

959

Do you need a commit after ddl statements?

565

Explain snapshot replication.

962

Explain about analysis services?

1061

Explain the difference between physical and logical data independence?

927

What are the constraints in odi?

637

What company owns postgresql?

1042

What is Tab Query Whats its advantage over Sql-Query

4598

How to select an exiting database using mssql_select_db()?

1001

how can you perform lookup range in lookup stage expalin in detail?

1946

How can we migrate from SQL server to SQL Azure?

113

What are inner and outer joins examples of both?

979

What are the importance of partitioning in dbms?

975

Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?

968

How can we determine what objects a user-defined function depends upon?

1024

For More Un-Answered { Databases } Questions Click Here