Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3258)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3328)
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?

757

Does truncate remove indexes?

753

How can we find duplicate records in a table?

701

Can we insert data in view?

714

How do I remove all records from a table?

810

Why truncate is faster than delete?

836

Are subqueries faster than joins?

749

Does truncate free space?

735

Can a foreign key be null?

823

How do you respond to dementia behavior?

741

Can we create clustered index without primary key?

732

How many types of index are there?

747

Is primary key an index?

732

How do you optimize a query?

758

Is natural join same as inner join?

700

Un-Answered Questions { Databases }

What methods is used to commit the changes made in DataSet object?

727

Define model database?

766

how to toggle ms word to ms excel or ms excel to ms word

1870

How do you pronounce sql?

764

How can you log an error to the server event log from a stored procedure?

817

Does truncate free space?

735

What are different types of resources?

745

What do you mean by stored procedures? How do we use it?

746

What is composite foreign key?

535

How can you fetch common records from two tables?

814

How do I add a file to a database?

666

What are different types of joins in the sql?

728

Explain go command in sql server?

766

How to remove duplicate rows from table except one?

763

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

1980

For More Un-Answered { Databases } Questions Click Here