If a column is an image value type, how you can compare column values? How can you use this column in join clause?
952You 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?
1011You 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?
924The 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?
954What are the three basic rules which are to be followed for the relational model of the database?
944Post New DB Development Questions
fact table and dimension table containg one to many relationship or many to one relastionship
What is DB Development software?
What are the types of database model?
What is dbms explain in brief?
How to use timestamp datatypes
Explain about xml databases?
How can I detect whether a given connection is blocked?
What are the three types of database design?
Write short notes on manual refreshes.
How would you design a database for an online site, which would average a million hits a day?
Explain about network model?
What are the key features of dbms?
What is dbms and its application?
What is the physical representation for a many-to-many relationship?
How to combine two function together?