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

how to saw triggers output in pl/sql database?

1 7461

I developed on form as per my requirement,and register that one in apps custom_top.But the problem is ,if you open the form but not closed,I founded why this is error is comming ,the custom_top is not supported my form . I need any one your help in advicing me...what I do the custom_top supported the forms.

1 3561

can i gat any proper material for sybase if possible plz let me know balaji.cc1@gmail.com

2 7415

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

2060

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance

2 4814

how to rename the table

3 7343

how many type of subquery?

2 7142

what is difference between primary key and Unique

8 9414

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

SAP Labs,

3 9094

HOW TO RENAME A COLUMN NAME

3 7323

One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.

Polaris,

6 16063

If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 4933

What is cursor

TCS,

4 9729

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

2002

what is cluster and nin-cluster index?

4 6940

Un-Answered Questions { Databases }

Is database a data structure?

874

What is factless fact table? : sql server analysis services, ssas

1039

Explain the microsoft sql server delete command? : SQL Server Architecture

1091

What is a pl/sql block?

1236

What is difference between sybase and oracle?

937

Explain different types of lock modes in sql server 2000?

938

What is Data Redundancy and Consistency ?

1006

What is the sql case statement used for?

1105

What is string join?

981

What is trigger and how to use it in sql?

1025

What is meant by a deadlock situation?

1112

What is multiple columns?

1076

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

942

How do I pipe the output of isql to a file in sybase?

891

What are the three types of database design?

1026

For More Un-Answered { Databases } Questions Click Here