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 is the difference between a local and a global temporary table?

1140

What is difference between delete & truncate commands?

1104

What stored by the msdb?

1016

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1086

What command must you use to include the not null constraint after a table has already been created?

1173

Can I run multiple instances of sql server 2000 at the same time on one computer?

1088

What are the different types of replication are there in sql server 2000?

1055

What are system databases into sql server (2005/2008)?

1018

How many database files are there in sql server 2000?what are they?

1070

What are sparse columns?

1035

How can we rewrite sub-queries into simple select statements or with joins?

995

What does the on delete cascade option do?

1033

How are the unique and primary key constraints different?

1093

What are the advantages of using cte?

1045

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1131

Un-Answered Questions { Databases }

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

2208

What is the purpose of update statistics and scope_identity() function?

1117

State few characteristics of pl/sql?

991

Differentiate between extension & intension?

1443

What happens if you lost a data file?

1051

How many file formats are supported to export data?

1232

What is connection pooling in oracle?

984

Can you import Microsoft Excel data to SSRS?

135

What is the full form of dba?

630

Why do we use joins?

1063

what is a schema in sql server 2005? : Sql server database administration

1046

What is format trigger?

2086

What are the triggers in sql?

1121

What is building blocks of client/server?

1124

What is the difference between oracle media recovery and crash recovery?

1191

For More Un-Answered { Databases } Questions Click Here