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

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1036

how many clustered indexes can be created on a table? : Sql server database administration

1164

what are different types of backups available in sql server? : Sql server database administration

948

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1078

what happens on checkpoint? : Sql server database administration

1118

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

1003

explain the storage models of olap? : Sql server database administration

974

how to create a scrollable cursor with the scroll option? : Sql server database administration

1105

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

920

what is create database syntax? : Sql server database administration

1120

what type of index will get created after executing the above statement? : Sql server database administration

980

what authentication modes does sql server support? : Sql server database administration

1125

how many layers of tcp/ip protocol combined of? : Sql server database administration

1016

what is dbcc? : Sql server database administration

1043

how to define testing of network layers? : Sql server database administration

988

Un-Answered Questions { Databases }

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2581

What is the use of =,==,=== operators?

1029

Why is normalisation used?

929

How do I save a stored procedure?

1025

Explain activity monitors

1091

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

987

Which are the five query types available in oracle?

966

What is pgrouting?

795

Can a Tablespace hold objects from different Schemes in Oracle?

1055

Does mongodb run on amazon ebs?

How many columns can a table have?

933

What are different types of keys?

1121

What is sql scripting?

1132

change column name and make a unique column so we get no dupes.

993

Explain the steps needed to create a scheduled job?

951

For More Un-Answered { Databases } Questions Click Here