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,

1074

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,

1344

how will add additional conditions in sql?

Amdocs, Apps Associates,

1036

What is a Database?

1 1702

What is a Transformation?

Informatica,

983

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

973

Which statement is used to delete a table in MySQL.

874

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

1408

What are SSL and TSL protocols?

Wipro,

947

What is the difference between Normalization and De-normalization?

TCS,

1046

What does COMMIT command do?

Amdocs,

1016

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

Amdocs,

980

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

Amdocs,

1196

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

TCS,

1150

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

TCS,

1567

Un-Answered Questions { Databases }

How many commands are there in sql?

992

What is the purpose of object explorer and its features? : sql server management studio

1161

How ms access is better than ms sql server?

815

How to escape special characters in sql statements?

939

Can we insert data into materialized view?

906

What are record groups ? Explain the types of record group.

How to find related tables in sql server?

893

What is the minimum client footprint required to connect c# to an oracle database?

1045

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1012

What is nested table in pl sql?

1023

What is primary key in database?

873

Explain the wait events in statspack report 'db sequential real'?

587

Can we convert a date to char in oracle and if so, what would be the syntax?

978

What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?

549

Why is it called postgresql?

840

For More Un-Answered { Databases } Questions Click Here