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 10939

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 37278

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 12248

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

5 7032

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

2195

which one is currently in used software cmpanies.

2160

How cost of one Forms created & Report Created?

TCS,

1 4835

What are Magic Table?

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

34 78809

what are file groups?

Evalueserve,

3 10183

what is the cursor life span?

Evalueserve, HG,

5 14520

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 12940

What is the difference between NOROW and LOCKROW?

Accenture, Honeywell, Satyam,

2844

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

2 7380

what do u mean by implementation?

2165

What is Index and different types of Indexes?

7 36236

Un-Answered Questions { Databases }

Is it important to partition hard disk?

1027

State and explain the different types of data models?

948

What is 2nf example?

1001

How do I run a sql trace?

963

What is root password?

921

Which are the olap features?

963

How does index makes search faster?

982

In which language oracle has been developed?

1077

What is crud in mongodb?

what are aggregate and scalar functions? : Sql dba

1060

How many types of normalization are there?

969

What does mysql flush privileges do?

935

Can we modify approve purchase order?if yes what is navigation?

2010

How do you create a new database in mysql?

920

Tell me when is the update_statistics command used?

1119

For More Un-Answered { Databases } Questions Click Here