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 are the advantages of using stored procedures in sql server?
What is the cartesian product of table?
How do you troubleshoot errors in a SQL Server Agent Job?
What is sleeping status in sql server?
What is 2nf example?
What are the various editions of sql server 2017 that are available in the market?
What are the properties of primary key?
What is use of dbcc commands?
when would you go for denormalization? : Sql server database administration
What is SQL Azure Firewall?
explain different types of backups avaialabe in sql server? : Sql server database administration
Can we add a cpu to sql server?
What are the advantages of paper records?
Can we return Data from 4(more than 1) tables in stored procedure?
Give main differences between "Truncate" and "Delete".
