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 are the kinds of subquery?

1033

What is normalization and what are the advantages of it?

1003

What are the properties of the transaction?

1031

What is sql or structured query language?

1163

Why use identity in sql server?

1125

What is a coalesce function?

1212

What are the different subsets of sql?

1570

List the ways in which dynamic sql can be executed?

1033

What is subquery in sql?

1090

List some case manipulation functions in sql?

1047

Which sql server table is used to hold the stored procedure script?

968

What is the significance of master, tempdb and model databases?

1098

Explain alternate key, candidate key and composite key in sql server?

924

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1344

How to find the second highest salary of an employee?

1201

Un-Answered Questions { Databases }

what are the disadvantages of mysql? : Sql dba

1169

What are the functions used to encrypt and decrypt the data present in mysql?

1128

Can we use where clause with group by?

922

Where can you find the error log information? : sql server database administration

1044

What is sql language?

1176

what is top in tsql? : Transact sql

1141

Suppose database is running slow, what will you do?

2536

What are properties of the transaction?

1015

What view would you use to determine free space in a tablespace?

2240

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

1022

How does pgadmin connect to remote database?

994

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1151

What do you mean by an execution plan? Why is it used? How would you view it?

951

What's the difference between clustered and non-clustered indexes?

988

How to write a query with a left outer join in ms sql server?

1002

For More Un-Answered { Databases } Questions Click Here