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 14420

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 8940

What is Referential Integrity?

3 8058

can we update a view which is created from two tables

11 34088

what is the advantage of RAID

Wipro,

4 10154

when will data in the data base is updated

IEG,

3 6597

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 68778

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 15944

Can u create a primary key with out unique index.

8 14886

what are the demerits of sql?

1 5351

what is the difference between binary_integer and pls_integer

TCS,

2 32382

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

Microsoft,

2571

What cursor type do you use to retrieve multiple recordsets?

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

17 70810

Two Methods of retrieving SQL?

Atiric Software, Microsoft, Oracle, TCS, Wipro,

7 56676

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

Microsoft,

1 6360

Un-Answered Questions { Databases }

What are indexes? Mention the differences between the clustered and non-clustered index?

965

What are the ways available in sql server to execute sql statements?

1140

what is update statistics in sybase?

1162

List the advantages of access database ovr oracle database.

805

explain advantages of myisam over innodb? : Sql dba

1070

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2114

What do you mean by an execution plan? How would you view it?

916

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4429

How do you set a trace flag in sql server?

1041

What is transactional replication?

972

Explain can you move old files in the movechunk directory?

Is it necessary to install mongodb compass?

What is mysql community edition?

948

What are the advantages of using third-party tools?

998

Is mongo shell supported to tab completion?

For More Un-Answered { Databases } Questions Click Here