|
Ask the Expert |
|
Q: Name the four main object privileges used in the Oracle Database 10g. |
|
A: The four most common privileges are select, insert, update, and delete. |
|
Q: Placing an Oracle Database 10g in a state where it can be accessed by applications is referred to as what activity? |
|
A: Putting an Oracle Database 10g in a normal operating mode for day-to-day access by a company's applications is referred to as startup. |
|
Q: How many integer and decimal digits can a field defined in the data dictionary as number(10,2) accommodate? |
|
A: The field would be able to store up to eight integer digits and two decimal digits. |
|
Q: When Oracle Database 10g is passed the value ''Beginner " for storage in a varchar2 column, how does it deal with trailing insignificant spaces? |
|
A: The trailing spaces are trimmed before the information is stored in the database. Though not as common as varchar2, the char data type can be used to store trailing spaces. |
|
Q: What would Oracle Database 10g store as a value in a number(6,2) field when passed the value 9.8882? |
|
A: It would store 9.89 in a number(6,2) field when passed 9.882. |
System privileges were introduced with early releases of Oracle7 (circa 1993) and have played a useful role in the division of labor in the database since their inception. Now it's time to get into the meat of the seventh letter of the alphabet, g, that throughout this chapter has followed the two-digit version number of this software release—10.
