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,

2652

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

1 4569

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 4945

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

AC, HP,

5 9959

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

L&T,

2 6711

Which is the best place to learn hadoop?

1 5219

write sub query for eliminating duplicate rows using analytical function?

Metric Stream,

3 12879

what is switch column,colums cost in oracle?

Metric Stream,

3612

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

Metric Stream,

1 9240

maximum database size of mysql database

2 5263

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 8750

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 5742

display records from 5 to 9 using rowid or rownum

Agile Software,

5 15846

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 3218

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

3 5971

Un-Answered Questions { Databases }

Is pgadmin open source?

745

What types of joins are used in writing subqueries?

944

what is profile in odi?

610

Is a table valued function object?

963

WHAT IS CARDINALITIES OF JOIN?

2325

What is a common use of group by in sql?

1004

Why should one not prefix user stored procedures with ‘sp_’?

999

What is a function in oracle pl sql?

993

Why use sub query in sql server and list out types of sub queries?

949

What is the difference between clustered and non-clustered index in sql?

968

What are the topics in pl sql?

937

What is xdr?

941

i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

2954

What is the primary use of normalization?

953

What is auto invoicing? Explain : oracle accounts receivable

1065

For More Un-Answered { Databases } Questions Click Here