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

What is the usage of regular expressions in mysql?

1 967

Which command is used to view the content of the table in mysql?

1 991

How many columns can you create for an index?

1 1016

What does "i_am_a_dummy flag" do in mysql?

1 1021

What is the usage of "i-am-a-dummy" flag in mysql?

1 1229

What is sqlyog?

1 1104

How many triggers are possible in mysql?

1 1043

Write a query to retrieve a hundred books starting from 20th.

1 1585

In which language mysql has been written?

1 1415

What is a trigger in mysql?

1 1118

What is the difference between database and table?

1 1073

What is the query to display top 20 rows?

1 1095

What is save point in mysql?

1 1041

What is the difference between heap table and temporary table?

1 1182

What are the advantages of myisam over innodb?

1 1043

Un-Answered Questions { Databases }

what is the difference between openrowset and openquery?

1188

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1129

What are the kinds of subquery?

1101

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2177

please send me oracle pl/sql exp resume. and also faqs...

2567

Why should you use or avoid select * statements?

1107

Can we rollback truncate?

1072

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

What is an indexed view?

1018

How raid can influence database performance?

1114

Design database draw er diagram for a certain scenario ?

4650

What is subquery? Explain the properties of a subquery?

1056

What is sql or structured query language?

1220

Have you written applications to retrieve stored images in a table?

1084

what is spatial nonclustered index

1054

For More Un-Answered { Databases } Questions Click Here