Final 10 July 2018, questions PDF

Preview

Summary

Past exam questions...

Description

1807) PP Semester 1, 2018 ITECH1103 Big Data and Analytics SECTION 1 – Multiple Choice Questions [TOTAL = 10 MARKS] Attempt ALL Ten (10) questions, one mark for each question. For each question, please circle the most appropriate answer. 1. In a relationship, when a primary key from one table is also defined in a second table, the field is referred to as a ____ in the second table. a) combined key b) redundant field c) primary key d) foreign key 2. Students and classes have what type of relationship? a) one-to-one b) many-to-one c) many-to-many d) one-to-many 3. MySQL is an example of the __________ a) Hierarchical data model b) Flat file system model c) Network data model d) Relational data model 4. Which of the following is NOT an advantage of using a database management system compared to using a spreadsheet? a) Security b) Reduced redundancy c) Low initial cost d) Enforcement of integrity rules 5. Which of the following statements concerning the primary key is true? a) All primary key entries are unique. b) The primary key may be null. c) The primary key is not required for all tables. d) The primary key data do not have to be unique.

6. The ____ keyword is used to assign a column alias. a) LET b) SET c) AS d) ALIAS 7. "1, Northways Road, Churchill, Victoria, Australia, 3842" is an example of a ______ attribute. a) simple b) composite c) multivalued d) complex 8. Which query will output the table contents when the value of the character field CODE is alphabetically less than 1558-QW1? a) SELECT CODE, NAME, DESCRIPTION, PRICE FROM PRODUCT WHERE CODE < '1558-QW1'; b) SELECT CODE, NAME, DESCRIPTION, PRICE FROM PRODUCT WHERE CODE BETWEEN 'A' OR 1558-QW1; c) SELECT CODE, NAME, DESCRIPTION, PRICE FROM PRODUCT WHERE CODE...