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

Oracle (3253)
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 5460

what is replication? where do u use Go Keyword?

Satyam,

1 5042

how do u do Performance tunning ?

Infodat Technologies, Satyam,

1 5179

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

3 9525

Write a note on File based system/ Data base system

2 6080

What are the Roles and responsibilities of database administrator?

1 2555

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

1 3854

Explain the classification of Database Management System?

CSC, Wipro,

1 4291

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

2 4587

What are ACID properties?

Amazon, Cap Gemini,

11 28915

Write about Transaction Management in Oracle 9i?

1 2226

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

1 2709

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

1 2623

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 12753

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

IBM,

6 10712

Un-Answered Questions { Databases }

do you know how to configure db2 side of the application? : Sql server database administration

1118

Which statement is used in a select query for partial matching?

1239

Is there some bulk load or other way to import a lot of data fast?

931

what is schema? : Sql dba

1137

how many tables will create when we create table, what are they? : Sql dba

1140

what is collation? : Sql dba

1225

Do we need to rebuild index after truncate?

1130

Are you familiar with user exits in reports?

What is self contained sub query?

1138

Can sql servers link to other servers like oracle?

911

How raid can influence database performance?

1114

What are the kinds of subquery?

1101

What is current version of mysql?

1071

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2291

Can you index views?

953

For More Un-Answered { Databases } Questions Click Here