java.jdbc and javax.jdbc

java.jdbc and java.jdbc.sql

java.sql and javax.sql

java.rdb and javax.rdb

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

Year, Jan, Feb, Mar, Apr

Year, 2000, 2001, 2002

NAME, Col1, Col2, Col3

NAME, Jan, Feb, Mar, Apr

6.1

Fair

Good

. (Missing)

000 Senior

70 Adult

70 Senior

070 Senior

SELECT

FROM

WHERE

both a and c

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.

FMTSEARCH

FMTERR

CATALOG

FMTLIB

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;

True

False

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.

two

three

four

five

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

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

cronallow.ksh and crondeny.ksh

cronallow.sh and crondeny.sh

cron_allow AND cron_deny

cron.allow AND cron.deny

are public

are serializable

are immutatable

extend java.lang.Number

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.

boolean

int

String

char

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

Value Objects

MVC

Data Access Object

Business Delegate