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 14686

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 9093

What is Referential Integrity?

3 8205

can we update a view which is created from two tables

11 34562

what is the advantage of RAID

Wipro,

4 10356

when will data in the data base is updated

IEG,

3 6784

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 70261

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 16234

Can u create a primary key with out unique index.

8 15170

what are the demerits of sql?

1 5475

what is the difference between binary_integer and pls_integer

TCS,

2 32542

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

Microsoft,

1 2627

What cursor type do you use to retrieve multiple recordsets?

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

17 71551

Two Methods of retrieving SQL?

Atiric Software, Microsoft, Oracle, TCS, Wipro,

7 57009

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

Microsoft,

1 6479

Un-Answered Questions { Databases }

what is collation? : Sql dba

1217

How to rebuild the master database?

1150

If a cursor is open, how can we find in a pl/sql block?

1230

Why and when do stored procedure recompile?

1044

Does group by remove duplicates?

1104

How to export data from database and import into another?

985

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8219

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2205

How raid can influence database performance?

1099

Disadvantages of the indexes?

1213

How to select all columns of all rows from a table in oracle?

1111

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1595

what is dbms? : Sql dba

1051

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2300

what is the difference between openrowset and openquery?

1183

For More Un-Answered { Databases } Questions Click Here