RelationalDBDesign
SiteMap
PL/SQL
Stored Objects
PL/SQL Programming
PL/SQL
«Prev
Next»
Programming PL/SQL
Querying Object Tables
Object Oriented Terms
Collections Varrays Oracle
Querying Nested Tables
Practical/SQL Examples
Querying Complex SQL Object
SQL Query Example
Using Oracle Objects
Querying Related Tables
Understanding Related Object Tables
Analyzing Dangling References
Writing deref Queries
Oracle deref Syntax
Querying Object Tables
Creating PL/SQL Block
Object Relational Conclusion
Querying Nested Tables
Flattening nested Table
Flattening nested Table Example
Simple varray Query
Query to Flatten varray
Query Flattens Nested Table
Procedure retrieves Nested Table
Varrays Nested Table Conclusion
Object Table Modification
Insert into Table
SQL Insert Rows
Write SQL to Update Object Table
Subquery in Update
Delete Rows from object Table
DML Statements Conclusion
Updating Rows Example
Modifying Nested Tables
Insert Rows into Nested Table
Delete Command for Nested varray
Updating Varray Rows
inserting Data in Nested Table(Example)
Varray insert Command
Modifying LOBs
Querying Modifying LOBs - Quiz
1.
What is the difference between an internal and an external LOB?
Please select the best answer.
A.
An internal LOB is maintained with the object table data, whereas an external LOB is maintained within a separate tablespace.
B.
An internal LOB is maintained within the operating system of the database, whereas an external LOB is maintained within the network outside the server, which hosts the database.
C.
An internal LOB is maintained inside the database, whereas an external LOB is maintained outside the database.
D.
An external LOB is maintained within the database, whereas an internal LOB is maintained inside the server, but outside the database.
2.
What is the difference between CLOB and NCLOB?
Please select the best answer.
A.
CLOB is character-based LOB, whereas NCLOB is natural-character-based LOB.
B.
NCLOB is based on the national character set, whereas CLOB is based on the character set defined in the creation of the database.
C.
CLOB has binary data, whereas NCLOB has character-based data.
D.
NCLOB is based on raw data, whereas CLOB is based on character data.
3.
What are the two ways of loading data into LOB columns?
Please select the best answer.
A.
INSERT
statements and Oracle Export and Import..
B.
SQL*Loader and DBMS_LOB.
C.
Oracle Backup utility and Oracle Export and Import.
D.
LOB data cannot be loaded into an Oracle database.
4.
What is the utility of
DBMS_LOB
?
Please select the best answer.
A.
DBMS_LOB
is used only for loading data into the LOB columns.
B.
Data can be erased and updated by using
DBMS_LOB
.
C.
DBMS_LOB
is a package used for displaying the LOB data.
D.
DBMS_LOB
is a package that has several utilities on internal and external LOBs, including reading, writing, appending, and erasing LOB data among other utilities.
Correct answers:
Your Score: 0
Submit
Quiz Explanation