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

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 17493

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

1 4261

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 6330

WHEN DOWN TIME WHAT CAN U DO?

TCS,

1 4890

How can we see the database version in os level

Oracle,

6 13615

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 8345

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

Cognizant,

2 5926

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

KPIT,

5 11916

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 5201

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

TCS,

1 6544

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

Sapient,

6 9746

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

2261

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 6507

How many packages we have in db

Tesco,

1 5479

When we can say that is in BCNF?

BitWise,

3 10865

Un-Answered Questions { Databases }

what are the limitations of identity column? : Transact sql

1165

Explain the different index configurations a table can have?

997

What is the definition of database management system?

1129

what are the performance views in an oracle rac environment?

1127

What is execute immediate?

1166

What are the differences between union, intersect, and minus operators?

1143

Explain what is use of dbcc commands?

1144

How do I install postgresql?

940

Explain different forms of normalization?

1004

Cite the differences between execution of triggers and stored procedures?

1143

What is use of trigger?

990

What is the use of Markers?

650

Any work done in oracle workflow builder. Did you customize or build a new workflow?

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1500

What is oracle analytical function?

1238

For More Un-Answered { Databases } Questions Click Here