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

how you can get the list of largest tables in a database? : Sql server administration

1 1133

can a database be shrunk with users active? : Sql server administration

1 1084

is it important for a database administrator to understand the operating system and file access? : Sql server administration

1 1097

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1 1197

How you can get a list of all the table constraints in a database? : Sql server administration

1 1123

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

1 1029

can an automatic recovery be initiated by a user? : Sql server administration

1 1013

how can a database be repaired? : Sql server administration

1 1035

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

1 1069

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1 1347

what does the automatic recovery do? : Sql server administration

1 1106

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1 1160

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

1 1061

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

1 1022

how can you check the level of fragmentation on a table? : Sql server administration

1 1058

Un-Answered Questions { Databases }

How to enter binary string literals in ms sql server?

1235

List out the different types of locks available in sql server?

1045

what is sql server agent? : Sql dba

1175

What is a view in sql?

1035

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1124

How to define array in mongoose schema?

Why and when do stored procedure recompile?

1052

define sql insert statement ? : Sql dba

1094

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1291

What is an indexed view?

1018

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2098

What are the advantages of database?

1009

what is spatial nonclustered index

1054

How to write a left outer join with the where clause in oracle?

1149

Is inner join faster than left join?

1273

For More Un-Answered { Databases } Questions Click Here