1. All of the following terms represent the same concept, except: a. Table b. Entity d....

Transcribed Image Text:

1. All of the following terms represent the same concept, except: a. Table b. Entity d. Relation C. Information 2. The process of finding a good strategy for processing a query is called? a. Query optimization b. Query operations c. Query parsing d. None of the above. 3. SHARDING means: a. storing data with encryption c. discarding unused data 4. A DBMS system catalog identifies all of the following, except: a. Attribute names c. Column data value a. Isolation c. Atomicity b. tearing data into bits d. partition data across multiple databases 5. The ACID properties of a Big Data database include (circle all that apply): b. Consistency d. Big Data does not use ACID 6. Common steps in data analytics (circle all that apply)? a. Extracting b. Encrypting c. Transformed d. Loaded 7. Data in warehouses can usually be divided into b. fact tables d. dimension tables. a. raw data tables c. hidden tables b. Attribute data types d. Column indexes 8. All of the following are algorithms to evaluate join, except: a. Nested loop c. Sort-merge 9. All the following are DML commands, except: a. Select c. Create b. Index-nested loop d. B+-tree b. Delete d. Update 1. All of the following terms represent the same concept, except: a. Table b. Entity d. Relation C. Information 2. The process of finding a good strategy for processing a query is called? a. Query optimization b. Query operations c. Query parsing d. None of the above. 3. SHARDING means: a. storing data with encryption c. discarding unused data 4. A DBMS system catalog identifies all of the following, except: a. Attribute names c. Column data value a. Isolation c. Atomicity b. tearing data into bits d. partition data across multiple databases 5. The ACID properties of a Big Data database include (circle all that apply): b. Consistency d. Big Data does not use ACID 6. Common steps in data analytics (circle all that apply)? a. Extracting b. Encrypting c. Transformed d. Loaded 7. Data in warehouses can usually be divided into b. fact tables d. dimension tables. a. raw data tables c. hidden tables b. Attribute data types d. Column indexes 8. All of the following are algorithms to evaluate join, except: a. Nested loop c. Sort-merge 9. All the following are DML commands, except: a. Select c. Create b. Index-nested loop d. B+-tree b. Delete d. Update

Answer rating: 100% (QA)

The detailed answer for the above question is provided below The terms Table Entity and Information all represent the same concept in the context of a database They refer to a structured collection of ... View the full answer