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

what is meant by sql injection with example and one more question how to catch the errors in sqlserver

2 11090

hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com

Wipro,

8 37656

Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question

TCS,

7 12599

write a query to Find the Maximun second value in table?

5 7282

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

1 2265

which one is currently in used software cmpanies.

1 2220

How cost of one Forms created & Report Created?

TCS,

1 4946

What are Magic Table?

3i Infotech, Digiweb, Evalueserve, NIIT, PL,

34 80203

what are file groups?

Evalueserve,

3 10404

what is the cursor life span?

Evalueserve, HG,

5 14797

Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

Accenture,

7 13238

What is the difference between NOROW and LOCKROW?

Accenture, Honeywell, Satyam,

1 2931

Can we write create command in the plsql block?if possible how?

2 7521

what do u mean by implementation?

1 2261

What is Index and different types of Indexes?

7 36573

Un-Answered Questions { Databases }

When should you use an instead of trigger?

1044

How did mongodb get its name?

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2348

How to connect php with different port numbers?

1181

What is a view in sql?

1035

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2100

Suppose database is running slow, what will you do?

2590

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1293

How can you append an identity column to a temporary table?

1067

What is a coalesce function?

1275

Can we shrink data file in sql server?

1123

what is the command syntax for inserting a document?

What are different types of constraints?

996

What is oracle latest version?

1171

How to put more than 1000 values into an oracle in clause?

1110

For More Un-Answered { Databases } Questions Click Here