What is an application role and explain a scenario when you would use one?
What is bit datatype and what's the information that can be stored inside a bit column?
Can you instantiate a COM object by using T-SQL?
Can an extended stored procedure be called from inside a user-defined function?
What is an extended stored procedure?
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?
1 Answers Flextronics, Hexaware, SQL Star,
fact table and dimension table containg one to many relationship or many to one relastionship
Can you have a nested transaction?
How to generate OIDS
how will I find the duplicate rows count from employees tablein oracle.
Explain about relational operator join?
How to use timestamp datatypes
Explain about normal forms?