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

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

949

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

1124

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

1156

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

928

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

1169

what is a cursor? : Mysql dba

1101

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

1080

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

986

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

1082

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

948

Write a program using the select statement, while loop.

966

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

1189

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

990

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

1058

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

1176

Un-Answered Questions { Databases }

how Data is stored in a file so that Direct Searching can be performed

1061

where the connection string store in the database

2125

Why indexing is used in database?

990

What is a unique key?

1111

What is an Oracle database Partial Backup?

1208

How do I find the database name in mysql?

1012

Which nosql database is best?

1025

What are property classes?

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

1052

What are the advantages of postgresql?

886

What is sqlca in powerbuilder?

1067

Is BCNF better than 2NF & 3NF? Why?

1106

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

2604

What are the advantages of mysql?

1043

Enlist the advantages of sql.

1055

For More Un-Answered { Databases } Questions Click Here