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

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 14458

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 8963

What is Referential Integrity?

3 8077

can we update a view which is created from two tables

11 34135

what is the advantage of RAID

Wipro,

4 10195

when will data in the data base is updated

IEG,

3 6619

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 69010

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 15981

Can u create a primary key with out unique index.

8 14934

what are the demerits of sql?

1 5371

what is the difference between binary_integer and pls_integer

TCS,

2 32407

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

Microsoft,

2584

What cursor type do you use to retrieve multiple recordsets?

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

17 70897

Two Methods of retrieving SQL?

Atiric Software, Microsoft, Oracle, TCS, Wipro,

7 56708

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

Microsoft,

1 6374

Un-Answered Questions { Databases }

Oracle

2389

How to create hyperlink from returned sql query ?

1140

How to disable foreign key constraint in postgresql?

897

Is it possible to create startup or shutdown trigger for on-schema?

1049

What is the synonym of join?

976

Would you easily automate your ms access database through menu driven selections?

841

What are the 3 types of schema?

1127

Explain the advantages of data integration suite in sybase.

889

What is orm in sql?

1057

How and why use sql server?

1025

How do I rename a table in mysql?

987

Explain the truncate command? : sql server architect

852

What does an inner join do?

1199

How to drop an index in oracle?

1087

What are the types of data contol?

628

For More Un-Answered { Databases } Questions Click Here