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

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

1013

how to trace the traffic hitting a sql server? : Sql server database administration

1959

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

948

what are the types of indexes? : Sql server database administration

1188

what kind of lan types do you know? : Sql server database administration

1023

what's the difference between delete table and truncate table commands? : Sql server database administration

1041

what are user defined datatypes? : Sql server database administration

1018

explain databases and sql server databases architecture? : Sql server database administration

1017

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

1051

do you know how to configure db2 side of the application? : Sql server database administration

1101

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1139

how to determine the service pack currently installed on sql server? : Sql server database administration

1026

what are the different types of replication you can set up in sql server? : Sql server database administration

1063

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1153

what are triggers? : Sql server database administration

954

Un-Answered Questions { Databases }

What is a snapshot log?

1053

What are the variable types?

683

Explain steps of normalization?

1067

What is normalization? What number of normalization shapes are there?

1163

How does a covering index work?

1013

explain engines?

959

How many concurrent queries can mysql handle?

951

Are stored procedures faster than queries?

996

How many types of triggers exist in pl/sql?

1141

What is the difference between function and procedure in pl/sql?

1142

What is the difference between rank and dense_rank?

1169

What are sql functions? Describe in brief different types of sql functions?

1193

How to insert multiple rows with a subquery?

1193

Is mysql workbench a dbms?

1060

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4511

For More Un-Answered { Databases } Questions Click Here