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,

1206

How many columns can exist together per table?

Cap Gemini,

1212

What is the use of RDBMS?

Wipro,

1060

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,

1115

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

Wipro,

1041

Explain the database you used in your final year project?

Wipro,

1112

Write a SQL query to delete a table?

Amdocs,

1188

Explain the difference between HTTP and HTTPS in database?

Wipro,

1098

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

Cap Gemini,

1365

How to use clusters?

Amdocs,

1021

What to check if a User database is locked?

TCS,

1117

Explain what is meant by replication of database?

Cap Gemini,

1108

How to add additional conditions in SQL?

Amdocs,

1071

Un-Answered Questions { Databases }

what is a check constraint?

1178

Can sql servers linked to other servers?

1101

What is a periodical index?

982

How to use wildcard characters in like operations in ms sql server?

1193

What is mutating table error?

1240

What are the benefits of modeling?

1184

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1636

What is trace flag in sql server?

1086

1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? Belgian Waffles $5.95 two of our famous Belgian Waffles with plenty of real maple syrup 650 Strawberry Belgian Waffles $7.95 light Belgian waffles covered with strawberries and whipped cream 900 Berry-Berry Belgian Waffles $8.95 light Belgian waffles covered with an assortment of fresh berries and whipped cream 900 French Toast $4.50 thick slices made from our homemade sourdough bread 600 Homestyle Breakfast $6.95 two eggs, bacon or sausage, toast, and our ever-popular hash browns 950

2190

What is the command line end user interface - mysql?

1159

How do I find the port number for sql server?

1023

What is a memo field?

1021

How to delete duplicate rows from table except one?

1048

What is unique key constraint?

1121

Can we use views in stored procedure?

1088

For More Un-Answered { Databases } Questions Click Here