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 11039

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 37544

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 12515

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

5 7222

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

2250

which one is currently in used software cmpanies.

2203

How cost of one Forms created & Report Created?

TCS,

1 4917

What are Magic Table?

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

34 79860

what are file groups?

Evalueserve,

3 10349

what is the cursor life span?

Evalueserve, HG,

5 14700

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 13177

What is the difference between NOROW and LOCKROW?

Accenture, Honeywell, Satyam,

2910

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

2 7471

what do u mean by implementation?

2233

What is Index and different types of Indexes?

7 36476

Un-Answered Questions { Databases }

What is database sql?

1105

Explain boyce and codd normal form(bcnf)?

1019

Is ms access a rdbms?

786

what is 'mysqlshow'? : Sql dba

1076

What is an expression in ms sql server?

1151

what is a join? : Sql dba

1091

How to calculate the difference between two time values?

1069

How to drop a tablespace?

1095

What is the difference between specialization and generalization?

1076

When was mongodb founded and why it is called mongodb?

What is cursor and why it is required?

1259

What is the use of vacuum in postgresql?

951

Can the “if update (colname)” statement be used in a delete trigger?

1045

What is pivot query?

1128

List the types of locking?

1081

For More Un-Answered { Databases } Questions Click Here