What is schema?

Answer Posted / peter

Schema is a collection of database objects. A schema is
owned by a database user and has the same name as that
user. Schema objects are logical structures created by
users to contain, or reference, their data. Schema objects
include structures like tables, views, and indexes.

Is This Answer Correct ?    14 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle database client?

751


Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

853


What is an oracle tablespace?

769


What is a initialization parameter file in oracle?

753


How can I see all tables in oracle?

721


How to assign a tablespace to a users in oracle?

771


What are the different types of synonyms?

805


Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2688


what is the use of system.effective.date variable in oracle?

863


Explain oracle’s server parameter file.

741


Explain drop constraint oracle?

771


Explain what are the uses of rollback segment?

758


An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1805


What to do if the binary spfile is wrong for the default instance?

756


Explain the use of owner option in exp command.

751