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 3779

did u received a single file or multiple files

2023

if some data is not transfered where it will get stored

1945

how do u run sql loader

1 6768

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

1 3133

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 6187

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

Satyam,

1 6780

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 51908

what is the command for user data type?

2 8951

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 50364

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

AOL,

1 6343

How do you troubleshoot if your tempdb gets filled

HCL,

13 44926

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 5678

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

2 7306

Can I remove the default constraint columns in SQL SERVER?

Value Labs,

5 15322

Un-Answered Questions { Databases }

How will you hide an attribute? : sql server analysis services, ssas

964

What are inner and outer joins examples of both?

967

What does count (*) mean?

936

How many categories of data types in oracle?

1032

how to connect a php script with the mysql database?

1052

What is the difference between delete and truncate statement in sql?

1076

What the different components in replication and what is their use? : sql server DBA

1055

Explain sybase sql server?

959

What is user defined datatypes and when you should go for them?

1019

What is precedence constraint?

990

What is difference between cartesian join and cross join?

1096

What are the different types of dbms?

1016

Relational calculus is what type of language?

1041

What is the function of having virtual internet protocol address (vip) in oracle rac?

Is it possible to split the print reviewer into more than one region ?

2280

For More Un-Answered { Databases } Questions Click Here