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

i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?

2607

how do i list constraints in my database by using sql server2000?

1 4364

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4017

wat is the main diff between sql server 2000and sql server 2005

Jade Software,

6 10301

i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#

1 3675

What is the difference between windows authentication and sql server authentication

HCL,

7 24156

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

IGT,

2229

what is the difference between the query and corelated query

HSBC, IBM, TCS, Xenosoft,

8 20767

how can i store resumes in database?

HCL,

3 10015

How can you hide the report in Apps?

1 4135

How can we overcome recursive triggers in SQL?

iFlex,

1 9442

Please suggest me any course and institute which provide training on the below skills. • Knowledge of data extraction concepts and tools • QMF (query management facility)queries • Experience and expertise in QMF queries • Excellent ability to write, read, and interpret QMF queries against the Source Data Warehouse base level (daily and monthly) and month-end affinity comp tables • RDBMS & ER • Knowledge of Relational Databases (RDBMS) and Entity Relationship (ER) Diagrams • SOURCE Data Warehouse • Experience and expertise in Source Data Warehouse or data warehouses on the mainframe. • MS SQL Server • Experience in MS SQL Server • Excellent skill in writing/interpreting SQL queries and running Data Transformation Services (DTS) or open query packages. • Knowledge of writing/interpreting Visual Basic code.

1 3926

how many joins we can write if at all we have n no of tables

Tanla Solutions, TS,

5 16360

what is the order of execution of where,having,group by in select stement

IBM, Tanla Solutions,

6 22877

Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?

1 10224

Un-Answered Questions { Databases }

Will count(column) include columns with null values in its count?

1110

What are types of exception?

930

How long does it take to learn pl sql?

1083

How to create indexed view?

1060

What are the dmvs?

1022

What is the purpose of scan?

What Are Cross Validation & Adi?

1173

Explain the oracle real application clusters architecture?

what is database black box testing? : Mysql dba

1128

What does REVERT do in SQL Server 2005?

978

What are the types of dml?

1000

Should you start out with sharded or with a non-sharded mongodb environment?

Describe in brief databases and sql server databases architecture.

1023

Do you need a license for mysql?

952

What do you understand by data redundancy?

936

For More Un-Answered { Databases } Questions Click Here