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

1. Which is an aggregate function? a. Union b. like c. max d. Rank

Fintellix,

1 3134

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

Fintellix,

2 8802

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

Fintellix,

1 3218

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

Fintellix,

1 2805

7. Where would you look for errors from the database design?

Fintellix,

1 3116

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1446

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1478

During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?

1422

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1258

Whis is not false in primary key?

Fintellix,

1528

Can we call a function that has out parameter in select statement

Nagarro,

1414

Call by value and call by reference in procedure and function, with NOCOPY.

Nagarro,

1351

If we delete pack Spec what will be the status of pack Body ?

Nagarro,

1524

Delete duplicate rows without using rowid.

Nagarro,

1591

What is Histogram?

NIIT,

1611

Un-Answered Questions { Databases }

How can one get sql*loader to commit only at the end of the load file? : aql loader

1121

What is a Garbage Collection? and what is full recursive Garbage collection?

2961

How do I start postgresql on linux?

887

I have applied the following commands: now what will happen, will the database will give an error / it will work?

600

Write a query to display even rows in student table using mysql?

944

Explain a data segment?

1112

What is the fillfactor concept in indexes?

1037

How set mysql root password?

967

Which query language is used for neo4j?

What are date and time data types?

1043

What is a relation in dbms?

1241

Define union all operator and union.

986

How do I open an access 2007 file?

887

What are the benefits and tasks of object explorer? : sql server management studio

1263

can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

2609

For More Un-Answered { Databases } Questions Click Here