Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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,

2798

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

1 4732

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 5144

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

AC, HP,

5 10386

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

L&T,

2 6921

Which is the best place to learn hadoop?

1 5387

write sub query for eliminating duplicate rows using analytical function?

Metric Stream,

3 13126

what is switch column,colums cost in oracle?

Metric Stream,

3749

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

Metric Stream,

1 9376

maximum database size of mysql database

2 5467

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 8998

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 5941

display records from 5 to 9 using rowid or rownum

Agile Software,

5 16262

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 3345

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

3 6274

Un-Answered Questions { Databases }

What is dml with example?

1154

How to divide by zero and nulls in sybase?

1013

what is the difference difference between procedure and packages

10539

what is rollback? : Sql dba

1180

How can you change to get the decimal separator as comma instead of the decimal point (.)?

909

What is isql in sybase?

949

What is difference between inner join and full join?

1115

How can we delete duplicate rows in a table?

1036

How do I import a csv file into postgres?

952

What are the differences between a dbms and rdbms?

1060

How do I open microsoft access on my computer?

889

what is a deadlock? : Sql server database administration

1149

Explain the necessary techniques to control deadlocks?

969

What is sql rdbms?

1009

Where views are stored in sql server?

1030

For More Un-Answered { Databases } Questions Click Here