State the acid rules?
What are the three types of database design?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
Can an extended stored procedure be called from inside a user-defined function?
What is data modeling with example?
What is the database development process?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
Which four data types cannot be used as a return type from a user-defined function?
How would you design a database for an online site, which would average a million hits a day?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
What are the constraints on severity level in raiseerror?
Explain the rollup operator?
Explain the cube operator?