An Old Inf Final - Study

Front 1

What plan to build a database is it best to use?

Back 1

A. determine the output, next design the tables

Front 2

Public Company Accounting Reform and Investor Protection Act is also called:

Back 2

B. Sarbanes Oxley Act

Front 3

Which does Not describe the term data redundancy?
a. the same data exists in two tables
b. the data is always in linked tables
c. It requires updating in two locations
d. Output could be incorrect if the first and second location of same data is not updated.

Back 3

B. the data is always in linked tables

Front 4

A unique field (or combination of fields) that identifies each record in a table is called a ...

Back 4

B. Primary Key

Front 5

Which of the following is used to create a relationship between two tables?
a. primary key
b. auto-number field
c. identification number
d. foreign key

Back 5

D. foreign key

Front 6

What does the term cascading mean?

Back 6

B. Changes in the data travel from one table to another

Front 7

What is an example of an expression using a wildcard?

Back 7

C. *west

Front 8

Which is an example of an expression that will return records that are from either of two states?
a. New York or California
b. New York and California
c. New York NOT California
d. Is not null

Back 8

A. New York OR California

Front 9

Which would be used to return a field display result of missing or no video?
a. Not =01/01/2005=
b. Is Null
c. Is not Null
d. -

Back 9

A. Not =01/01/2005=

Front 10

True or False
If a database design has a flaw, the results produced will not be flawed.

Back 10

B. False

Front 11

True or False
Data redundancy refers to having repeated data in different tables.

Back 11

A. True

Front 12

True or False
Properties are set to a default value depending on the data type cannot be changed.

Back 12

B. False

Front 13

True or False
To append means to add record to an excising table

Back 13

A. True

Front 14

What is the best definition of a cookie?

Back 14

A. It is a file written to your hard disk by a Website.

Front 15

What is the study of converting information into encoded or scrambled formulas called?

Back 15

A. Cryptography

Front 16

Firewalls are used to:

Back 16

D. restrict access to the company network from the outside

Front 17

a category of information stored in a column of a database is called a ...

Back 17

B. field

Front 18

In a database, ___________ fields store numbers used to perform calculations.

Back 18

B. numeric

Front 19

In relational databases, tables are linked to each other through a ...

Back 19

D. common field

Front 20

Select queries and join queries both use ___________ algebra to extract data.

Back 20

B. relational

Front 21

If a college keeps two lists, one for registration and one for room assignments, both containing name and address information, this is an example of data:

Back 21

D. Redundancy

Front 22

The language that the CPU understands, consiting of a sequence of bits, is called:

Back 22

D. machine language

Front 23

Tags such as <i>italics</i> are examples of which of the following?
a. HTML/XHTML
b. Java
c. C++
d. BASIC

Back 23

A. HTML/XHTML

Front 24

The two main types of control structures are the binary decision and the _______.

Back 24

C. loop

Front 25

True or False
HTML is NOT a programming language

Back 25

A. True

Front 26

BASIC, FORTRAN, COBOL, C+++ and Java are all ________ languages

Back 26

D. 3GL

Front 27

Translating an algorithm into a programming language is called ...

Back 27

C. coding

Front 28

Structured Query Language (SQL) is an example of?

Back 28

B. fourth-generation language

Front 29

Flowcharts and data flow diagrams are used during which step in the SDLC?

Back 29

A. Design

Front 30

Which of the following is the programming language often used to build Window application:
a. C++
b. Visual Basics
c. Java
d. HTML

Back 30

B. Visual Basics

Front 31

What language is used for applications that need to collect information from networked computers?

Back 31

D. Java

Front 32

Which is NOT a reason to save the first and last name as separate fields?
a. You can sort on last name
b. The first name could be used in saturation of a letter
c. It uses fewer fields
d. You can use ONLY the first or last name with a saturation

Back 32

C. It uses fewer fields

Front 33

Which of the following is a special definition setting used on a field containing an employee's date of hire?
a. Data arithmetic
b. Constant
c. Date/Time field
d. Calculated field

Back 33

C. Date/Time field

Front 34

Access recognizes ____________ data types

Back 34

Ten

Front 35

Data that is organized and summarized in an easy to read view is known as a:

Back 35

B. Pivot Table

Front 36

Which statement is NOT true about Access sharing data with Excel?
a. Data can be moved easily between the two applications with cut and paste.
b. A wizard can help facilitate the sharing of data
c. Tables of data can be imported and exported
d. The Get External Data command is used to do the importing.

Back 36

A. Data can be moved easily between the two applications with cut and paste.

Front 37

Active commands are displayed in the _________ bar

Back 37

D. Status

Front 38

Which does NOT describe queries?
a. They perform calculations
b. They are run from a table Datasheet View
c. They display specific records from table(s)
d. They ask questions about data in a database and return answers in a specified order

Back 38

B. They are run from a table Datasheet View

Front 39

True or False
In Access 2007, backup files should be created through the Office button, in case the original database becomes ruined.

Back 39

A. True

Front 40

------------------------

Back 40

--------------------------

Front 41

All __________ in Excel begin with an equal (=) sign

Back 41

D. dates

Front 42

Assume you open your credit card bill and see several large unauthorized charges. Unfortunately, you may have been the victim of:

Back 42

A. Identity theft

Front 43

An internet ________ attack occurs when an Internet server is purposely overloaded so it, cannot process legitimate transmissions

Back 43

B. denial of service

Front 44

A destructive program that remains on a computer system until the occurrence of a special event or time is called a:

Back 44

B. Time bomb

Front 45

What is the best definition of a computer hacker?

Back 45

D. A hacker is a program who investigates a computer system to understand both its full capabilities and vulnerabilities

Front 46

Which of the following statements is FALSE?
a. Technology often moves faster than the ruler required to govern it.
b. The policy of "fair use" allows copyrighted music to be reproduced for a profit without the permission of the creator.
c. Intellectual property is protected through copyright laws.
d. Original music, writing and art are considered intellectual property.

Back 46

B. The policy of "fair use" allows copyrighted music to be reproduced for a profit without the permission of the creator.

Front 47

Which of the following is a database management system?
a. Microsoft Project
b. Microsoft Excel
c. SQL
d. Microsoft Access

Back 47

D. Microsoft Access

Front 48

An individual trained in the design and building of databases is called a database:

Back 48

B. administrator

Front 49

What does the acronym DBMS stand for?

Back 49

D. Database Management System

Front 50

In Access, the Simple Query Wizard uses ___________ to create a query

Back 50

D. SQL