What are the database objects in oracle?

<<Previous Next>>

Oracle - What are the database objects in oracle? - April 10, 2009 at 11:00 AM

What are the database objects in oracle?Explain them

Table
Composed of rows and column that stores data.

View
Represents subset of data from one or more tables.

Sequence
Auto generates primary key value.

Index
Improve performance of queries.

Synonym
Gives alternative names to object.

Oracle large objects

What is large object in oracle? Explain its purposes, Explain types of large objects in oracle, i.e. BLOB, LLOB,NCLOB and BFILE............

Oracle tablespaces

A table space can be considered as a storage location where the database objects are kept...........

What are Schema Objects?

Schema objects are the logical database structure that represents database's data. Schema objects include tables, views, sequences, synonyms, indexes, clusters, database.............

<<Previous Next>>

Write your comment - Share Knowledge and Experience


Interview questions
Oracle interview Oracle architecture Oracle FAQs Download Oracle/Java FAQ Test Oracle skills New More Oracle FAQs Oracle processes Oracle memory area Oracle file types Oracle database objects Oracle operators Oracle composite Oracle constraints Oracle data types Oracle DCL and TCL Oracle DML commands Oracle error handling Oracle functions Oracle procedure, package Oracle import and export Oracle sub queries Oracle table Oracle triggers Oracle views Oracle synonym Oracle indexes Oracle joins Oracle cursors Oracle form Oracle security Oracle system privilege Oracle object privileges Oracle table privileges Oracle view privileges Oracle backup & recovery Oracle DBA Oracle PL/SQL Oracle nested table & varrays Oracle large objects Oracle replication Oracle transaction Oracle optimizer Oracle auditing Oracle backup Oracle database tuning Oracle application tuning Oracle procedures Oracle functions Oracle loops Oracle exceptions Oracle Select into clause Oracle string functions Oracle numeric functions Oracle date functions Oracle translate and decode Oracle correlated sub-queries Oracle union, intersect, minus Oracle clusters Oracle sequences Oracle tablespaces Oracle object datatypes Oracle Tutorial


Latest MCQs
» General awareness - Banking	» ASP.NET	» PL/SQL	» Mechanical Engineering
» IAS Prelims GS	» Java	» Programming Language	» Electrical Engineering
» English	» C++	» Software Engineering	» Electronic Engineering
» Quantitative Aptitude	» Oracle	» English	» Finance
Home \| About us \| Sitemap \| Contact us \| We are hiring
© Copyright 2016. All Rights Reserved. Terms of use \| Follow us on Facebook!

What are the database objects in oracle?