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

Amdocs,

1209

How many columns can exist together per table?

Cap Gemini,

1215

What is the use of RDBMS?

Wipro,

1064

Write a SQL query to make a column as unique?

Cap Gemini,

1078

Explain few examples of RDBMS?

Wipro,

1107

How many tables can be joined in SQL Server?

Cap Gemini,

1117

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

Wipro,

1041

Explain the database you used in your final year project?

Wipro,

1115

Write a SQL query to delete a table?

Amdocs,

1193

Explain the difference between HTTP and HTTPS in database?

Wipro,

1104

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

Cap Gemini,

1365

How to use clusters?

Amdocs,

1023

What to check if a User database is locked?

TCS,

1118

Explain what is meant by replication of database?

Cap Gemini,

1108

How to add additional conditions in SQL?

Amdocs,

1071

Un-Answered Questions { Databases }

Explain can you move old files in the movechunk directory?

What is model database in sql server?

1114

Explain the structure of adaptive server enterprise?

944

Do you know what are the restrictions that views have to follow?

1139

What are different backups available in sql server?

1164

What does currency type mean in database?

1259

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1081

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

1048

What is tempdb in sql server?

1033

What is the command line end user interface - mysql?

1159

How to create a single index for multiple columns?

1093

What do you mean by an execution plan? How would you view it?

975

What are a database and a data warehouse?

1083

What does truncate do?

1002

Define the select into statement.

1114

For More Un-Answered { Databases } Questions Click Here