WorksheetsCCL Coding Standards
Total questions: 11
Worksheet time: 8mins
What does the Selected Fields expression use to convert a code value into a textual value in the output display?
UAR_GET_CODE_DISPLAY
POSITION_CD
Code Value Displays dialog box
Query Builder
A field that indicates when an order was placed would most likely be named ORIG_ORDER________.
_DATE
_TIME
_TIMESTAMP
_ACTIVE
_DT_TM
A field that stores the unique primary identifier of the PERSON table is most likely named PERSON________.
_KEY
_ID
_ACTIVE
_IND
What is the default directory in Discern Explorer where all files are placed unless specified otherwise?
CCLUSERDIR
CCLEXPLORER
USERFILES
C:\
What keyboard shortcut can you use to execute a query after placing the focus of your cursor on the word SELECT from the query?
CTRL + Q
CTRL + S
ALT + Q
SHIFT + Q
How can you select all fields from a table into your query using the Query Builder?
By using the MAXREC control option
By clicking the 'Run Query' button
By clicking 'Select All Fields'
By typing CTRL + Q
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
Which statement is part of the basic SELECT statement?
JOIN
ORDER BY
GROUP BY
FROM
What is the maximum number of rows you will get when you run this query:
SELECT *
FROM PERSON P
WHERE P.PERSON_ID = 744115.00
WITH MAXREC = 50, TIME = 30, NOCOUNTER, SEPARATOR=" ", FORMAT
50 rows
0 rows
1 row
All rows in the table
744115 rows
You are writing a query that includes person information. You need to write an expression that will display the first name, a space, and then the last name. Which of the following will correctly format the name?
You would like to see Orders information listed in the output with the last orders registered in the system listed first. Which syntax will meet this requirement?
SELECT
E.ENCNTR_ID,
E.REG_DT_TM ";;q"
FROM ENCOUNTER E
WHERE E.ACTIVE_IND = 1
ORDER BY E.REG_DT_TM DESC
SELECT
O.ORDER_ID,
O.ORIG_DT_TM,
FROM ORDERS O
ORDER BY O.UPDT_DT_TM ASC
SELECT
O.ORDER_ID,
O.orig_order_dt_tm
FROM ORDERS O
ORDER BY O.updt_dt_tm DESC
SELECT
O.ORDER_ID,
O.orig_order_dt_tm
FROM ORDERS O
ORDER BY O.updt_dt_tm
