new quiz

1) rot13 is an example of
a) encryption
b) decryption
c) a & b
d) none of the above

2) In Excel, what would be the R1C1 reference for B2, if I were standing in A1?
relative: R[1]C[1]
absolute: r2c2
e.g. mixed column-absolute: r[1]c2

3) $a5 is an example of a:
a) R1C1 reference
b) absolute reference
c) relative reference
d) mixed reference

4) The following:
Function MySum(X, Y)
    MySum = X + Y
End Function

is an example of a:

a) Javascript program
b) UDF
c) Excel formula
d) server-side script

5) Why might I want to index a foreign key?
faster, will need it often, to match to primary key


6) Consider the following SQL query, where Customers has 10 records and Employees has 20 records.
select * from Customers, Employees

How many records would be returned?
200 records


7) A JPEG uses a form of compression which is _____________.
lossy

8) Which of the following would be matched by the wildcard B*B? (Circle all that are correct.)

a) BOB
b) BIB
c) BB
d) BABY

9) What is an example of an Object oriented language?
C++, Smalltalk, Java

past quizzes

1) The process by which several technologies with distinct functionalities evolve to form a single product is called:

a) the digital revolution

b) convergence

c) divergence

d) digitization

2) Source code (able to be read or written by a programmer) is converted into machine code by:

a) a compiler

b) an interpreter

c) a translator

d) A and B

3) Images can be digitized by treating them as a series of colored _________. pixels

4) A _________ is about one billion bytes. gigabyte

5) Which of the following is not actually part of the von Neumann architecture?

a) memory

b) arithmetic / logarithmic unit

c) control unit

d) input and output

6) A computer does not usually run out of RAM because it can use an area of the hard disk called ______ memory. virtual

7) Data on an optica storage medium, such as a DVD, is stored as pits and __________. lands

8) A device _________ is software usually run in the background without opening a window and is designed to help a peripheral device establish a connection with a computer. driver

9) A ___________ use-license is priced per copy and allows a specific number of copies to be used at the same time.

a) single

b) multiple

c) concurrent

d) sequential

10) An example of open source software is: winscp, openoffice

11) What is the purpose of an Fn key? Does your computer keyboard include an Fn key? Why or why not?

12) Using only pen and paper, convert the following into binary: 48

13) What would be the output of the following in codecademy? "Hello there".length

11

14) What is a trilobite?

extinct marine arthropod

15) Which of the following is a closing HTML tag?

a) <close>

b) </body>

c) <a href="hello.html">

d) {\b}

16) Grace Hopper is crediting with popularizing the term _____________: bug

1) A ________ program stored in ROM tells the hard disk to load the operating system into RAM:

a) kernel

b) bootstrap

c) terminate and stay resident

d) device driver

2) A ___________ boot computer could boot into Windows, and then reboot into Mac OS.

dual

3) Giving a **practical** example, how can a disk become fragmented?

4) What does Dropbox let you do?

5) The sounds you hear as two modems or fax machines connect are examples of a process called handshaking:

a) True

b) False

6) An encrypted message is called:

A) plaintext

B) cleartext

C) ciphertext

D) encryptex

7) Use ROT13 to encode the following message:

This message is in English.

8) In the URL:

http://en.wikipedia.org/wiki/Uniform_resource_locator

What is the domain?

en.wikipedia.org
or better,
wikipedia.org

9) If I am in cell G4 and refer to cell A1 using a relative reference, the R1C1 reference would be:

R[-3]C[6]

10) In the Javascript statement:

var x = 100;

what does var mean?


make me a variable

1) What is the difference between the Internet and the Web?
internet: connected machines. web: connected documents

2) .com, .net, and .gov are examples of _____ ______ domains.
top level

3) SETI@home is an example of ________ computing.
distributed

4) What is the purpose of SETI@home?
find aliens

5) What is FTP, and what is its purpose?

file transfer protocol, transferring files

6) Hackers can use automated software to look for computers with open _____ that are vulnerable to unauthorized access.
ports

7) Cookies were developed because HTTP is a stateless protocol. Explain.
stateless protocol means that no recollection of previous interaction. therefore, save state on user's machine.

8) Are most search engines case sensitive?
no

9) If I save a file as a monochrome bitmap, 100 across and 100 down, approximately what will be the file size?

=100 * 100 / 8

10) A raster image will be sharper than a vector image if we zoom in. True or false?

false.

11) Consider the following code from codecademy:

var i = 0;

while ( i < 2 ) {

  console.log( "i is now " + i );

  i++;

}

This is an example of a:

a) substring function

b) input statement

c) loop

d) comment

12) What is an example of netiquette?
DON'T WRITE IN ALL CAPS! IT LOOKS LIKE YOU ARE SHOUTING!

what langs are out there?

VBA in Office
open source, free languages
e.g. Python, Java
also are free IDEs

Visual Studio Express edition

one should primary key, other one not needed.
link on comparable fields
same data types
on primary key, no duplicates
data should be consistent when you make the link


SELECT LastName, FirstName, Max(Price) AS thePrice
FROM Author, Book where AuthorID = AuthorCode
GROUP BY LastName, FirstName;

parameters, calculated fields

Like "G*"

CS department website

www.cs.qc.cuny.edu/

80: visual basic
Visual Stuidio is an IDE
integrated development environment
IDE


111: c++
#include <iostream>
using namespace std;
int main()
{
int a, b;
cout << "Please enter two numbers separated by a space. " << endl;
cin >> a;
cin >> b;
int c;
c  = a + b;
cout << "Your sum was " << c << endl;
return 0;
}

SELECT
INSERT INTO Book (AuthorCode, Title, PubID)
VALUES (35, 'Hello There World', 'MH');
UPDATE
DELETE

Practice Access exam walkthroughs

quiz 3 next tues

from last end of chapter 8 in New Perspectives Book
probably: ch 6, 7, 8

Ada_Lovelace first computer programmer
for Babbage's analytic engine

Practice Access Exam 1.
Practice Access Exam 2.
Access Review Presentation.


Access practice exam files.