Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. All of the following terms represent the same concept, except: a. Table b. Entity d. Relation C. Information 2. The process of finding
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started