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

how to saw triggers output in pl/sql database?

1 7573

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 3692

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

2 7567

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.

1 2132

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 4971

how to rename the table

3 7507

how many type of subquery?

2 7286

what is difference between primary key and Unique

8 9714

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 9272

HOW TO RENAME A COLUMN NAME

3 7486

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 16400

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 5048

What is cursor

TCS,

4 9963

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

1 2078

what is cluster and nin-cluster index?

4 7173

Un-Answered Questions { Databases }

What is sql or structured query language?

1220

How to write a left outer join with the where clause in oracle?

1149

How do I find query history in sql server?

1018

Can we rollback truncate?

1072

How to convert character strings into numeric values?

1186

How to select all columns of all rows from a table in oracle?

1124

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8225

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2348

What are the different types of subquery?

1228

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1207

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

1073

Suppose database is running slow, what will you do?

2590

How to provide default values to function parameters?

1249

How do I find the sql server version?

1099

What is clustered index

1083

For More Un-Answered { Databases } Questions Click Here