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

Define Transaction ?

5 10640

When does a Transaction end ?

2 7540

What does COMMIT do ?

4 10586

What is SAVE POINT ?

5 9635

What is Read-Only Transaction ?

3 6593

What is the function of Optimizer ?

1 4485

What are the different approaches used by Optimizer in choosing an execution plan ?

2 5222

What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

2 4727

What are the values that can be specified for OPTIMIZER MODE Parameter ?

1 3972

Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?

1 3989

What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?

1 4142

What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?

1 4361

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 4414

What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

2 4530

What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 4438

Un-Answered Questions { Databases }

What is crud sql?

996

List some of the features of postgresql ?

804

Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

1653

What is recursive join in sql?

1043

Explain the wait events in statspack report 'db sequential real'?

653

what is data manipulation language? : Sql dba

1029

Does office 2016 have access?

761

What does clouddb kit mean?

how to enter binary numbers in sql statements? : Sql dba

988

What is the difference between sql and postgresql?

923

How do I view a mysql database?

916

Can a view be mutating? If yes, then how?

1044

What are triggers and its types?

1086

What is difference between db2 and sql?

1017

write a query to retrieve the last day of next month in oracle.

946

For More Un-Answered { Databases } Questions Click Here