If a column is an image value type, how you can compare column values? How can you use this column in join clause?
1056You 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?
1119You 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?
1025The 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?
1051What are the three basic rules which are to be followed for the relational model of the database?
1071Post New DB Development Questions
Who are end users in dbms?
How can you log an error to the server event log from a stored procedure?
How to read and create .LDC data files which are used by linguatic dictionary.
How would you design a database for an online site, which would average a million hits a day?
Which data type cannot be used as a parameter in a udf?
Can an extended stored procedure be called from inside a user-defined function?
What is a database development?
What is DB Development software?
How to customize error conditions.
How can you fix a poorly performing query?
How can I detect whether a given connection is blocked?
Explain about query and reporting.
How to use online Backups?
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?
Explain the process of the user request and data generating?