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 the difference between char and varchar data types? : Sql dba

1109

what tools available for managing mysql server? : Sql dba

1084

what are wild cards used in database for pattern matching ? : Sql dba

1142

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

1017

how to convert dates to character strings? : Sql dba

1169

how is exception handling handled in mysql? : Sql dba

1080

what is transaction? : Sql dba

1007

how to create a new table by selecting rows from another table in mysql? : Sql dba

1095

explain normalization concept? : Sql dba

1045

differentiate between float and double. : Sql dba

1056

how to enter characters as hex numbers? : Sql dba

1041

what are the drivers in mysql? : Sql dba

1020

how to get a list of indexes of an existing table? : Sql dba

957

what is subquery? : Sql dba

1132

what is an extent ? : Sql dba

1099

Un-Answered Questions { Databases }

what are the different types of replication you can set up in sql server? : Sql server database administration

1023

What is pl sql in dbms?

949

Explain what role entity and relationship play in an ER diagram.

1071

What are the main differences between primary key and unique key?

993

What is the difference between min key and max key?

What is a distributed database?

1041

Can we modify approve purchase order?if yes what is navigation?

2010

What security features are available for stored procedure?

1036

How can you customize to mongo shell prompt?

What do you understand by the term 'normalization'?

673

What are the various ingredients of sga?

572

Explain encryption of entire databases without the need for application changes in sql server 2008?

1040

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

2036

What is an external table?

1020

How to insert new line characters into strings?

990

For More Un-Answered { Databases } Questions Click Here