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
What is always encrypted?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
what are the different types of replication you can set up in sql server? : Sql server database administration
Explain primary key in sql server?
Why use cursor in sql server?
How to define the name and server for a new dsn?
Can a table be created inside a trigger?
Which language is supported by sql server?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
Where the sql logs gets stored?
What are different types of roles provided by ssrs?
Do you know what are the properties of the relational tables?
Mention the differences between local and global temporary tables.
Can we create clustered index on composite key?
Name few of the dcl commands in sql?