QUESTION 18 Ina database, processing logic for the query is performed on the dev
ID: 3866692 • Letter: Q
Question
QUESTION 18 Ina database, processing logic for the query is performed on the device that holds cach database shard and if necessary, results are consolidated by the DBMS. a. NoSQL O b. relational C. OLAP o d. SQL QUESTION 19 The SQLc O a. JOIN command allows you to temporarily join and simultancously access the data in more than one table. b. SELECT c. UPDATE d. MERGE QUESTION 20 Which database data type is a collection of binary data stored in a single field of a database? a. Logical b. Integer C. BLOB d. Memo QUESTION 21 A(n)is O a. object is a factor that remains the same throughout a program. b. variable c. constant O d. algorithm QUESTION 22 Which of the following is not a characteristic for a good problem statement? It clearly specifies the known information. b. It specifies any assumptions that define the scope of the problem. c. It contains detailed descriptions of the processes and tools that need to be developed. od. It specifies when the problem has been solved.Explanation / Answer
18)a
NO SQL
19)a
JOIN
command allows you to temporarily join and simultaneously access the data in more than one table.
20)C
BLOB
a database data type that is a collection of binary data stored in a single field of a database
21)C
Constant is a factor that remains the same throughout a program
22)
C