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 main difference between ‘between’ and ‘in’ condition operators?

1224

How to make a remote connection in a database?

994

Can we write a distributed query and get some data which is located on other server and oracle database?

1247

Explain the first normal form(1nf)?

1048

What is a non-clustered index?

1020

Explain the relational database management system (rdbms)?

1115

What is checkpoint in sql server?

1182

What is normalization and denormalization in sql server?

1033

Explain “not null constraint” in sql server?

1063

Explain indexing and what are the advantages of it?

1048

Can we hide the definition of a stored procedure from a use?

1252

Can we add an identity column to decimal datatype?

1019

Why use sub query in sql server and list out types of sub queries?

1019

What is the native system stored procedure to execute a command against all databases?

1053

List out the differences between the clustered index and non-clustered index in sql server?

1022

Un-Answered Questions { Databases }

Explain table and field in sql?

1084

What are new features postgre 9.1?

1000

What is odi studio?

612

What are the tools provided in oracle enterprise manager?

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1139

Are databases stored on servers?

1056

What is the difference between varchar and nvarchar datatypes?

1107

List the different index configurations possible for a table?

951

How to verify a user name with sqlcmd tool?

1096

how to show all tables with 'mysql'? : Sql dba

1132

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

986

Explain about relationships and look up fields?

967

Can one drop a column from a table?

1036

Briefly explain what is literal? Give an example where it can be used?

1069

How to open a cursor variable?

1061

For More Un-Answered { Databases } Questions Click Here