SQL - What are different Oracle database objects?

GeekInterview.com > Interview Questions > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 3 of 171

What are different Oracle database objects?

TABLES
VIEWS
INDEXES
SYNONYMS
SEQUENCES
TABLESPACES etc

Total Answers and Comments: 8

Last Update: September 16, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: ashish bharatkar

table

views

index

synonyms

sequences

and tablespace

Above answer was rated as good by the following members:
ashish88, kishorebabu.yenumula

August 10, 2005 04:15:13

Jasjeet

RE: What are different Oracle database objects?

* DB LINKS
* SYSTEM PACKAGES

Is this answer useful? Yes | No

September 01, 2005 09:35:28

Praful

RE: What are different Oracle database objects?

FUNCTIONS
PROCEDURES
TRIGGERS
JAVA SOURCES
JOBS
LIBRARIES
ROLES
CLUSTERS

Is this answer useful? Yes | No

October 13, 2005 06:00:09

pankaj

RE: What are different Oracle database objects?

different oracle database object

procedure
function
package
trigger
index
cluster
sequence
view
table

Is this answer useful? Yes | No

December 12, 2005 13:26:19

manju thanikonda

RE: What are different Oracle database objects?

* TABLES

*VIEWS

*SEQUENCES

*SYNONYMS

*INDEXES

Is this answer useful? Yes | No

December 25, 2005 13:16:13

ashish bharatkar

RE: What are different Oracle database objects?

table

views

index

synonyms

sequences

and tablespace

Is this answer useful? Yes | No

2 0

Overall Rating: +2

January 29, 2008 08:13:15

patilpravin_1981

Member Since: December 2007 Contribution: 29

RE: What are different Oracle database objects?

1. unique constraint
2. not null constraint
3. check constraint
4. primary key constraint
5 foreign key constraint

Is this answer useful? Yes | No

January 29, 2008 08:16:23

patilpravin_1981

Member Since: December 2007 Contribution: 29

RE: What are different Oracle database objects?

Oracle databse objects are
table
index
sequence
views
synonums
procedure
tiggers

Is this answer useful? Yes | No

September 16, 2008 01:10:48

sumanpani

Member Since: September 2008 Contribution: 11

RE: What are different Oracle database objects?

In Oracle DB Objects are

Table
View
Indexes
Sequences Used to generate primary key values
Synonym Used to give the alternate names of object

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank