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

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

2 10951

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 37339

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 12290

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

5 7055

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

2211

which one is currently in used software cmpanies.

2169

How cost of one Forms created & Report Created?

TCS,

1 4853

What are Magic Table?

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

34 78999

what are file groups?

Evalueserve,

3 10215

what is the cursor life span?

Evalueserve, HG,

5 14560

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 12978

What is the difference between NOROW and LOCKROW?

Accenture, Honeywell, Satyam,

2859

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

2 7396

what do u mean by implementation?

2174

What is Index and different types of Indexes?

7 36273

Un-Answered Questions { Databases }

Can you explain what is indexed view? How to create it?

924

What is mysqli_select_db?

981

How to get the definition of a trigger back?

1021

What is oracle instant client?

1039

What are database links used for?

1064

how Data is stored in a file so that Direct Searching can be performed

1030

What is postgresql service?

964

What is replication in mongodb?

Explain by listing some of dbms major advantages.

871

How to change the ownership of a schema in ms sql server?

1213

What is hot backup and logical backup?

1067

Difference between inner join vs where ?

1058

What is microsoft access database?

915

Can you explain important index characteristics?

1005

Is ssrs support other database except ms sql server?

142

For More Un-Answered { Databases } Questions Click Here