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
Write a SQL queries on Self Join and Inner Join.
What is de-normalization in sql database administration? Give examples?
What is NOT NULL Constraint in sql server 2012?
What is 1nf 2nf?
How to create a dynamic cursor with the dynamic option?
Explain forward - only cursors?
What are sql server functions?
You want to use a perspective in an mdx query. How do you select the perspective?
What is molap and its advantage? : sql server analysis services, ssas
What is database dimension? : sql server analysis services, ssas
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
How many full-text indexes can a table have?
What is difference between view and materialized view?
List the different types of collation sensitivities in sql server?
What is the difference between for xml raw and for xml auto?