What does the base 2 number, 0100 1111, convert to in decimal?

What does the base 2 number, 0100 1111, convert to in decimal?

A. 128
B. 79
C. 91
D. 25


Answer: B

In an ERD, the lines represent __________.

In an ERD, the lines represent __________.

A. Entries
B. Relationships
C. Attributes
D. Cardinality


Answer: B

In an ERD, the boxes represent___________.

In an ERD, the boxes represent___________.

A. Cardinality
B. Attributes
C. Relationships
D. Entities


Answer: D

When a DBMS accounts for linked records when a parent record is deleted, what is this called?

When a DBMS accounts for linked records when a parent record is deleted, what is this called?

A. Referential integrity
B. DB Refinery
C. Cleanup routine
D. Disposal Protocol


Answer: A

In a flat file system, how many times must a single piece of data be added?

In a flat file system, how many times must a single piece of data be added?

A. once for every table
B. once
C. unknown


Answer: C

In a relational database, how many times must a single piece of data be added?

In a relational database, how many times must a single piece of data be added?

A. once for every table
B. unknown
C. Once


Answer: C

In the following SQL statement... SELECT lastname FROM employeetbl WHERE employeeID = 79 form where is the data being pulled?

In the following SQL statement... SELECT lastname FROM employeetbl WHERE employeeID = 79 form where is the data being pulled?

A. employeetbl
B. employeeID
C. all of the above
D. lastname


Answer: A

In the following SQL statement.... SELECT lastname FROM employeetbl WHERE employeeID = 79 what data will be displayed in the results?

In the following SQL statement.... SELECT lastname FROM employeetbl WHERE employeeID = 79 what data will be displayed in the results?

A. All of these options
B. employeeID
C. employeetbl
D. lastname


Answer: D

What must a DBMS have?

What must a DBMS have?

A. Word processor
B. None of these options
C. Web access
D. DB Engine


Answer: D

What are examples of DBMSs?

What are examples of DBMSs?

A. Oracle
B. Chrome
C. Windows 10
D. Excel


Answer: A

How does a database store data?

How does a database store data?

A. Relationships are initiated with foreign keys
B. In tables that consist of rows and columns
C. Each row in each table is unique by way of a primary key
D. All of these options


Answer: D

Who came up with the theory used to base relational databases?

Who came up with the theory used to base relational databases?

A. Steve Jobs
B. Edgar Codd
C. Bill Gates
D. Al Gore


Answer: B

In order to combat the problems associated with islands of information, what were organizations looking for?

In order to combat the problems associated with islands of information, what were organizations looking for?

A. Something Central
B. Something relational
C. All of these options
D. Communication technology


Answer: C

What are "islands of information?"

What are "islands of information?" 

A. Separate pool of redundant data spread throughout the organization
B. Centralized deposit of data
C. Any of these option
D. Non repeated data


Answer: A

Who had direct access to all of the data in organizations in the 1940s, 1950s and 1960s?

Who had direct access to all of the data in organizations in the 1940s, 1950s and 1960s?

A. Systems Analysts
B. Secretaries
C. Customers
D. Janitors


Answer: B

If you had a high end hard drive that held 4 Terabytes of information, how many filing cabinets would that require to store the equivalent number of textual characters?

If you had a high end hard drive that held 4 Terabytes of information, how many filing cabinets would that require to store the equivalent number of textual characters?

A. 1,000,000
B. 10
C. 20,800
D. 2,600


Answer: C

What is the analogue to the semiotic "data" level in how data is organized in computer files?

What is the analogue to the semiotic "data" level in how data is organized in computer files?

A. Files
B. Fields
C. Characters
D. Records


Answer: C

If it is generally understood among employees that you should arrive at work at 8am and leave whenever your work is complete, this is at what level of information?

If it is generally understood among employees that you should arrive at work at 8am and leave whenever your work is complete, this is at what level of information?

A. Data
B. Semantics
C. Syntax
D. Knowledge


Answer: D

If you see markings on a wall, at what level of information are you?

If you see markings on a wall, at what level of information are you?

A. Semantics
B. Syntax
C. Signs
D. Signals


Answer: C

How many bits are used for the color in a single pixel in most image files?

How many bits are used for the color in a single pixel in most image files?

A. 24
B. 3
C. about 16 million
D. 1


Answer: A