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

can i send the control file path as a parameter

1 3791

did u received a single file or multiple files

2031

if some data is not transfered where it will get stored

1960

how do u run sql loader

1 6775

i don't want to give the path of .Dat file in .Ctl file dynamically i want to give how

1 3139

What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?

CTS,

2 6201

how we can validate the run-time parameters in reports 6i

Satyam,

1 6803

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?

Alps, Aricent, Bank Of America, Wipro,

29 52092

what is the command for user data type?

2 8964

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

Wipro,

15 50447

I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT

AOL,

1 6360

How do you troubleshoot if your tempdb gets filled

HCL,

13 45034

Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks

2 5697

In testing where do we use sql language and how it helps in testing?

2 7321

Can I remove the default constraint columns in SQL SERVER?

Value Labs,

5 15348

Un-Answered Questions { Databases }

Why we use mysql workbench?

916

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1036

Explain the use of assign statement in progress database?

918

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2340

What are journaling in mongodb?

What are the beneficial tools for administering the database?

549

What are the differences between blob and clob in oracle?

1104

What is difference between primary and secondary key?

1051

What is transport network substrate (tns) in oracle?

1064

Explain a join?

1078

Which data type is a composite type?

998

How do you trace the traffic hitting a sql server? : sql server DBA

1587

State some uses of redo log files?

1031

what is raid? : Sql server database administration

1057

How database are managed?

1005

For More Un-Answered { Databases } Questions Click Here