2.2.3

Question 1

text file

Answer 1

a set of character values which are in a document line by line

Question 2

how to add writing to a file?

Answer 2

.write()

Question 3

how to close a file?

Answer 3

.close()

Question 4

how to read everything on a file?

Answer 4

.read()

Question 5

how to print one line at a time from a file?

Answer 5

.readline()

Question 6

what are the different file modes?

Answer 6

-‘r’ (read only)
-‘w’ (write mode, all the current data is discarded)
-‘a’ (append mode, adds to the existing file)

Question 7

what does SQL stand for?

Answer 7

Structured
Query
Language

Question 8

what is SQL?

Answer 8

a language used to retrieve data from a database

Question 9

describe SQL

Answer 9

it’s persistent, related and organised

Question 10

record

Answer 10

all of the data about one item in a database

Question 11

field

Answer 11

a characteristic of something stored in a database

Question 12

how do you work SQL?

Answer 12

SELECT <fieldname>
FROM <tablename>
WHERE <condition></condition></tablename></fieldname>

Question 13

what does * do in SQL?

Answer 13

all fields should be included

Question 14

what does J% do in SQL?

Answer 14

all conditions beginning with J

Question 15

what are the advantages of a subroutine?

Answer 15

-more efficient program
-improved reliability
-saves total programming time