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

1975

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 12663

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 8524

Can we call SP inside a query?

CA, CarrizalSoft Technologies, Wipro,

5 10627

how to send sms to mobile phone from oracle forms.

HP, Tech Mahindra,

1 6237

how to send file attachment from oracle forms

HCL,

2566

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

2 4230

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

6 14545

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

TVS,

2 5355

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 8205

how do you count the duplicate records in a table

Tech Mahindra,

10 18966

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?

2197

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

HP,

2223

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

TCS,

5 8334

how to replace not in with not exist?

IBM,

3748

Un-Answered Questions { Databases }

Explain the Normalized Relations?

2707

If a cursor is open, how can we find in a pl/sql block?

1178

How does Oracle guarantee data integrity of data changes?

2412

Explain left outer join and right outer join?

1048

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1082

Explain procedure cache and data cache in sybase.

906

What is query optimizer in sql server?

1040

How much does a sql dba make? : SQL DBA

950

What are database data types?

917

What is a with(nolock)?

993

How many triggers are possible per table?

1112

Does microsoft access still exist?

1014

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1314

what is update statistics in sybase?

1170

What are triggers in oracle?

1050

For More Un-Answered { Databases } Questions Click Here