What is a Schema ?

Answers were Sorted based on User's Feedback



What is a Schema ?..

Answer / abc

schema is the overall logical design of the database

Is This Answer Correct ?    12 Yes 0 No

What is a Schema ?..

Answer / s. senthil kumar

A schema is collection of database objects of a User.

Is This Answer Correct ?    3 Yes 0 No

What is a Schema ?..

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

What is a Schema ?..

Answer / santhi

Schema is a collection of database objects of a user

Is This Answer Correct ?    1 Yes 0 No

What is a Schema ?..

Answer / sawant

The set of objects owned by user account is called the schema.

Is This Answer Correct ?    1 Yes 1 No

What is a Schema ?..

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

Post New Answer

More Oracle General Interview Questions

what are pseudocolumns?

4 Answers  


Is oracle an open source?

0 Answers  


what is analyze command ? what kind of statistics does it generate?

2 Answers  


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?

0 Answers   Oracle,


I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?

1 Answers  






What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

0 Answers   CGI,


What are various constraints used in SQL?

1 Answers   Polaris,


What is the difference between $oracle_base and $oracle_home?

0 Answers  


What is a public synonym?

1 Answers  


How would you best determine why your MVIEW couldnt FAST REFRESH?

0 Answers  


How many data types are supported?

0 Answers  


What do you mean by redo log file mirroring?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)