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

What are the basic features of a trigger in ms sql server?

1273

Where is my database stored on the hard disk in ms sql server?

1112

What is a database in ms sql server?

1108

What are commonly used mssql functions in php?

1148

How to use subqueries with the exists operators in ms sql server?

1183

How to get the definition of a stored procedure back?

1027

What is a schema in ms sql server 2005?

1031

How many categories of data types used by sql server?

1059

How to create a dynamic cursor with the dynamic option?

1111

How to insert a new row into a table with "insert into" statements in ms sql server?

1018

How to see existing views in ms sql server?

1116

How to use wildcard characters in like operations in ms sql server?

1193

How to list all schemas in a database?

1106

What happens if date-only values are provided as date and time literals?

1080

How to provide values to stored procedure parameters in ms sql server?

1105

Un-Answered Questions { Databases }

What is an index in sql?

1073

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

2087

What is raid? How does it help storage of databases?

1135

what are constraints? Explain different types of constraints? : Sql server database administration

1051

What is action query?

951

What is autonumber in ms access?

924

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2509

What do you mean by entity type?

1128

Enlist the advantages of normalizing database.

1089

How to create an array in pl/sql?

1125

Have you created sequence? When will you use?

602

What is an intersect?

1156

What is meant by database in access 2010?

961

What is database or database management systems (dbms)?

1009

Are sql connections encrypted?

1090

For More Un-Answered { Databases } Questions Click Here