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

issues involved in modeling and building data werahouses

1964

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 12615

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 8482

Can we call SP inside a query?

CA, CarrizalSoft Technologies, Wipro,

5 10593

how to send sms to mobile phone from oracle forms.

HP, Tech Mahindra,

1 6219

how to send file attachment from oracle forms

HCL,

2551

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

2 4213

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

6 14499

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

TVS,

2 5330

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 8179

how do you count the duplicate records in a table

Tech Mahindra,

10 18907

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?

2185

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

HP,

2216

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

TCS,

5 8306

how to replace not in with not exist?

IBM,

3737

Un-Answered Questions { Databases }

What are the advantages of using third-party tools?

998

how would you store your query in an SSRS report or a Database server?

162

How to drop all tables in postgresql?

894

How do I start microsoft access on my computer?

870

Why use update_statistics command in sql server?

1051

I have a reference table called 1. of 2 fields called 1.BadgeGroups(BG)and 1.Badges(B)like BG G aa 10 aa 11 bb 12 bb 13 bb 14 Using MS Design View Table 2 has 3 fields called 2.name, 2.badgegroup and 2.group In Table 2 called 2. they calls Table 1 for 2 fields BUT with the second field 2.badges, I want the combo box only to display the 1.badges where 2.badgegroup = 1.badgegroup The current select I have is for Table Data View Row Source is: 2.badgegroup is filled from a Combo box using Select Distinct etc from Table 1. Tried different syntax's but still lost, looking for some help SELECT 1.[BadgeGroup], 1.Badge FROM 1. WHERE 1.[BadgeGroup]=Me.2.BadgeGroup); I can populate 2.badgegroup with a

2322

What is nested transaction?

1101

What is a trigger what are the advantages of trigger?

1000

What are the disadvantages of using the stored procedures?

1104

You want to implement the one-to-many relationship while designing tables. How would you do it?

960

What is data store? How to create data store?

638

What are the types of subquery?

1042

What is a derived table?

928

What is a temp table?

1024

Where in ms sql server is ’100’ equal to ‘0’?

1089

For More Un-Answered { Databases } Questions Click Here