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

How internally data stores in MyISAM and INNODB table types?

Zensar,

2743

why not null constraint showing its constraint type as 'c'

1 4654

how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........

TCS,

2 5060

without using count(*) and rownum how can we count total record in a table

AC, HP,

5 10182

What is the basic difference between a sql and stored procedure ?

L&T,

2 6829

Which is the best place to learn hadoop?

1 5314

write sub query for eliminating duplicate rows using analytical function?

Metric Stream,

3 13006

what is switch column,colums cost in oracle?

Metric Stream,

3680

what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?

Metric Stream,

1 9318

maximum database size of mysql database

2 5383

we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?

TCS,

3 8880

you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??

BirlaSoft,

2 5857

display records from 5 to 9 using rowid or rownum

Agile Software,

5 16054

when i declare date data type in sql ,i inserted the date 22-10-2012,but my result is in different date 1894-07-11 any one pls help me what's wrong in my query Create table orders(od_id int,od_name varchar(10),od_date date) insert into orders values(1,'sai',22-10-2012) and any one pls suggest what i can learn for 3 years real time experenice in sql because i am looking for database field

1 3282

determine the minimum salary of the employee and his details who join on the same date

3 6118

Un-Answered Questions { Databases }

When to use Inner join & when to use subquery?

1165

How to retrieve error messages using odbc_errormsg()?

1062

Can we write pl sql mysql?

948

Do foreign keys speed up queries?

826

Explain the Normalized Relations?

2704

Is mongodb a json?

on line cluster can we make if yes tell me the procedure

2025

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1036

Why is it called postgresql?

893

Explain a segment?

1093

What is fmtonly in sql?

1088

Do you know what is user defined datatypes and when you should go for them?

968

can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?

2116

How to send the emails for odi?

697

Does table partitioning improve performance?

973

For More Un-Answered { Databases } Questions Click Here