C182- SQL- DIKW- APPLICATION SYSTEMS QUIZZES WITH RIGHT VERIFIED ANSWERS .

C182- SQL- DIKW- APPLICATION
SYSTEMS QUIZZES WITH RIGHT
VERIFIED ANSWERS .


takes rows from one table and creates a new table - correct Answers -Selection


is the condition the query is requesting. - correct Answers -WHERE


combines distinct fields from multiple tables that have the same set of attributes and data types. -
correct Answers -UNION


bring together rows from two or more SQL tables, based on a related column between them -
correct Answers -JOIN


databases can accommodate a wide variety of data models, including key-value, document,
columnar, and graph formats - correct Answers -NoSQL


system of data stored in raw format. - correct Answers -data lake


What is the expected output for the following SQL query?


SELECT * FROM Patient WHERE LastName = 'Moore'; - correct Answers -All records from
the Patient table where the patient's last name is "Moore"


Which database can increase resources to accommodate for demands on the system while
maintaining high availability even in the case of local or regional outages? - correct Answers -
Cloud Database



1