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

How to change a login name in ms sql server?

1098

How to assign null values to variables or columns?

990

Can we update data in a view?

1041

What are out-of-range errors with date and time literals?

1045

How to rebuild indexes with alter index ... Rebuild?

1136

What samples and sample databases are provided by microsoft?

1057

What happens if strings are casted into wrong code pages in ms sql server?

1122

How to disable a login name in ms sql server?

1141

What are the character string functions supported by sql server 2005?

1026

How to connect sql server management studio express to sql server 2005 express?

1052

What happens if you delete a table that is used by a view?

1005

What happens if you are trying to access a schema not owned by you?

987

How to move database physical files in ms sql server?

1045

How to get a list of columns in a view using the "sp_help" stored procedure?

1056

How to drop an existing table with "drop table" statements in ms sql server?

1098

Un-Answered Questions { Databases }

What is an Entity?

868

Can two tables have same primary key?

991

What do you understand by the terms entity, entity type, and entity set in dbms?

922

If we use sum function in mysql, does it return sum of that row or for that column?

994

What is sub query and its properties?

989

What is procedure overloading in oracle?

1072

How do I pipe the output of isql to a file in sybase?

901

What is database management definition?

929

What is building blocks of client/server?

1120

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1901

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

589

How to convert numbers to characters in oracle?

1046

What is the purpose of a database table?

958

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17680

What are the types of tables in database?

1005

For More Un-Answered { Databases } Questions Click Here