Database Objects

Which of the following is not a database object?

• Table

• Sequence

• Index

• Relationship

The user defined data type can be created using ..............

• Create type

• Create data

• Create datatype

• Create definetype

A logical structure of the database is ...............

• Schema

• Attributes

• Instance

• Record

Which of the following database object is ideal to view, change, and analyze data in different ways ?

• FORM

• TABLE

• QUERY

• REPORT

Which of the following is the use of index?

• Simply the user’s perception of the data

• Retrieve data more quickly and efficiently

• Retrieve data more quickly

• None of these

Where is the data dictionary kept?

• Stack Space

• Data file

• SYSTEM tablespace

• None of these

Which of the following object types below cannot be replicated?

• Sequence

• Data

• Trigger

• View

Is it possible to create a view without the existence of the base table?

• YES

• NO

Varray is the data type used to define the attribute of

• Simple

• Multi-valued

• Composite

• Derived

Abstract Data Type is the object used to define the attribute of type ...........

• Simple

• Composite

• Multi-valued

• Derived