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 are date and time data types in ms sql server?

1110

How to execute a sql statement using odbc_exec()?

1161

What is a database table?

992

How to create a stored procedure with a statement block in ms sql server?

1084

How fixed length strings are truncated and padded?

997

How to create a testing table with test data in ms sql server?

1094

How to delete a database in ms sql server?

1250

Can you roll back the ddl statement in a trigger?

992

What are character string data types in ms sql server?

1268

How to modify existing triggers using "alter trigger"?

1030

How to delete an existing row with delete statements in ms sql server?

1114

How to transfer an existing table from one schema to another schema in ms sql server?

995

How to run sql server 2005 books online on your local system?

967

Can you pass expressions to function parameters?

1113

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1019

Un-Answered Questions { Databases }

How do you flush privileges?

985

Can we insert delete data in view?

958

What do you mean by sga and how is it different from pga?

Is oracle an open source?

1097

What is the current root password of mysql?

936

Is a view faster than a stored procedure?

987

What are the types of database schema? : sql server analysis services, ssas

1148

What is difference between materialized view and view?

925

How to run sql statements through the web interface?

1060

What is join and how many types of joins?

844

What happens when unicode strings concatenate with non-unicode strings?

1114

how would you get the current date in mysql? : Sql dba

986

How do I start mysql in linux?

915

What is a constraint? Tell me about its various levels.

1184

What is database white box testing?

1135

For More Un-Answered { Databases } Questions Click Here