Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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

1118

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

1113

what are null values? : Sql dba

1016

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

1082

is mysql query is case sensitive? : Sql dba

1174

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

1102

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

1121

what is cross join? : Sql dba

1059

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

1093

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

1083

what is a primary key? : Sql dba

1090

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

1089

what are the advantages a stored procedure? : Sql dba

1026

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

1073

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

1057

Un-Answered Questions { Databases }

I want to export the data date to date from oracle database then what can i do?

2682

State some of the uses of MS Access?

952

How to drop a tablespace?

1095

What are the lock types?

1028

Explain concepts of analysis services?

1021

What do you mean by stored procedures?

1073

What is the role of binary large object in informix?

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

1649

Is mysql a database?

1002

What is the dba role in oracle?

635

How to concatenate two binary strings together?

1187

how can you process messages in order asynchronously?

1039

Difference between inner join vs where ?

1101

What are the three basic rules which are to be followed for the relational model of the database?

1074

How to return query output in html format?

986

For More Un-Answered { Databases } Questions Click Here