Database Final Exam
String | CARACTER (CHAR)CHARACTER VARYING (VARCHAR or VARCHAR2)BINARY LARGE OBJECT (BLOB) | Stores string values containing any character in a character set. CHAR is defined to be a fixed length.Stores string values containing any characters in a character set but of definable variable length.Stores binary string values in hexadecimal format. BLOB is defined to be a variable length. (Oracle also has CLOB and NCLOB, as well as BFILE for storing unstructured data outside the database.) | Number | NUMERICINTERGER(INT) | Stores exact numbers with a defined precision and scale.Stores exact numbers with a predefined precision and scale of zero | Temporal | TIMESTAMPTIMESTAMP WITH LOCAL TIME ZON | Stores a moment an event occurs, using a definable fraction-of-a-second precision. Value adjusted to the user’s session time zone (available in Oracle and MySQL) | Boolean | BOOLEAN | Stores truth values: TRUE, FALSE or UNKNOWN |
c. The relational data model assumes that you have completed the activity 'An ER Model
d. The power of the RDBMS is realized through….
The relationship existing between the tables. The relationships are established by including common column or columns in every table where a relationship is needed. 2. (Chapter 06): What are six potential benefits of achieving an SQL standard? Pg.245-246 a. Reduce training cost b. Productivity c. Application portability d. Application