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

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

1065

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

1029

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

1049

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

1101

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

1046

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

983

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

971

how can a database be repaired? : Sql server administration

989

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

997

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

1238

what does the automatic recovery do? : Sql server administration

1034

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

1079

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

1001

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

964

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

995

Un-Answered Questions { Databases }

What is the term match in mongodb?

Explain clause in sql?

1040

How do you define a composite key?

802

What is the use of for clause?

1133

Can multiple users access the same access database?

921

What is the maximum connection pool size?

985

Is the order of columns in the set clause important in ms sql server?

981

How to encrypt Strored Procedure in SQL SERVER?

1180

How do you update sql?

997

Which nosql database is best?

992

What is the advantages and disadvantages of database management system?

1032

What is system tablespace?

1111

What are partitioned views?

1020

Can I copy mysql data directory?

942

What is oracle log switch?

636

For More Un-Answered { Databases } Questions Click Here