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

Explain what is a column in a table?

1107

Explain what is a field in a database and record in a database?

1097

Explain what is rdbms?

1037

What is a join?

1069

What is database white box testing and black box testing?

1111

What is the difference between delete, truncate and drop command?

1152

Tell me something about security and sql azure?

114

How many replicas are maintained for each sql azure db?

124

What is federation member?

116

Is it possible to link two groups inside a cross products after the cross products group has been created?

1002

What is the difference between a primary key and a unique key?

1054

How can you know that statistics should be updated?

1079

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

1000

What is a schema? How is it useful in sql servers?

1122

What is use of term?

1068

Un-Answered Questions { Databases }

When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?

601

What happens if null values are involved in datetime operations?

975

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1438

using primary can we relate two table, with out foreign key?

2711

How to manipulate data from one table to another table ?

969

How many scalar data types are supported in pl/sql?

1057

What does inner join mean?

1168

What is database bounce?

1033

What is a sql join?

1022

What is sub-query in sql server? Explain its properties.

1093

Does insert statement lock the table?

948

System requirements for sql server 2005 express edition?

1028

Why is pl sql used?

984

What is delimiter $$?

967

Sql server reporting services vs. Crystal reports.

132

For More Un-Answered { Databases } Questions Click Here