Database Final Exam
1. (Chapter 06): Describe a relational DBMS (RDBMS), its underlying data model, data storage structures, and manner of establishing data relationships: a. A relational DBMS (or RDMBS) is a data management system that implements a relational data model, one where data are stored in a collection of tables and the data relationships are represented by common valves, not links. Pg.247 b. Data are stored in a collection of tables and the data relationships are represented by common values not links.
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
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