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 12630

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 8488

Can we call SP inside a query?

CA, CarrizalSoft Technologies, Wipro,

5 10604

how to send sms to mobile phone from oracle forms.

HP, Tech Mahindra,

1 6219

how to send file attachment from oracle forms

HCL,

2552

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

2 4217

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

6 14515

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

TVS,

2 5339

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 8188

how do you count the duplicate records in a table

Tech Mahindra,

10 18922

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?

2190

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

HP,

2217

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

TCS,

5 8314

how to replace not in with not exist?

IBM,

3741

Un-Answered Questions { Databases }

What is the difference between substr and charindex in the sql server?

1106

what is insert all statement in sql

6526

Tell about MOM Tool(Microsoft Operator Manager)?

1915

How do you organize a database?

933

How do I clear the screen in mysql?

1008

How will you write a query to get a 5th rank student from a table student_report?

1866

Explain openquery function and openrowset function?

952

What is the load balancing advisory?

The secondary truncation point is on. How would you clear the logsegment?

869

How to drop an existing stored procedure in ms sql server?

1032

What are different between mongodb and sql server databases?

What happens if null values are involved in comparison operations?

977

Do you know concepts and capabilities of sql server?

1064

Can you always create a cache of a report?

172

How do I install a microsoft access driver?

873

For More Un-Answered { Databases } Questions Click Here