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

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

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

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

How many primary keys can a table have?

526

Does truncate remove indexes?

553

How can we find duplicate records in a table?

508

Can we insert data in view?

494

How do I remove all records from a table?

557

Why truncate is faster than delete?

553

Are subqueries faster than joins?

564

Does truncate free space?

510

Can a foreign key be null?

579

How do you respond to dementia behavior?

520

Can we create clustered index without primary key?

517

How many types of index are there?

540

Is primary key an index?

529

How do you optimize a query?

526

Is natural join same as inner join?

499

Un-Answered Questions { Databases }

how to start mysql server? : Sql dba

605

Explain few examples of stored procedure over triggers?

509

Do you know what are various aggregate functions that are available?

521

Where is trigger in sql server?

530

what do you understand by flashback feature of oracle?

549

Can we connect to ORACLE db using Windows Authentication?

713

Is mongodb a documentdb?

Do you know what is blocking?

534

What restrictions can you apply when you are creating views?

469

SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

570

Which are the two editions in which SQL Azure database available?

How do I update access 2013?

430

How to find out the list schema name and table name for the database?

519

Is storing images in a database a good idea?

544

What are the different dml commands in sql?

580

For More Un-Answered { Databases } Questions Click Here