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 to include comments in sql statements?

972

What are numeric data types?

1006

What are ddl statements in mysql?

1076

What is 'mysqlshow'?

1081

How many sql ddl commands are supported by 'mysql'?

1146

What are the differences between char and nchar?

1118

How many sql dml commands are supported by 'mysql'?

989

What are the differences between char and varchar?

1120

How to enter numeric values as hex numbers?

988

Explain what is mysql?

1049

How to use case expression?

967

How to show all tables with 'mysql'?

1017

How many ways to get the current time?

981

How to convert dates to character strings?

1093

How to drop an existing index in mysql?

1119

Un-Answered Questions { Databases }

How do I add a primary key in pgadmin?

849

What is database architecture? : SQL Server Architecture

1057

What is a select query statement in oracle?

981

How to get the query of a table in sql server?

911

what changed between the previous version of sql server and the current version? : Sql server database administration

1022

What is a dbms wizard?

1033

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

962

Explain the scenarios or situations under which progress database creates new index entry for a record?

1049

Can we use mongodb with java?

Explain system functions or built-in functions? What are different types of system functions?

994

Which statement is used in a select query for partial matching?

1198

i have windows-xp processor with P4 system. whenever I tried to download foxpro for windows 2.6 on windows XP, my operating system failed to install foxpro for windows 2.6.please. how could i download , install & run foxpro for windows 2.6 easily on windows XP ?

2048

How is a developer added to a trusted publishers list?

854

What is the current version of postgresql?

1082

I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.

3996

For More Un-Answered { Databases } Questions Click Here