What is schema?

Answer Posted / sandesha

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.
=============================
2nd:schema is collection of objects
(table,view,procedure,function.....)

Is This Answer Correct ?    11 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to run queries on external tables?

568


What is a cursor and what are the steps need to be taken?

601


What is a trace file and how is it created in oracle?

554


What are the attributes of the cursor?

561


22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1605






what are steps for interface? where is exchange rate defined in which table?

1499


How do you store pictures in a database?

563


How to retrieve the count of updated rows?

576


How do I limit the number of rows returned by an oracle query after ordering?

636


Which are the five query types available in oracle?

530


What are the database administrators utilities available?

578


What are triggers in oracle?

559


How to create a table index?

568


What is oracle server autotrace in oracle?

614


What is SQL Tuning Advisor in Oracle?

633