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,

2636

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

1 4553

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 4929

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

AC, HP,

5 9913

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

L&T,

2 6683

Which is the best place to learn hadoop?

1 5197

write sub query for eliminating duplicate rows using analytical function?

Metric Stream,

3 12849

what is switch column,colums cost in oracle?

Metric Stream,

3592

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

Metric Stream,

1 9225

maximum database size of mysql database

2 5245

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 8710

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 5708

display records from 5 to 9 using rowid or rownum

Agile Software,

5 15798

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 3199

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

3 5924

Un-Answered Questions { Databases }

Explain how exception handling is done in advance pl/sql?

955

Which directory will you copy your new reports, what would be its extension (.rdf or .rex)?

What is database partitioning?

2761

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1869

What is the difference between primary and candidate key?

1065

What do you need to connect php to mysql?

931

How to invoke the original export import utilities?

974

What does create schema do?

728

Define candidate key, alternate key, and composite key.

871

Define ACID properties in a Database?

1004

What is trace flag in sql server?

975

What is network database?

972

What is the purpose of a database?

981

Explain the savepoint statement.

1038

What are the steps you will take to improve performance of a poor performing query?

2792

For More Un-Answered { Databases } Questions Click Here