If a column is an image value type, how you can compare column values? How can you use this column in join clause?
988You 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?
1058You 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?
961The 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?
989What are the three basic rules which are to be followed for the relational model of the database?
1009Post New DB Development Questions
Explain about relational database management systems?
explain detail about ftp in datastage?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
What is DB Development software?
What are the constraints on severity level in raiseerror?
What are the three types of database design?
How is data stored in dbms?
What is the database development process?
I have a few records all are same structures data, I want to store data in multiple targets how
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
In which table collections errors are stored.
How can I detect whether a given connection is blocked?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Explain about the relational database?
What is normalization? Explain different levels of normalization?