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 3872

did u received a single file or multiple files

1 2080

if some data is not transfered where it will get stored

1 2018

how do u run sql loader

1 6877

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

1 3227

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 6332

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

Satyam,

1 6890

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 53252

what is the command for user data type?

2 9077

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 51034

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

AOL,

1 6447

How do you troubleshoot if your tempdb gets filled

HCL,

13 45665

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 5832

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

2 7421

Can I remove the default constraint columns in SQL SERVER?

Value Labs,

5 15570

Un-Answered Questions { Databases }

Who proposed the relational model?

1027

How do I start sql server 2017?

1011

What is the difference between for xml raw and for xml auto?

1112

What are different types of constraints?

995

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1293

What are wait types?

1241

what are all the common sql function? : Sql dba

1127

What is a coalesce function?

1275

What versions of clipper does netlib support?

1086

How efficient you are in oracle and SQL server?

1251

Does group by remove duplicates?

1112

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1895

How do I find the sql server version?

1099

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

1140

How to remove duplicate rows from table except one?

1081

For More Un-Answered { Databases } Questions Click Here