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

CLR Integration ? what is Notification services ?

HCL, Satyam,

1 5338

what is replication? where do u use Go Keyword?

Satyam,

1 4933

how do u do Performance tunning ?

Infodat Technologies, Satyam,

1 5103

How to find the date and time of last updated table?

3 9350

Write a note on File based system/ Data base system

2 5976

What are the Roles and responsibilities of database administrator?

2505

Define the following terms 19. (i) Database 20. (ii) Database Management System 21. (iii) Data Model 22. (iv) Scheme 23. (v) Data independence

1 3764

Explain the classification of Database Management System?

CSC, Wipro,

4217

Explain the key constraints and constraints on Null Values with examples?

2 4478

What are ACID properties?

Amazon, Cap Gemini,

11 28485

Write about Transaction Management in Oracle 9i?

2135

I want to export the data date to date from oracle database then what can i do?

2615

can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

2560

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 12685

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

IBM,

6 10441

Un-Answered Questions { Databases }

How many parts of a pl sql block are optional?

1152

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

2020

How do you modify a column in sql?

1009

What is truncate table?

953

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1903

What is call form stack?

Why mongodb is required?

What is oracle database 10g express edition?

1136

what is the difference between gui testing and database testing? : Mysql dba

1105

What is mysql default port number?

1019

How are functions and procedures called in PL/SQL?

1250

What are the four components of a database system?

874

How to drop all foreign keys in database?

1104

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1035

How do you see the locking status in mongo instances?

For More Un-Answered { Databases } Questions Click Here