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 are dml commands?

1 1081

What is dense_rank?

1 995

What is the use of stored procedures?

1 1142

What is rownum and rowid?

1 1091

What does count (*) mean?

1 1000

What are all the ddl commands?

1 1258

What are the two types of periodical indexes?

1 1002

What are the qualities of 2nf?

1 1113

What is trigger explain it?

1 1094

What are triggers and its types?

1 1141

What are basic techniques of indexing?

1 1463

What is the difference between inner join and left join?

1 1059

What does dml mean?

1 1055

What's the difference between a primary key and a clustered index?

1 1056

What are inner and outer joins examples of both?

1 1028

Un-Answered Questions { Databases }

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

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

2174

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1850

What is the current version of sql?

1091

What is sql server query analyzer?

1117

What is normalization and what are the advantages of it?

1050

What is the current mysql version?

1086

What is the primary use of the model database?

1144

Suppose database is running slow, what will you do?

2587

Can we shrink data file in sql server?

1117

What are the kinds of subquery?

1093

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2695

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

1082

Explain system functions or built-in functions? What are different types of system functions?

1055

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

2564

For More Un-Answered { Databases } Questions Click Here