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

can you elaborate on blob and text in mysql? : Mysql dba

897

how to display nth highest salary from a table in a mysql query? : Mysql dba

1067

what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba

1101

can you tell how can you display the maximum salary in sql? : Mysql dba

868

what is the difference between gui testing and database testing? : Mysql dba

1100

what is a cursor? : Mysql dba

1026

Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba

1029

how can you test for null values in a database? : Mysql dba

940

what are the different tables present in mysql? : Mysql dba

1018

can you tell what are the different set operations available in mysql? : Mysql dba

895

Write a program using the select statement, while loop.

916

What are the functions used to encrypt and decrypt the data present in mysql?

1112

What is the difference between a heap table and temporary table?

946

Can you tell how many values can set the function of mysql to consider?

991

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1127

Un-Answered Questions { Databases }

What is the difference between truncate and delete? Why is one faster?

651

How to loop through a cursor variable?

1092

What are sql server procedures?

990

What is cte sql?

1002

What is a synonym for manipulation?

1005

How to check if value already exists in mysql database in php?

891

how to select first 5 records from a table? : Sql dba

983

Is database a hardware or software?

1004

what is error ora-03113: end-of-file on communication channel?

1168

Does mongodb support foreign key constraints?

How to define a cusotmer as a supplier in ORACLE R12

2232

What are the built in functions in sql server?

988

Differentiate table scan from index scan.

1033

How to create a store procedure with encryption?

1011

Explain how to integrate the ssrs reports in application?

1018

For More Un-Answered { Databases } Questions Click Here