Quiz #2

This quiz has questions about Access and questions from the text.
If the statement is false, you must tell why or you must correct the statement:
Question #1: True or False (and why): In Access SQL the following SQL means that both the major has to be CI and the gpa has to be greater than 3 or that just the credits has to be greater than 30.

SELECT idno, stuname, major, gpa, credits
FROM stutable
WHERE major = "CI" and (gpa > 3 or credits > 30);

Question #2: True or False (and why): In Access SQL, the following SQL means that the major has to be CI and in addition either the gpa has to be greater than 3 or the credits must be greater than 30.

SELECT idno, stuname, major, gpa, credits
FROM stutable
WHERE major = "CI" and (gpa > 3 or credits > 30);

Question #3: What are the three major operations that computer hardware and software accomplish?

Question #4: After your write a computer program, a _____________ or _____________ is used to translate your program into machine language.

Question #5: What are the steps in the program development cycle?

Question #6: When you write a computer program and you make a mistake in the language, for example using RIGHT instead of WRITE, you have made a _______________ error.
Question #7: If you add the data in payPerHour to the data in HrsWorked instead of multiplying them together, that is called a ______________ error.

Question #8: Two tools discussed in the text that you can use to plan the logic for a program are _________________ and ____________________.

Question #9: A ______________ is the name for data stored in a named memory location.

Question #10: ans = ans + 1 is called an __________________ statement and the = is called an ________________ sign.