CCL Coding Standards

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?

• Name=CONCAT(

  P.NAME_FIRST,

  " ",

  P.NAME_LAST )

• Name=concat(

  trim(P.NAME_FIRST),

  " ",

  TRIM(P.NAME_LAST) )

• Name = P.NAME_FIRST + P.NAME_LAST

• BUILD(

  P.NAME_FIRST,

  " ",

  P.NAME_LAST )