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

What's the difference between file and database?

1 1747

What's the difference between star and snow flake schema?

1062

What are fact tables and dimension tables ? What is dimensional modeling and star schema design

902

What are codd rules?

977

How to see table's field formats or description of table .

905

How to update info already in a table and delete a row(s) from a table.

888

how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

897

How to delete a table.

943

How to dump one database for backup.

964

How to load a csv file into a table

1051

How to delete a database from mysql server.

1082

how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

929

How to list or view all databases from the mysql server.

951

How to update a root password.

967

How we get sum of column.

1031

Un-Answered Questions { Databases }

What is building blocks of client/server?

1127

Which is the latest version of sql server and when it is released?

1135

Explain Normalization and DE normalization

1134

How many types of objects are there?

1036

How to create a new table in mysql?

1062

aht is the difference b/w network & hierarchial & relational dbms????

2231

What is the difference between a primary key and a unique key? Are they the same?

1087

What is the difference between migration and upgradation in sql server?

1110

What is Session Tasks?

617

How to delete the repeated records from a table?

997

What is the difference between count 1 and count (*) in a sql query?

1013

Explain neo4j index?

How can you determine if an oracle instance is up from the operating system level?

586

What is replication? : sql server DBA

1200

what is the functionality of the function htmlentities? : Sql dba

980

For More Un-Answered { Databases } Questions Click Here