Interested to Buy Any Domain ? << Click Here >> for more details...
What is a Schema ?
- 6 Answers
- 9245 Views
- I also Faced
- E-Mail Answers
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 |
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
what is IDE,DMV in sql server?
How to create a stored procedure in oracle?
What are the uses of linked server and explain it in detail?
Who i will insert 1 lacks record in a Database table
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What happens in oracle commit?
various types of hints and their usage
Explain oracle data types with examples?
What is an Index ? How it is implemented in Oracle Database ?
when loggined as SYSTEM,how to display all the users of database using sql query?
Oracle General 
