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

can i send the control file path as a parameter

1 3845

did u received a single file or multiple files

2063

if some data is not transfered where it will get stored

1996

how do u run sql loader

1 6837

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

1 3182

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 6281

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

Satyam,

1 6857

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 52689

what is the command for user data type?

2 9043

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 50790

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

AOL,

1 6415

How do you troubleshoot if your tempdb gets filled

HCL,

13 45415

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 5774

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

2 7391

Can I remove the default constraint columns in SQL SERVER?

Value Labs,

5 15469

Un-Answered Questions { Databases }

Why place tempdb and log on low numbered devices?

892

Can a commit statement be executed as part of a trigger?

1108

what is semphore explian it?

2884

What do you mean by an execution plan? Why is it used?

1083

What is a full join sql?

1105

Can I create users through internet explorer in oracle 10g?

1160

Why are you getting errors when creating a new odbc dsn?

1296

Is postgresql a nosql database?

1231

What type of database is postgres?

841

What is schema in mongoose?

What is the latest version of neo4j?

what do you understand by flashback feature of oracle?

1046

What are the types of stored procedures in an sql server?

1039

What are elements of administration?

640

What is the plv (pl/vision) package offers?

1116

For More Un-Answered { Databases } Questions Click Here