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

Please explain oracle left join with an example?

1062

Explain the truncate in oracle?

981

How to execute the package in oracle?

1096

Explain oracle insert into command?

1123

Explain the difference between replace() and translate() functions in oracle?

1055

Explain the features of oracle?

1067

How to convert raw data type into text in oracle? Explain

1008

Why oracle is used?

1073

Explain self joins in oracle?

1030

Explain oracle data types with examples?

1043

What do you mean by cdb and pdb in oracle 12c?

1071

Explain compound trigger in oracle?

1056

Write a syntax for update query in oracle?

1046

What is a trigger and what are its types in oracle?

1096

Please explain oracle data types with examples?

1086

Un-Answered Questions { Databases }

Name the sql joins that are available in informix.

How do we represent comments in oracle?

1061

How mongodb works? Explain

How many types of canvases are there. Explain them

Can sql servers link to other servers?

1105

What is the purpose of indexing?

1057

How you provide security to cube? : sql server analysis services, ssas

983

if some data is not transfered where it will get stored

1960

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2291

Can we use delete in merge statement?

1054

What are four major operators that can be used to combine conditions on a where clause?

1072

What are the various configuration files that are used by oracle forms?

1044

How to insert stored procedure result into temporary table?

1031

How to reaname table name without using sp_Rename in sql server..?

1008

How to do Data size testing? Who does this testing (Developer or tester)?

2573

For More Un-Answered { Databases } Questions Click Here