NEW
Font size
WorksheetsDatabase Objects
Total questions: 10
Worksheet time: 5mins
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
