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

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

1072

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

1229

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

986

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

1123

what happens on checkpoint? : Sql server database administration

1159

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

1041

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

1018

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

1151

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

952

what is create database syntax? : Sql server database administration

1171

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

1028

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

1191

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

1054

what is dbcc? : Sql server database administration

1087

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

1027

Un-Answered Questions { Databases }

What is pgbouncer in postgresql?

998

How can you access different databases temporarily?

Why is the use of dbms recommended?

1327

What is primary key in dbms?

965

What is orm in mysql?

956

Explain the use of grant option in exp command.

1113

How can you determine what protocol is being used for interconnect traffic?

What are trace files?

1006

What is the use of sql trace?

1008

What is the difference between the application object and session object?

1129

Mention how you can inspect the source code of a function?

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

1025

What are different replication agents and what's their purpose? : sql server replication

1057

How does database replication work?

1044

What are database data types?

967

For More Un-Answered { Databases } Questions Click Here