RelationalDBDesign
SiteMap
PL/SQL
Stored Objects
PL/SQL Programming
Object Tables
«Prev
Next»
Programming PL/SQL
Querying Object Tables
Using Oracle Objects
Object Oriented Terms
Query Object Tables
Collections Varrays Oracle
Querying Nested Tables
Practical/SQL Examples
SQL Query Example
Querying Complex Object
Alternate Query Example
Object Relational Summary
Querying Related Tables
Understanding Related Object Tables
Analyzing Dangling References
Writing deref Queries
Querying Object Tables
Creating PL/SQL Block
Object Relational Conclusion
Querying Nested Tables
Flattening nested Table
Query Flattens Nested Table
Simple varray Query
Query to Flatten varray
Flatten varray - Exercise
Procedure retrieves Nested Table
Varrays Nested Table Conclusion
Object Table Modification
Modifying Object Tables
Insert into Table
SQL Insert Rows
SQL Update Object Table
Subquery in Update
Delete Rows from Table
DML Statements Conclusion
Modifying Nested Tables
Modifying nested Varrays
Insert Rows into Table
Varray insert Command
Updating nested Table Rows
Updating Varray Rows
Delete Nested varray Command
Delete Entire Array
Nested Tables Conclusion
Modifying LOBs
Oracle Nested Tables - Quiz
Each question is worth one point. Select the best answer for each question.
1.
What is the difference between an object type and an object?
Please select the best answer.
A.
There is no difference.
B.
An object type has data associated with it, whereas objects can be used as building blocks for other objects and tables.
C.
An object type can be used as a building block for other objects and tables, whereas objects have data associated with them.
D.
Objects are persistent, object types are not.
2.
What are the limitations with the relational approach that are resolved by the object-relational approach?
Please select the best answer.
A.
The limitations include objects, object types, attributes, and methods.
B.
There are no limitations with the relational approach.
C.
The limitations exist in the definition of objects.
D.
The limitations that are resolved in the object-relational approach include representing encapsulation, composition, aggregation, and inheritance.
3.
What are the two types of collections?
Please select the best answer.
A.
Objects and object types.
B.
Varrays and nested tables.
C.
Tables and columns.
D.
Oracle8i does not support collections.
Correct answers:
0
Submit
Quiz Explanation