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 many columns can we include on clustered index ?
Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance
What is difference between view and materialized view?
What do you mean by the term 'normalization'?
1 01 101 01010
How many levels of sp nesting is possible?
What are dml triggers and types of dml triggers?
Explain data warehousing in sql server?
when you create a database how is it stored? : Sql server database administration
How to create a simple stored procedure in ms sql server?
What is difference between index and primary key?
What is the difference between ‘having’ clause and a ‘where’ clause?
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)