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,

2730

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

1 4649

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 5057

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

AC, HP,

5 10167

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

L&T,

2 6817

Which is the best place to learn hadoop?

1 5314

write sub query for eliminating duplicate rows using analytical function?

Metric Stream,

3 12996

what is switch column,colums cost in oracle?

Metric Stream,

3676

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

Metric Stream,

1 9314

maximum database size of mysql database

2 5374

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 8876

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 5853

display records from 5 to 9 using rowid or rownum

Agile Software,

5 16048

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 3277

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

3 6118

Un-Answered Questions { Databases }

Explain can you move old files in the movechunk directory?

explain primary keys and auto increment fields in mysql : sql dba

977

explain what is mysql? : Sql dba

1080

How to migrate paradox, dbase or foxpro database to firebird?

1026

How to add additional conditions in SQL?

1022

What is the sql query to find the employee who has Nth maximum salary?

5329

Explain the differences between rdbms and graph database?

How do you create a database in access 2010?

844

what are the different types of replication you can set up in sql server? : Sql server database administration

1023

How do you remove a foreign key constraint?

806

Explain asa, asa ultralite.

861

What is normalization in database with example?

909

Is it possible to configure the cache size for mmapv1 in mongodb?

What are the features of pl sql?

1067

how you can list all the tables in a database?

1026

For More Un-Answered { Databases } Questions Click Here