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 stored procedure would you use to view lock information? : Sql server administration

1 1042

if no size is defined while creating the database, what size will the database have? : Sql server administration

1 1075

what stored procedure can you use to display the current processes? : Sql server administration

1 1077

what information is maintained within the msdb database? : Sql server administration

1 1033

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

1 1051

how you can move data or databases between servers and databases in sql server? : Sql server administration

1 1040

can a table be moved to different filegroup? : Sql server administration

1 1047

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

1 1160

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1 1335

What is the difference between a fill factor of 100 and 0?

1 1057

A trigger can reference objects outside the current database? State true or false.

1 1094

How can you list all the table constraints in a database?

1 1001

explain extended properties

1 1055

What are the results of running this script?

1 994

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1 1079

Un-Answered Questions { Databases }

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1601

How do I start sql server 2017?

1011

what is schema? : Sql dba

1134

How did mongodb get its name?

List the ways in which dynamic sql can be executed?

1079

How raid can influence database performance?

1110

Equi join and non equi join is possible with sql server?

1126

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1291

What is normalization and what are the advantages of it?

1052

How to start an oracle instance?

1096

What is the current version of postgresql?

1163

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

What is a scheduled job or what is a scheduled task?

1031

What is the difference between case version and decode version?

1102

how to escape special characters in sql statements? : Sql dba

1110

For More Un-Answered { Databases } Questions Click Here