Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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?

1 1203

What is difference between delete & truncate commands?

1 1179

What stored by the msdb?

1 1071

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

1 1149

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

1 1292

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

1 1139

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

1 1114

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

1 1079

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

1 1146

What are sparse columns?

1 1101

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

1 1064

What does the on delete cascade option do?

1 1087

How are the unique and primary key constraints different?

1 1160

What are the advantages of using cte?

1 1097

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

1 1187

Un-Answered Questions { Databases }

How do I start sql server 2017?

1013

Does group by remove duplicates?

1112

Can we shrink data file in sql server?

1123

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1897

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2354

Which statement is used in a select query for partial matching?

1240

What versions of clipper does netlib support?

1090

What is your daily office routine?

2343

How efficient you are in oracle and SQL server?

1255

Is there some bulk load or other way to import a lot of data fast?

931

Can we rollback truncate?

1072

Can one drop a column from a table?

1084

What is sql server query analyzer?

1126

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1132

How to use values from other tables in update statements using oracle?

1153

For More Un-Answered { Databases } Questions Click Here