Value Objects

MVC

Data Access Object

Business Delegate

GET is the method commonly used to request a resource from the server

POST is the method commonly used to request a resource from the server.

GET is the method commonly used for passing user input to the server

POST is the method commonly used for passing user input to the server

boolean

int

String

char

will cause a compiler error as the range of character is between 0 and 2^16 - 1. Will request for an explicit cast.

will not cause a compiler error and c will have the value -1;

c will not represent any ASCII character.

c will still be a Unicode character.

are public

are serializable

are immutatable

extend java.lang.Number

cronallow.ksh and crondeny.ksh

cronallow.sh and crondeny.sh

cron_allow AND cron_deny

cron.allow AND cron.deny

SELECT col1 INTO :hv from table1

EXECUTE IMMEDIATE SELECT col1 INTO :hv FROM table1

DECLARE c1 CURSOR FOR s1

IMMEDIATE SELECT col1 INTO :hv FROM table1

A TextArea can handle multiple lines of text

A textarea can be used for output

TextArea is not a class

TextAreas are used for displaying graphics

two

three

four

five

Omitting the ORDER BY clause when you create tables and views improve the query performance.

using joins instead of subqueries improve the query performance.

A good practice to improve query performance is using WHERE expressions to limit the size of result tables created with joins.

Must use the ORDER BY clause when you create tables and views.

True

False

call symput(daily_fee, put(fee/days, dollar8.);

%let daily_fee=put(fee/days, dollar8.)

select fee/days format=dollar8. into :daily_fee from sasuser.a

select fee/days format=dollar8. into daily_fee from sasuser.all;

FMTSEARCH

FMTERR

CATALOG

FMTLIB

MODIFY creates a second copy of the data while variables in the data are being matched with a WHERE clause and then deletes the second copy.

You cannot modify the descriptor portion of the data set using the MODIFY statement

You can use the MODIFY statement to change the name of a variable.

If the system terminates abnormally while a DATA step that is using the WHERE statement is processing, SAS automatically saves a copy of the unaltered data set.

SELECT

FROM

WHERE

both a and c

000 Senior

70 Adult

70 Senior

070 Senior

6.1

Fair

Good

. (Missing)

Year, Jan, Feb, Mar, Apr

Year, 2000, 2001, 2002

NAME, Col1, Col2, Col3

NAME, Jan, Feb, Mar, Apr

JDBC is an API to connect to relational-, object- and XML data sources

JDBC stands for Java DataBase Connectivity

JDBC is an API to access relational databases, spreadsheets and flat files

JDBC is an API to bridge the object-relational mismatch between OO programs and relational

java.jdbc and javax.jdbc

java.jdbc and java.jdbc.sql

java.sql and javax.sql

java.rdb and javax.rdb