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

write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.

Wipro,

11 17114

how to see the oracle 9i/10g table in pc? or In my pc where the table is saved and how to see?

1 4195

i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk

Aspire,

1 6255

WHEN DOWN TIME WHAT CAN U DO?

TCS,

1 4800

How can we see the database version in os level

Oracle,

6 13418

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

Cognizant,

4 8195

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

Cognizant,

2 5846

IF i write before / after insert / update trigger and i do rollback what will happen?

KPIT,

5 11729

dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.

3 5077

wat is tuff file in log shipping, wt is d use of tht file?

TCS,

1 6441

how to select second mauximum value in a given table under salary column

Sapient,

6 9582

what are basic modules required to implement oracle application in any oraganisation?

2214

I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.

3 6356

How many packages we have in db

Tesco,

1 5380

When we can say that is in BCNF?

BitWise,

3 10754

Un-Answered Questions { Databases }

How do I make a resultset scrollable?

966

How to find out what oracle odbc drivers are installed?

1046

What is bind variable in pl sql?

1059

Is mongodb still popular?

Is there any advantage of last_name varchar(50) over this last_name varchar(255)?

907

What are the various types of relationships in database? Define them.

895

What is the syntax of update document?

What is stored procedure in database?

948

what is the dual table in oracle?

998

What is olr?

What type of database is neo4j?

How does sql profiler work?

1023

What is difference between hql and sql?

1085

What does REVERT do in SQL Server 2005?

969

What does mysqli_fetch_assoc do?

920

For More Un-Answered { Databases } Questions Click Here