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 myisam tables? : Sql dba

1082

how to increment dates by 1 in mysql? : Sql dba

1037

what is sql in mysql? : Sql dba

1245

how to show all tables with 'mysql'? : Sql dba

1161

how many columns can be used for creating index? : Sql dba

989

how to rename an existing table in mysql? : Sql dba

1129

Mention the differences between substr and charindex in sql server.

1124

Write an sql query to find first weekday of the month?

992

What do you understand by triggers and mention the different types of it?

1004

When do you think a developer should use sql server-based cursors?

1117

Mention the differences between having and where clause.

1124

Explain the usage of floor function in sql server.

1033

What do you understand by replication in sql server?

1138

What do you understand by hotfixes and patches in sql server?

1037

Mention the different authentication modes in sql server.

1115

Un-Answered Questions { Databases }

Explain ranking functions?

1099

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

965

What is the most common database language that a db administrator needs to know?

610

What is the maximum rows in sql server table?

969

Explain table queries and select queries.

870

Explain the types of record group.

How do I find my localdb version?

1035

When an object attribute is removed, is it deleted from the store?

Write SQL queries on Self Join and Inner Join.

1229

what are the security recommendations while using mysql? : Sql dba

1188

Is mongodb a graph database?

If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?

632

A single operation is failing to escalate?

878

What is measure group, measure? : sql server analysis services, ssas

1079

What is multilevel indexing?

983

For More Un-Answered { Databases } Questions Click Here