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 the advantages of using stored procedures?

972

What is the command to change the recovery model?

1061

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1047

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

1003

Will count(column) include columns with null values in its count?

1110

What is isolation levels?

1055

What are the default system databases in sql server 2000?

1042

What does the not null constraint do?

1122

How to rebuild master databse?

1098

What command would you use to create an index?

1077

What command do we use to rename a database?

1096

Do comments need to go in a special place in sql server 2005?

876

What is the purpose of the model database?

1043

What is the sql server 2000 version number?

1097

Name 3 ways to get an accurate count of the number of records in a table?

1057

Un-Answered Questions { Databases }

Explain where clause?

1009

Is a primary key indexed?

873

Tell some of the most important uses of ms access?

858

Is there a google equivalent to microsoft access?

834

What are the built in functions of sql?

1051

How do you create a table in mysql workbench?

947

Can we call a function containing dml statements in a select query?

993

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1179

What is difference between primary key and foreign key?

918

What happens if ntwdblib.dll is missing on your machine?

1163

What are SSL and TSL protocols?

1013

How do I copy a table in mysql?

959

What is trigger price?

1008

How to put more than 1000 values into an oracle in clause?

1052

What are different types of schemas?

963

For More Un-Answered { Databases } Questions Click Here