DB2 302 - 129.docVIP

Relational Data Model What are the entities used to model data in the Relational Model? A. A collection of instances of entities. B. Relations, attributes and tuples C. A collection of instances of record types. D. Table, rows and columns Answer: B Which of the following is true about Relational Databases? A. A column can store values of different data types. B. A table consists of columns and rows. C. Rows in the same table can have a different set of columns. D. Rows are also known as fields of the table. Answer: B A company has a large amount of data to store and wants to be able to do the following with the data: Have a standard interface for accessing the data. Have multiple users with the ability to insert, update and delete data. Make changes to the data without risk of losing data and its consistency. Have the capability to handle huge volumes of data and users. Have tools for data backup, restore and recovery. What data storage method is the most optimal solution for the company? A. Text files B. Comma delimited data files C. Spreadsheets D. Database Answer: D When using a Relational Database, which of the following does not apply? A. Accesses data using Data Manipulation Language (DML) such as SQL. B. Define your database schema using a Data Definition Language (DDL). C. Data is stored in a hierarchical model. D. You can use normalization to avoid redundant data in your tables. Answer: C Which of the following is not true about the Information Model? A. Abstract management of objects at a conceptual level. B. Defines relationships between managed objects. C. It is a group of descriptions explaining objects of a data model. D. Data models can be used to map an Information Model to a software implementation. Answer: C Which Data Model was created with the focus of providing better data independence? A. Relational B. Hierarchical C. Semantic D. Network Answer: A Which of the following is NOT true abo