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 are the types of partitions in oracle?

983

What is a partition in oracle?

1050

How can I see all tables in oracle?

961

Is drop table faster than truncate?

948

How do I truncate a word?

1016

Can we create index on primary key?

923

Can you join a table to itself?

1053

Is primary key a clustered index?

927

How does a self join work?

1008

How do you explain an index number?

1040

Where is all the data on the internet stored?

956

Is left join faster than inner join?

1071

How do you know if a relationship is 2nf?

891

How do you delete data from a table?

984

How do I find duplicates in the same column?

1010

Un-Answered Questions { Databases }

What are the types of views in sql?

1050

what are the different functions in sorting an array? : Sql dba

979

What are the types of index?

907

What is a delimiter in sas?

993

What are the disadvantages of microsoft access?

844

How to write a left outer join with the where clause in oracle?

1037

Explain different types of collation sensitivity?

938

Is a primary key indexed?

816

How to save array of objects in mongoose?

What is row_number()?

941

How can you create and drop view in mysql?

876

How to use wildcard characters in like operations in ms sql server?

1079

Differentiate between transaction type and transaction source? : oracle accounts receivable

1074

Why main is user defined function?

961

What is a subquery in sql?

983

For More Un-Answered { Databases } Questions Click Here