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

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

962

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

1891

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

914

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

1136

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

993

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

996

what are user defined datatypes? : Sql server database administration

979

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

977

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

997

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

1058

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

1102

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

982

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

1036

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

1117

what are triggers? : Sql server database administration

921

Un-Answered Questions { Databases }

How to insert a new row into a table in oracle?

1176

Can you explain pdq priority?

171

What are two types of data in a database environment?

928

How would you determine who has added a row to a table?

2334

What is the difference between a primary key & a unique key?

1102

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

1067

What is normalization and what are the advantages of it?

997

How can a single instance environment be converted into rac environment and how will they be different?

What is the difference between clustered and non-clustered index in sql?

1026

What is extension and intension?

919

What are 3 types of databases?

978

Is mongodb a language?

Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

983

How can a function retun more than one value in oracle with proper example?

1092

How to connect to sybase database from linux?

1004

For More Un-Answered { Databases } Questions Click Here