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

How many primary keys can a table have?

955

Does truncate remove indexes?

972

How can we find duplicate records in a table?

894

Can we insert data in view?

892

How do I remove all records from a table?

1026

Why truncate is faster than delete?

1055

Are subqueries faster than joins?

955

Does truncate free space?

948

Can a foreign key be null?

1033

How do you respond to dementia behavior?

927

Can we create clustered index without primary key?

901

How many types of index are there?

963

Is primary key an index?

947

How do you optimize a query?

941

Is natural join same as inner join?

872

Un-Answered Questions { Databases }

Introduction of rollup clause using sum and group by clause?

902

What do you mean by deferred update in sybase?

874

How can we access neo4j interface?

How to test for null values?

985

Write an sql query to find first weekday of the month?

867

What is mdf ldf and ndf?

932

What are database modules?

869

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2056

What is oracle host variable?

983

Is microsoft access being discontinued?

859

tell us something about heap tables. : Sql dba

1049

Explain what are triggers and rules?

855

What are snapshots? What are materialized views & where do we use them? What is a materialized view?

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2449

what are the 'mysql' command line arguments? : Sql dba

1091

For More Un-Answered { Databases } Questions Click Here