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 to use copy and concatenate commands in SQL?

Amdocs,

1140

How many columns can exist together per table?

Cap Gemini,

1156

What is the use of RDBMS?

Wipro,

1005

Write a SQL query to make a column as unique?

Cap Gemini,

1040

Explain few examples of RDBMS?

Wipro,

1039

How many tables can be joined in SQL Server?

Cap Gemini,

1065

What is the name of the Database which IBM mainframe uses?

Wipro,

987

Explain the database you used in your final year project?

Wipro,

1045

Write a SQL query to delete a table?

Amdocs,

1137

Explain the difference between HTTP and HTTPS in database?

Wipro,

1036

How to automatically create a log when an exception is being received into SQL Server?

Cap Gemini,

1289

How to use clusters?

Amdocs,

945

What to check if a User database is locked?

TCS,

1071

Explain what is meant by replication of database?

Cap Gemini,

1031

How to add additional conditions in SQL?

Amdocs,

1022

Un-Answered Questions { Databases }

Whats the benefit of dbms_stats over analyze?

2001

What is truncate oracle?

971

What is access on a computer?

800

How many types of index are there?

1040

Is stored procedure faster than query?

969

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2827

What are the operating modes in which database mirroring runs? : sql server DBA

1188

Explain linked server in sql?

1219

Write a SQL command to insert and update only a particular field?

1110

Are you doing the updates from within a cursor?

1119

Does partitioning help performance?

935

How do you handle datasets larger than 50 gb?

162

What is pdo in mysql?

933

How can I create database in oracle?

1026

Mention what is split brain syndrome in rac?

For More Un-Answered { Databases } Questions Click Here