What is Schema? and why we use schemas?
Answers were Sorted based on User's Feedback
Schema is a collection of database objects.Using database
objects will manage the data in the database.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / debasish nanda
A schema is a mental structure we use to organize and simplify our knowledge of the world around us. We have schemas about ourselves, other people, mechanical devices, food, and in fact almost everything.
Schemas can be related to one another, sometimes in a hierarchy (so a salesman is a man is a human).
Using it:
Find people's schemas around the area of interest, then either create trust by utilizing their schema or reframe to change their schema.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / a.suresh
initial of the table is called schema.for using the
functions and other database table we are using schemas
| Is This Answer Correct ? | 0 Yes | 0 No |
What is catalog views?
What is a benefit of using an after insert trigger over using a before insert trigger?
Explain primary key in sql server?
Is it possible to update the views? If yes, how, if not, why?
What is storeprocedure?Tell me synatx for how to write stored procedure.
I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.
Explain different forms of normalization?
What is user-defined multi-statement table-valued function?
What is meant by referential integrity?
What are the steps you will take to improve performance of a poor performing query?
Can we hide the definition of a stored procedure from a use?
What is the difference between mysql and sql server?
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)