Answer Posted / kalyan
A View is a named virtual table that is defined by a query
and used for a table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What is the purpose of indexing?
Explain the functionalities that views support?
What is difference between joins and subqueries?
How to create user defined functions with parameters?
How do I install only the client tools of sql server 2000?
What is multilevel indexing?
Mention the differences between local and global temporary tables.
Explain difference between cross join and full outer join?
What is sql server locking?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
what kind of lan types do you know? : Sql server database administration
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
What is a sql join?
What is an inner join?