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 3035

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

1208

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 }

‘Order by’ is not allowed in a view how can you sort information from a view?

1081

Put some light on multi-version concurrency control?

866

What are the benefits of ms access?

863

how to restore files with rman?

2303

how to get a list of indexes of an existing table? : Sql dba

957

What would you do with an in-doubt distributed transaction?

1978

How to set up autotrace for a user account?

1059

How do I transfer data from one database to another in mysql?

903

What is insert query in mysql?

907

Explain about relational operator join?

1038

What is rich query?

980

Where do you use decode and case statements?

993

What is the meaning of flat file database?

1003

How to call postgresql function in asp net?

923

Are databases stored on servers?

1035

For More Un-Answered { Databases } Questions Click Here