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 17111

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 6254

WHEN DOWN TIME WHAT CAN U DO?

TCS,

1 4799

How can we see the database version in os level

Oracle,

6 13416

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 8194

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

Cognizant,

2 5845

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

KPIT,

5 11725

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 5076

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

TCS,

1 6440

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

Sapient,

6 9580

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

2213

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 6354

How many packages we have in db

Tesco,

1 5378

When we can say that is in BCNF?

BitWise,

3 10751

Un-Answered Questions { Databases }

What is view? How can you create and drop view in mysql?

934

Tell me what is fill factor?

965

What is an intersect?

1109

Is primary key indexed by default in postgres?

811

Define fragmentation.

894

What are the rules to be applied to nulls whilst doing comparisons?

1326

Who developed MongoDB and when?

What are the dmvs? : sql server database administration

1067

Can primary key be null postgres?

832

What are the difference between primary keys and foreign keys?

969

What are three advantages to using sql?

1024

What is a server parameter file in oracle?

1061

how to overcome kernel isssues

1629

Explain different types of lock modes in sql server 2000?

937

What is Relationship set?

863

For More Un-Answered { Databases } Questions Click Here