What is a Schema ?
Answers were Sorted based on User's Feedback
Answer / abc
schema is the overall logical design of the database
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / s. senthil kumar
A schema is collection of database objects of a User.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / gmv lakshmi
A Schema is a collection of logical structures of data, or
schema objects. A schema is owned by the database user and
has the same name as that of user. Each user owns a single
schema. Schema objects include following type of objects
clusters, database links, functions, indexes, packages,
procedures, sequences, synonyms, tables, database triggers,
views.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / santhi
Schema is a collection of database objects of a user
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sawant
The set of objects owned by user account is called the schema.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / eshwari
Schema is nothing but the user.
the objects which are created by a user are called schema
objects means views,indexes,clusters,synonyms.
| Is This Answer Correct ? | 0 Yes | 0 No |
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to empty your oracle recycle bin?
Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?
Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle
Explain an index?
What is the maximum number of CHECK constraints that can be defined on a column ?
What is the difference between a vector and an Array? (Java)
What is a Shared SQL pool ?
Point the difference between translate and replace?
What happens in oracle commit?
how to unbreak sequence numbers during intereptions
Give the constructs of a package, function or a procedure.