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 |
How to get a list of columns in a view using "sys.columns" in ms sql server?
what is Covering Index ?
write query for fourth maximum salary from employee table
14 Answers Mind Tree, SP Software,
List the different normalization forms?
How will u get 5 years back record?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What is difference between clustered index and non clustered index?
In which files does sql server actually store data?
Why SQL Agent is used?
What is de-normalization and what are some of the examples of it?
Where is localdb stored?
Why is normalisation important?
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)