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

what is datawarehouse?

Informatica,

1113

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,

1385

how will add additional conditions in sql?

Amdocs, Apps Associates,

1102

What is a Database?

1 1768

What is a Transformation?

Informatica,

1025

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

1012

Which statement is used to delete a table in MySQL.

910

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

1455

What are SSL and TSL protocols?

Wipro,

985

What is the difference between Normalization and De-normalization?

TCS,

1091

What does COMMIT command do?

Amdocs,

1063

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

Amdocs,

1010

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

Amdocs,

1232

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

TCS,

1179

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

TCS,

1606

Un-Answered Questions { Databases }

How to add, remove, modify users using sql?

1035

What are constraints?

1009

Why is there a need for sqlcode and sqlerrm variables?

1047

What are the important tasks of common oracle dba?

559

How do you know the all indexes available for a collection?

What view means?

977

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

881

What are the requirements on sql server network connections?

993

what is transaction state, buffer management, shadow paging

3456

What is TDS(Tabular Data Stream) Gateway?

121

How do you name a table?

895

What is key set driven?

957

What is an sql server agent?

1063

How do you concatenate in sql?

1027

Is mongodb a documentdb?

For More Un-Answered { Databases } Questions Click Here