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

what is datawarehouse?

Informatica,

1160

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

Amdocs, Apps Associates,

1446

how will add additional conditions in sql?

Amdocs, Apps Associates,

1170

What is a Database?

1 1853

What is a Transformation?

Informatica,

1073

SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

1079

Which statement is used to delete a table in MySQL.

960

Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

1509

What are SSL and TSL protocols?

Wipro,

1038

What is the difference between Normalization and De-normalization?

TCS,

1151

What does COMMIT command do?

Amdocs,

1124

Write a program to fetch first 10 records from a file?

Amdocs,

1066

How to update a field in SQL after ALTERING a row?

Amdocs,

1287

Write a sql query to get zero records from a table having n number of records?

TCS,

1237

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

TCS,

1659

Un-Answered Questions { Databases }

1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?

2243

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1801

How do I create a foreign key in postgresql?

806

What are mysql data types?

1062

Explain what are triggers and rules?

969

What are the ways in which you can retrieve data in the result set of mysql using php?

1048

Difference between hot backup vs. Cold backup?

1042

How many types of triggers are there in pl sql?

1125

What is a dirty read sql?

1250

How to lock and unlock a user account in oracle?

1165

What are local and global Indexes and where they are useful.

1502

Which is the best option used to move database from one server to another serve on same network and why?

583

How can we delete duplicate rows in a table?

1041

Explain ddl interpreter?

1266

What is a scheduled job or what is a scheduled task?

1012

For More Un-Answered { Databases } Questions Click Here