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 to test odbc dsn connection settings?

1097

How to find out what is the default collation in a database?

1187

How to add a new dsn with the odbc driver for sql server?

1123

How to delete all rows with truncate table statement in ms sql server?

1057

How to write an inner join with the where clause in ms sql server?

1181

What are the differences between user defined functions and stored procedures?

1148

What is index fragmentation in ms sql server?

1154

How to turn off warning messages during php execution?

1125

What are the differences between char and nchar in ms sql server?

1155

How to generate create function script on an existing function?

1192

What is a collation in ms sql server?

1150

What do you need to connect php to sql server?

1174

What is sql language?

1256

Can another user execute your local temporary stored procedures?

1043

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1086

Un-Answered Questions { Databases }

What is a functional dependency in the dbms?

956

What is an Entity?

922

what is 'mysqld'? : Sql dba

1030

what is a database lock ? : Sql dba

1231

How would you change old and new values in an insert, delete and update triggers?

1085

How you can move data or databases between servers and databases in sql server?

1107

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2271

How do I run a sql query in pgadmin 4?

1006

List the different type of joins?

1126

Explain polymorphism in pl/sql.

1171

How do I install and use mysql?

1003

if i want to display the name of students such that to which city they belong must have count greaer than two

2321

How to define array in mongoose schema?

What is auto invoicing? Explain : oracle accounts receivable

1176

How to change program global area (pga) in oracle?

1159

For More Un-Answered { Databases } Questions Click Here