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

1966

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 12638

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 8489

Can we call SP inside a query?

CA, CarrizalSoft Technologies, Wipro,

5 10610

how to send sms to mobile phone from oracle forms.

HP, Tech Mahindra,

1 6223

how to send file attachment from oracle forms

HCL,

2556

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

2 4221

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

6 14517

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

TVS,

2 5342

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 8192

how do you count the duplicate records in a table

Tech Mahindra,

10 18930

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,

2218

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

TCS,

5 8316

how to replace not in with not exist?

IBM,

3744

Un-Answered Questions { Databases }

What is 'mysqladmin' in mysql?

1038

How do I become an administrator?

585

What is default port number for sql server 2000?

1058

can I install informix on a non-english version of windows nt?

Why olap is used?

979

how you can move data or databases between servers and databases in sql server? : Sql server administration

973

What are the new features of sql server 2012 reporting service?

133

What is the normalization?

600

Can we store images in database?

870

What are the critical issues you have resolved in your company

2246

how does an oracle clusterware manage crs resources?

1093

How to calculate date and time differences in oracle?

1044

Is postgresql a server?

1055

how to enter binary numbers in sql statements? : Sql dba

981

what do you understand by fine-grained auditing?

1062

For More Un-Answered { Databases } Questions Click Here