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

issues involved in modeling and building data werahouses

1 2024

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

TCS,

8 12986

1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.

6 8746

Can we call SP inside a query?

CA, CarrizalSoft Technologies, Wipro,

5 10860

how to send sms to mobile phone from oracle forms.

HP, Tech Mahindra,

1 6321

how to send file attachment from oracle forms

HCL,

1 2624

Can some one please help with a query which will take only max value of a column in a join.

2 4368

what is the difference between rollback & commit? can a foreign key has null value?

6 14803

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

TVS,

2 5467

what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )

Tech Mahindra,

2 8342

how do you count the duplicate records in a table

Tech Mahindra,

10 19299

What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

1 2277

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

HP,

1 2287

which database is best to use in oracle and sql server? explain reasons?

TCS,

5 8572

how to replace not in with not exist?

IBM,

1 3839

Un-Answered Questions { Databases }

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

How to rebuild the master database?

1160

Does view occupy space?

1005

List the ways in which dynamic sql can be executed?

1083

What is the latest version of postgresql?

951

What is temporary table in sql server? Why we use temp table?

1012

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2701

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2308

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1948

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

What versions of clipper does netlib support?

1086

what is sql server agent? : Sql dba

1176

Is inner join faster than left join?

1273

How to write a left outer join with the where clause in oracle?

1149

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1844

For More Un-Answered { Databases } Questions Click Here