Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3259)
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

992

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

1023

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

1024

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

985

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

993

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

996

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

990

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

1102

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

1269

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

1000

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

1017

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

954

explain extended properties

1008

What are the results of running this script?

947

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?

1025

Un-Answered Questions { Databases }

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2460

How to make remote connection in database?

1019

explain what is mysql? : Sql dba

1096

What is user in mysql?

900

What is policy management?

1013

How does stuff differ from the replace function?

1030

Can we return Data from 4(more than 1) tables in stored procedure?

1082

what are the performance views in an oracle rac environment?

1072

What is nvarchar in sql?

953

please explain.. DB architecture ...

2043

Explain autonomous transaction.

1175

What is data source document?

1053

Is mongodb easy to learn?

How many database systems are there?

961

Mention what are the core components of ssrs?

326

For More Un-Answered { Databases } Questions Click Here