Fast guide to SQL on iSeries quiz

Is your SQL knowledge on iSeries lacking? Brush up on our fast guide to SQL on iSeries and follow it up with this quiz.

This Content Component encountered an error
First, read our fast guide to SQL on iSeries. Next, choose the best answer to each question. Then click the "Check Score" button at the bottom of the page to view your score. Incorrect responses will be displayed in red. You can research your answers to go back to the article being referenced. Good luck!

1: Jim Mason relays an anecdote that illustrates the speed of running SQL scripts on iSeries versus Windows. What does he discover?

a)That iSeries was faster than their Windows SQL server.
b)That iSeries was slower than their Windows SQL server.
c)That iSeries was about the same speed as Windows SQL server.
d)The comparisons were inconclusive.

Research your answer.

2: When using SQL Create Table, what happens to the date formatting when DB2 reads data from SQL, regardless of the DATFMT?

a)The date format follows the DATFMT specified in SQL.
b)DB2 will delete data where DATFMT has been specified in SQL.
c)The date formatting will be converted to the output date format specified by the application.
d)Nothing.

Research your answer.

3: According to Glen H. Bunnell, using QTEMP on V5R3 is a good way to ensure data integrity on the iSeries.

a)True.
b)False.

Research your answer.

4: According to John Blenkinsop, which of the following will result in bad numerical data?

a)A blank field over the top of a numeric field.
b)A failed record read where the record is defined in an uninitialized, externally-described data structure.
c)Invalid data from a passed parameter.
d)All of the above.

Research your answer.

5: There is no need to register an RPG program in order to call an RPGLE program from an SQL trigger.

a)True.
b)False.

Research your answer.

6: In Herb Bujak's command for using SQL to SELECT data directly into a CVS file, the incoming SQL statement is used to create a temporary VIEW in QTEMP. How is this achieved?

a)By prefixing the select statement with "create view qtemp/zffdtocsv as " and feeding the resulting statement to a SQL processing command.
b)By prefixing the select statement with "create view qtemp/zslttocsv as " and feeding the resulting statement to a SQL processing command.
c)By prefixing the select statement with "create view qtemp/zcpytocsv as " and feeding the resulting statement to a SQL processing command.
d)None of the above.

Research your answer.

7: For a quick way to evaluate information on iSeries in SQL, you need to start SQL Interactive Session.

a)True.
b)False.

Research your answer.

8: As a DBA, David Ford supports both server-side iSeries and client-side Java programmers. What does he have to say about naming tables when they are being defined in SQL?

a)Long descriptive names make the server-side programmers coding more difficult.
b)Long descriptive names make the client-side programmers coding more difficult.
c)Server-side and client-side programmers both prefer shorter table names.
d)Table names aren't important.

Research your answer.

9: Which of the following statements are true, according to Stored Procedures and Built-in Functions author Mike Faust, about SQL built-in functions?

a)Columnar functions provide a way to take volumes of data and summarize them into a form that is more easily analyzed.
b)Scalar functions allow us to extend existing values within a data set.
c)Both a and b are true.
d)Neither a nor b are true.

Research your answer.

According to SQL expert Rudy Limeback, which is faster, functions or procedures?

a)Functions.
b)Procedures.
c)They perform at equal speeds.
d)Too much depends on the context of what the user is trying to accomplish to say that one is faster than the other.

Research your answer.

This was first published in August 2007

Dig deeper on iSeries SQL commands and statements

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close