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

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

1 1190

How to find the service pack installed? : sql server database administration

1 1090

What are recommended options to be used while using db mirroring? : sql server database administration

1 1273

What is service broker? : sql server database administration

1 1054

How to find the version of sql server? : sql server database administration

1 1204

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1 1193

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

1 1063

Where sql server user names and passwords are stored in sql server? : sql server database administration

1 1124

According to you what goes into making the best database administrator? : sql server database administration

1 1048

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1 1412

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

1 1059

What is replication with database mirroring? : sql server database administration

1 1188

What is your recommendation for a query running very slow? : sql server database administration

1 1140

What is stored in the mssqlsystemresource database? : sql server database administration

1 1107

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1 1221

Un-Answered Questions { Databases }

What are the advantages of database?

1011

How to connect php with different port numbers?

1181

What are the types of database explain each of them briefly?

1058

What is an indexed view?

1021

What is in place upgrade in sql server?

1124

Is primary key always clustered index?

1094

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1066

Suppose database is running slow, what will you do?

2591

How to Change a users password from unix shell.

1214

what is collation? : Sql dba

1229

What is temporary table in sql server? Why we use temp table?

1017

How to select all columns of all rows from a table in oracle?

1125

Explain “row_number()” in sql server with an example?

1074

What are the source of constraints?

1007

What are the different subsets of sql?

1648

For More Un-Answered { Databases } Questions Click Here