| Team Fly | |
9. What happens when one tries to store the text ''Madagascar" in a field with a specification of varchar2(8)?
10. What is the most common way one uses triggers in the Oracle Database 10g? Give an example of this activity.
11. What programming language, native to the Oracle Database 10g, is used to create stored objects such as triggers and functions?
A. SQL*Plus
B. OEM Grid Control
C. Basic
D. PL/SQL
12. What is the role of the sysaux tablespace in the Oracle Database 10g?
13. The clob and blob data types differ in all but one of the following three ways. Which one does not apply to the differences between the two data types?
A. The clob holds standard alphanumeric data, whereas the blob may store binary information.
B. The blob contains a time (hour/minute) component, but the clob does not.
C. The blob contains unstructured free-form data, whereas the rules governing the type of information that can be stored in the clob are more stringent.
14. There are many ways to replicate data from one node to another. What main feature does Oracle Streams provide that is missing from many other methods?
15. What does the acronym SQL stand for?
A. Structured Query Language
B. Simple Query Language
C. Straightforward Question-based Learning
| Team Fly | |