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

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

Fintellix,

1 3034

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 8691

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 3134

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 2714

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

Fintellix,

1 3029

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?

1382

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.

1424

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

1381

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

1207

Whis is not false in primary key?

Fintellix,

1454

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

Nagarro,

1360

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

Nagarro,

1306

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

Nagarro,

1476

Delete duplicate rows without using rowid.

Nagarro,

1532

What is Histogram?

NIIT,

1557

Un-Answered Questions { Databases }

What do you mean by durability in dbms?

1034

What is the purpose of linked server configuration in sql server?

1048

Is left join inner or outer?

1014

how to write the procedures in odi?

726

Which sql statement is used to delete data from a database?

956

What do you understand by oracle forms?

1038

Can I use google sheets as a database?

972

Which is the latest version of sql server and when it is released?

1112

What is constraints and its types?

949

When a primary key constraint is included in a table, what other constraints does this imply?

989

What are the two parts of design view?

1018

What is a sql driver?

995

How do I make a pgadmin server?

887

What is query in database?

922

Write a query to find duplicate rows in table?

906

For More Un-Answered { Databases } Questions Click Here