If a column is an image value type, how you can compare column values? How can you use this column in join clause?
803You 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?
849You 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?
772The 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?
819What are the three basic rules which are to be followed for the relational model of the database?
783Post New DB Development Questions
How is data stored in dbms?
What is DB Development software?
What are data modelling techniques?
What is a database development?
What is normalization? Explain different levels of normalization?
Explain the rollup operator?
Explain the role of indexing in databases?
What are the constraints on severity level in raiseerror?
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.
State the acid rules?
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?
fact table and dimension table containg one to many relationship or many to one relastionship
How can I detect whether a given connection is blocked?
Explain about relational database management systems?
What are the key features of dbms?