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

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

Oracle,

7 14619

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

Oracle,

3 9057

What is Referential Integrity?

3 8174

can we update a view which is created from two tables

11 34441

what is the advantage of RAID

Wipro,

4 10305

when will data in the data base is updated

IEG,

3 6741

I have student marks in a student table. I need second highest mark .Then what will the query for this?

NetCore, Patni, SAP Labs, Temenos, Wipro,

37 69946

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

Oracle,

9 16162

Can u create a primary key with out unique index.

8 15113

what are the demerits of sql?

1 5442

what is the difference between binary_integer and pls_integer

TCS,

2 32500

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

Microsoft,

2612

What cursor type do you use to retrieve multiple recordsets?

Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,

17 71358

Two Methods of retrieving SQL?

Atiric Software, Microsoft, Oracle, TCS, Wipro,

7 56916

How do you assign Construct the where clause without concatenating Field,value pairs?

Microsoft,

1 6453

Un-Answered Questions { Databases }

How do I connect to postgresql on windows?

968

what is constraints?

1238

What is the purpose of grouping data in a report?

1017

How are exceptions handled in pl/sql? Give some of the internal exceptions name?

1081

What is data model in mongodb?

does odi support web services?

619

What is the difference between varchar and varchar(max) datatypes?

1138

What are the features of pl sql?

1112

What is the difference between functions, procedures, and packages in pl/sql?

1096

What is data definition language?

1138

What do you mean by sybase iq?

941

Ways to improve the performance of a SQL Azure Database?

125

You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

1266

What is a user function?

715

What do you mean by foreign key and primary key?

1089

For More Un-Answered { Databases } Questions Click Here