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

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?

1 2665

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

1 4463

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????

1 4081

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

Jade Software,

6 10529

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 3761

What is the difference between windows authentication and sql server authentication

HCL,

7 24536

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,

1 2288

what is the difference between the query and corelated query

HSBC, IBM, TCS, Xenosoft,

8 21125

how can i store resumes in database?

HCL,

3 10144

How can you hide the report in Apps?

1 4230

How can we overcome recursive triggers in SQL?

iFlex,

1 9531

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 4044

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

Tanla Solutions, TS,

5 16604

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

IBM, Tanla Solutions,

6 23207

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

1 10375

Un-Answered Questions { Databases }

What is the difference between case version and decode version?

1104

What is the current version of sql?

1091

What is temporary table in sql server? Why we use temp table?

1013

Design database draw er diagram for a certain scenario ?

4650

When should you use an instead of trigger?

1045

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1065

What is self contained sub query?

1138

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?

1605

What is your daily office routine?

2340

what is bcp? When does it used? : Sql dba

1053

How to Change a users password from unix shell.

1214

How to use values from other tables in update statements using oracle?

1150

What is the best sql course?

1046

please send me oracle pl/sql exp resume. and also faqs...

2567

Explain “row_number()” in sql server with an example?

1073

For More Un-Answered { Databases } Questions Click Here