Answer Posted / pradeep
Schema is a logical set of data. It contains tables, views,
Packages, constraints. This is treated as a whole database.
This has assigned with a unique id called as SID i.e.
System ID. Because of this ID one can create n number of
DBs on a single DB server. Obviously within the limit of
the hardware of DB server.
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Explain raiserror in sql server?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
Distinguish between commit and rollback?
Can group functions be mixed with non-group selection fields in ms sql server?
What are commonly used mssql functions in php?
What is the difference between stored procedure and functions?
Tell me what is the difference between locking and multi-versioning?
How do I create a stored procedure in dbml?
Explain trigger and its types?
What is the syntax for encrypting a column in SQL Server?
what purpose does the model database serve? : Sql server database administration
How many servers can we create in a single subscription?
What is schemabinding a view?
How to modify an existing stored procedure in ms sql server?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
