DB2 - 2

Question 1

What command is used to add more rows/records?

Add
Insert
Both
None of the above

Answer 1

Insert

Question 2

Db2 supports binary strings.

TRUE
FALSE

Answer 2

TRUE

Question 3

In order to connect tables, you utilize the following:

CONNECT
JOIN
BOTH
NONE

Answer 3

JOIN

Question 4

SELECT CustomerName FROM Customers Where Country=’USA’

is a valid formatted WHERE clause
is not valid because WHERE should be replaced with IF
is not because its a VSAM file
is not valid because SELECT should be replaced with FIND

Answer 4

is a valid formatted WHERE clause

Question 5

The datetime data types are:

DATE, TIME, and TIMESTAMP.
HOURS, MINUTES and SECONDS
EPOCH,DateTime,TODAY
Hours since January 1, 1970 = %ld\n”, seconds/3600

Answer 5

DATE, TIME, and TIMESTAMP.

Question 6

CREATE is not used to set up a table?

TRUE
FALSE

Answer 6

FALSE

Question 7

given: store_name VARCHAR(150) pick best answer:

  is a varying character column with a maximum length of 150 
  is a minimum instruction set for a VSAM file 
  is a flat file key set 
  is a binary object module length

Answer 7

is a varying character column with a maximum length of 150

Question 8

When did SQL start?

1960’s
1970’s
1980’s
1990’s

Answer 8

1970’s

Question 9

Do you need to create a table space before creating a table?

FALSE
TRUE

Answer 9

TRUE

Question 10

In order to query data, you use the SELECT statement.

TRUE
FALSE

Answer 10

TRUE