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 to find the date and time of last updated table?

Teledata,

6 9748

What types of questions are asked in NIC(Natinal Informatics Centre)'s interview?If any one has any information about this,I would be very thankful to him/her.....

NIC,

1889

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

NIC,

2234

What’re ERD and the main elements of an ERD? Please explain using an ERD example.

3 14374

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 23901

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 9225

what is the last version,the release date of that version and fix pack of ibm db2 udb?

1978

what is the difference between off-line back up and on-line back up in ibm db2 udb?

Zenith,

2 9051

What value could be assigned to Varchar Type?

3 5931

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 5540

What types of integrity are enforced by a foreign-key constraint

1 4269

What are the main control-of-flow T-SQL constructs?

1 4825

What are the two virtual tables SQL Server maintains for triggers?

3 8514

What does the INSTEAD OF trigger do?

3 7644

What are explicit and implicit transactions?

BirlaSoft,

4 22142

Un-Answered Questions { Databases }

What is an optimization and performance tuning and how does it really work in practical projects?

905

How do you sort in sql?

1034

Put some light on multi-version concurrency control?

878

How does postgresql compare to oracle/db2/ms sql server/informix?

1042

Is it important for a database administrator to understand the operating system and file access?

1005

How do I become a dba?

588

What is form view access?

795

what is the syntax for using sql_variant_property? : Transact sql

1055

When is the update_statistics command used?

1129

Are you familiar with user exits in reports?

When does checkpoint occur in dbms?

1042

How to determine the size of an index?

How is debugging done?

989

What is a dba programmer?

585

Is mongodb a sql database?

For More Un-Answered { Databases } Questions Click Here