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

How display code or Text of Stored Procedure using Sql query in Sql Server ?

Wipro,

1203

Difference between connected and disconnected database in .net with sql server?

Infosys,

1152

Give the query of getting last two records from the table in SQL SERVER?

Petranics Solutions,

1018

How to filter records of table in SQL SERVER?

Petranics Solutions,

1136

What types of Joins are possible with Sql Server?

NA,

1196

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1207

What is GUID in sql server?

BirlaSoft,

1229

How to achieve Paging of records in SQL SERVER?

Petranics Solutions,

1151

What is #temp and @table variable in SQL server?

1146

What is Service Broker in sql server 2012?

UGC Corporation,

1080

What are the different types of triggers in SQL SERVER?

1200

How to encrypt Strored Procedure in SQL SERVER?

1234

How many types of Cursor in SQL SERVER?

1 1651

What are the Advantages of using CTE in sql server?

Winsol Solutions,

1172

How to reaname table name without using sp_Rename in sql server..?

Wipro,

1043

Un-Answered Questions { Databases }

What is stored procedures?

1114

How do I view tables in mysql workbench?

975

Define oracle database

1105

How would you improve throughput in sybase?

1037

How do I run a query in pl sql developer?

1055

Tell me about builtinadministrator?

1049

What is the difference between left and left outer join?

999

How do you explain an index?

1334

Can sub procedure/function be called recursively?

1054

Explain the architecture models of SQL Server?

2386

What is the use of double ampersand (&&) in sql queries? Give an example

1192

How to change database dialect?

1038

Explain the concept of acid properties in dbms?

1159

Mention what are the key characteristics of rac or why to use rac?

What are data modelling techniques?

1029

For More Un-Answered { Databases } Questions Click Here