Database Systems: ORDB Methods and Inheritance

To implement the behavior of objects.

Methods written in PL/SQL or Java are stored in the database, whereas those written in other languages like C are stored externally.

To denote the object instance on which the method is currently being invoked.

<p>To define the implementation of the member methods declared in the type definition.</p> Signup and view all the answers

<p>By creating a table of the custom data type using a CREATE TABLE statement.</p> Signup and view all the answers

<p>The method can reference the attributes of the object instance without using a qualifier.</p> Signup and view all the answers

<p>UNDER</p> Signup and view all the answers

<p>They must have different names from the attributes or methods in all its supertypes in the type hierarchy.</p> Signup and view all the answers

<p>Create a table with the type as its data type, and specify the primary key as desired, e.g. <code>Create table person_tab of person_type (pid primary key);</code></p> Signup and view all the answers

<p>Use the <code>INSERT INTO</code> statement with the subtype constructor, e.g. <code>INSERT INTO person_tab VALUES (student_type(4, 'Edward Learn', '65 Marina Blvd, Ocean Surf, WA, 6725', 40, 'CS'));</code></p> Signup and view all the answers

<p>VALUE() function</p> Signup and view all the answers

<p>The new subtype inherits all the attributes and methods of its parent type, both declared and inherited.</p> Signup and view all the answers

<p>It must be called repeatedly and can only compare two objects at a time.</p> Signup and view all the answers

<p>To return the count of projects associated with an employee.</p> Signup and view all the answers

<p>It reduces redundancy and increases flexibility and extensibility.</p> Signup and view all the answers

<p>It specifies the storage of the nested table.</p> Signup and view all the answers

<p>A subtype inherits from a supertype, which is a parent base type.</p> Signup and view all the answers

<p>To create user-defined types that can be used to define tables and objects.</p> Signup and view all the answers