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 |
What are the steps you should follow to start sql server in single-user mode?
When do you think a developer should use sql server-based cursors?
how to avoid cursors? : Sql server database administration
What are the disadvantages of indexes?
What is the purpose of object explorer and its features? : sql server management studio
What is row_number function?
What is table valued function and scalar valued functions?
What are the functions in sql server?
What is the syntax for encrypting a column in SQL Server?
how we can store the value like that 001,003,023 etc in sql server 2005
Do you know the policy based administration feature of sql server 2008?
What are the grouping functions?
Oracle (3259)
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)