CS6400 - Exam 1 - Fall 2016
1. What is a Database Management System?
1. A model of structures of reality
2. A model of processes of reality
3. A software system allowing you to define and use models of structures of reality
4. An application system that accesses a database
2. What may be a reason NOT to use a Database Management System?
1. Need to support multiple users
2. Need for persistent storage of data
3. The overhead of providing security, concurrency control, recovery and integrity control
4. Need for data independence
3. What does physical data independence allow you to do?
1. Change the Conceptual Schema without changing the Internal Schema
2. Change the Internal Schema without changing the Conceptual Schema
3. Change the External Schema without changing the Conceptual Schema
4. Change the Application Programs without changing the Internal Schema
4. Which of the statements does NOT describe differences between a database schema and a database state?
1. A database schema is relatively stable over time while the database state changes over time
2. A database state is relatively stable over time while the database schema changes over time
3. A database schema described the structure of the data that constitutes the database state
4. The database state can only be changed under the structures and rules described in the database schema
Please base your answers of the following questions on the Extended Entity-Relationship Diagram.
5. What is the identifier for USER? (See Diagram from T-Square)
1. USERNAME
2. USERNAME, PASSWORD
3. PASSWORD
4. None of the above
6. What is the identifier for INSTRUCTOR? (See Diagram from T-Square)
1. USERNAME
2. USERNAME, PASSWORD
3. PASSWORD
4. FIRSTNAME, LASTNAME
7. What is the identifier for COURSE? (See Diagram from T-Square)
1. COURSEID
2. SECTION, COURSE#, SEMESTER, YEAR, TITLE
3. COURSEID, TITLE
4. TITLE
评论0