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 convert character strings to dates? : Sql dba

1060

what is the stuff function and how does it differ from the replace function? : Sql dba

1052

what are null values? : Sql dba

953

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1033

is mysql query is case sensitive? : Sql dba

1100

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1034

how to dump a table to a file with 'mysqldump'? : Sql dba

1035

what is cross join? : Sql dba

996

what are the types of join and explain each? : Sql dba

1037

what are the advantages and disadvantages of views in a database? : Sql dba

1043

what is a primary key? : Sql dba

1033

can a stored procedure call itself or recursive stored procedure? : Sql dba

1029

what are the advantages a stored procedure? : Sql dba

976

how to analyze tables with 'mysqlcheck'? : Sql dba

1013

how do you know the version of your mysql server? : Sql dba

1004

Un-Answered Questions { Databases }

How to select distinct on multiple columns?

855

What do you mean by “trigger” in sql?

1079

How to convert a unicode strings to non-unicode strings?

1102

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1933

What is the function of create command?

865

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1110

How to list or view all databases from the mysql server.

921

What are different types of tables in sql?

998

What are the advantages of sql stored procedure?

1074

Can sql server 2016 run on windows 7?

916

What are the important tasks of common oracle dba?

560

how could you increase the speed of ontape/onbar backups ?

What is sybase infomaker?

958

How to provide default values to function parameters?

1139

Why does profiler use in mongodb?

For More Un-Answered { Databases } Questions Click Here