Introduction to CCL

What are the three main components of the Cerner Millennium?

• Admissions, orders, results, discharges

• Tables, fields, records

• SELECT, FROM, WHERE

• • Coded fields, joins, qualifications

Which statement is part of the basic SELECT statement?

• JOIN

• ORDER BY

• GROUP BY

• FROM

For what are used the Data Dictionary tools?

• To create sorts and sub sorts

• To identify tables and fields

• To build a prompt

• • To format a field

What is the purpose of using indexes in the Discern Explorer language?

• To create qualifications

• To build reports

• To format fields

• To join tables

Which Cerner application is used to build an ad hoc query?

• Cerner Millennium

• Discern Visual Developer (DVDev)

• Query Builder

• • Cerner Play Environment Access

Where is the local install directory for Discern Visual Developer commonly located in KWPLAY?

• C:\Program Files\Cerner

• C:\DiscernVisualDeveloper

• C:\Program Files (x86)\Cerner

• • C:\Users\\Cerner

What is the purpose of using an asterisk (*) in the SELECT statement?

• To delete all columns from the table

• To update specific columns in the table

• To bring back all columns from the table

• • To select only the first column from the table

What is the maximum number of rows you will get when you run this query:

SELECT *

FROM PERSON

WITH MAXREC = 50, TIME = 30, NOCOUNTER, SEPARATOR=" ", FORMAT

• 50 rows

• 100 rows

• 200 rows

• • All rows in the table

• 30 rows

What is the function of the Query Builder?

• To delete queries

• To run queries

• To create and modify queries

• • To export queries

What is the purpose of using an alias for a table when creating a query in a database?

• To limit the amount of data returned

• To define an abbreviation for the table, making it easier to reference fields from that table

• To select all fields from the table into the query

• • To execute the query faster