2.2 Smart Revise Misconceptions

A collection of related data items for one entity is commonly referred to as a…

• field

• record

• database

• function

What is the purpose of the SELECT structure in SQL?

• To define the criteria of the records returned

• To define which tables will be used

• To enable field matches with wildcards

• To define which fields will be returned

What is the purpose of the FROM structure in SQL?

• To define which fields will be returned

• To define the criteria of the records returned

• To define which tables will be used

• To enable field matches with wildcards

Assuming f is a pointer to an open file, what is the purpose of the following lines of pseudocode?

WHILE NOT f.endOfFile()

PRINT f.readLine()

END WHILE

• Read all the data from a file and output it to the screen

• Read a line from a text file and output it to the screen

• Validate input from the user before writing the data to the file

• Write an end of file marker to the file

What is the purpose of a procedure?

• To provide programmers with tools to assist in developing code

• To enable beginner programmers to write code more easily

• To return values from small functions

• To produce structured code

Which of these commands is the best example of a condition controlled loop?

• SELECT

• FOR

• WHILE

• IF

Consider this command: print(board[3,2]).

What is the number 3 in this command?

• An index

• The number of items in the array

• A list

• The data in the board array

What is meant by the programming construct, 'iteration'?

• Instructions execute one after another in order

• Repeating sections of code

• A section of a program that performs a specific task

• A program branch depending on a condition

What is the purpose of the pseudocode:

f.close()

• To close the file pointed to by f

• To detect the end of the file f

• To stop a loop reading from the file

• To close the program pointed to by f

In this line of code, identify a string:

score = score + int(input('Enter your score: '))

• score

• int

• input

• 'Enter your score: '