What is Schema in Database?
Answer / 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 |
Explain what is it unwise to create wide clustered index keys?
How do I create an extended event in sql server?
How to change the password of a login name in ms sql server?
Comment,Datatypes are unlimited
Explain what is dbcc?
What is faster join or union?
Can you tell me some of the common replication dmv's and their use? : sql server replication
What do you mean by an execution plan?
What are the advantages of passing name-value pairs as parameters?
Can you explain some of the DTS problems?
What is field in algebra?
explain different types of cursors? : Sql server database administration
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)