If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Explain the family trees and connection by clause.
Who are naive users?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
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?
What are defaults? Is there a column to which a default can't be bound?
How to customize error conditions.
Explain about the storage and physical database design?
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?
1 Answers Flextronics, Hexaware, SQL Star,
What are the disadvantages of cursors? How can you avoid cursors?
Which data type cannot be used as a parameter in a udf?
Which four data types cannot be used as a return type from a user-defined function?
In which table collections errors are stored.