Formulating Data Queries

Which of the following could represent the day that a patient visited me? VisitDate AdmittedDate DischargeDate All of the Above

All of the Above

What role does the FROM SQL command have? Defines which columns to select from Defines the speed of the query Defines the Output Defines which tables to query

Defines which tables to query

A data request should include which components? Role, workflow, information system, DIK Element, table names, columns to be SELECTed Purpose, Workflow, column names, tables Element, Role, Requirements, Request Fragments

Element, Role, Requirements, Request Fragments

What SQL command best acts as the Aggregate Filter? 1 point Where Having Order By Select Group By From

Having

Datasets from the government beyond healthcare utilization are provided by: i2b2 Healthdata.gov HCUP

Healthdata.gov

Ontologies help database administrators by: Enforce security Helping them re-locate pieces of queries used at some earlier time, to maintain semantics of the queries Ensure interoperability with outside entities Create novel data models Coursera Honor Code Lear

Helping them re-locate pieces of queries used at some earlier time, to maintain semantics of the queries

Four roles of a database administrator are: Maintain security, maintain business continuity, maintain semantics of the data, communicate with the client Maintain security, maintain confidentiality, maintain privacy, maintain the working environment Design data models, create ontologies, choose data standards, program queries

Maintain security, maintain business continuity, maintain semantics of the data, communicate with the client

If I want a list of patients visits ordered by Admit Date from 2019, which of the following SQL commands would I use? SELECT, FROM, WHERE, ORDER BY SELECT, FROM, HAVING SELECT, FROM, GROUP BY, ORDER BY SELECT, FROM, ORDER BY

SELECT, FROM, WHERE, ORDER BY

Which of the following SQL commands is needed to run a basic query? Having From Where Group By Select

Select