Schema objects elements - Oracle Architecture
Oracle (MCQ) questions and answers
Q. What do the schema objects comprise of?
- Published on 12 Aug 15
All of the above
ANSWER: All of the above
Oracle DBA (
Oracle Replication (
Oracle Architecture (
Oracle Transaction (
Administering and Managing an Oracle Database (
Managing Oracle Database Processes (
Oracle Control Files (
Oracle Redo Log (
Oracle Tablespaces (
Oracle Datafiles and Tempfiles (
Oracle Managed Files (
Oracle Schema (
Oracle Tables (
Oracle Indexes and Partitioned Tables (
Oracle Clusters (
Oracle Views, Sequences, and Synonyms (
Oracle Distributed Database concepts (
-Posted on 26 Aug 15
-A schema is a collection of logical structures of data, or schema objects.
-A schema is owned by a database user and has the same name as that user.
-Each user owns a single schema.
-Schema objects can be created and manipulated with SQL and include the following types of objects:
- Index - It is a structure used to help to retreive data more quickly and efficiently
-Clusters - It is a set of tables physically stored together as one table that shares a common column.
-Tables - It is where data is put into organized format in the form of columns and rows.
Post your comment / Share knowledge
Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)