DB Development Interview Questions
Questions Answers Views Company eMail

How to combine two function together?

1873

How to use timestamp datatypes

1785

How to replace not in with not exist?

1698

Explain the family trees and connection by clause.

1 4049

Write the difference between case version and decode version.

2 4253

Write short notes on manual refreshes.

2497

How to create an external table.

1 3701

How to customize error conditions.

1911

How to generate OIDS

1906

How to use online Backups?

1986

Write short notes on XSU and JAVA

1 4310

hi in which phase of mload can i use .FILLER

IBM,

1 4359

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

IBM,

2627

what is the use of foreginkey

2 5890

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

IBM,

2227


Post New DB Development Questions

Un-Answered Questions { DB Development }

What is data modeling with example?

713


How can you fix a poorly performing query?

864


What is DB Development software?

1815


I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2627


What are the three basic rules which are to be followed for the relational model of the database?

767


What is an application role and explain a scenario when you would use one?

773


fact table and dimension table containg one to many relationship or many to one relastionship

2275


How is data stored in dbms?

706


How can you log an error to the server event log from a stored procedure?

811


How to generate OIDS

1906


You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

758


The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

807


How to read and create .LDC data files which are used by linguatic dictionary.

2283


What is database design and development?

797


What are the constraints on severity level in raiseerror?

767