question

8. View the ERD and select all the correct business rules: (Comes with Diagram of Book, Author, and Publisher)

answer

An author writes at least 1 book, A publisher may publish at least one book, A book may be published by more than one publisher

question

8. Referring to the SULFITE ERD, select the correct business rules: (Comes with diagram of Member, Committee, Event, and Report)

answer

A member can be assigned to any # of committees, An event can be participated in by only one member

question

8. Study the ERD and select all the correct choices: (Comes with the diagram of Country, Language, and Language Group)

answer

A country may have no official language at all, A language group must have atleast one language assigned to it, A language may be the official language of no country at all

question

8. The first step in drawing an ERD is to determine the Entities and to make a rectangle for each entity determined- True or False

answer

True

question

8. Relationships on ERDs are named as-

answer

Verbs or Verb Phrases

question

9. A spreadsheet would be a better choice than a database when-

answer

The primary objective is data analysis

question

9. The collection of commands that are used to create and manipulate data in a DBMS-

answer

Structure Query Language

question

9. The "CREATE TABLE table_name" command-

answer

Would be followed by a list of field names and the datatype for each

question

9. A foreign key field in a database table-

answer

Is used to "connect" or "relate" the table to another table in the database

question

9. Which is NOT an example of a RDBMS-

answer

SPSS

question

9. Another name for a row in a database table..-

answer

Record

question

9. In order to locate and retrieve data very, very rapidly, a DBMS uses-

answer

Index files

question

9. People or computer programs send ________ commands to the database server in order to create, retrieve, modify, or delete data-

answer

SQL

question

9. Records are added to database tables by-

answer

Insert Into Table commands

question

9. Referential Integrity is all about preserving-

answer

The validity of primary key to foreign key relationships

question

10. The key technology expert who has advanced skills in database systems-

answer

Database administrator

question

10. Which is must valuable and least expendable-

answer

Data

question

10. Which is NOT a component of a "data standard" definition-

answer

Specific instances of the item in the database (such as, Prius for a Car Model)

question

10. A data administration policy, like the one reviewed in class, would likely include all of the following EXCEPT for-

answer

A copy of all data to be managed

question

10. Which best describes the MINIMUM qualification for a database administrator-

answer

A college degree and demonstrated experience with database software

question

10. A data dictionary stores-

answer

Information describing data

question

10. A database administrator would have all the following duties/responsibilities except for-

answer

Training users and support staff in database methods

question

10. According to established data management principles and our sample data policy, which statement is true-

answer

Data is to be managed as a valuable organizational resource for the good of the entire enterprise

question

10. Which is not a standard management activity with regard to data administration-

answer

Creating ERDs and Schema for new databases

question

10. An external mandate defining rules on data retention-

answer

Sarbanes-Oxley

question

11. What is NOT a common layer-1 network media-

answer

Television

question

11. Which provides the greatest capacity for network traffic (bandwidth)-

answer

Fiber optic cable

question

11. Which is the standard for wired connections to LANs-

answer

Twisted-pair copper wire

question

11. The media layer provides service to-

answer

The data-link layer

question

11. Wifi provides 11 Mb/s or more bandwidth for-

answer

All users to share the access point collectively

question

11. Datalink technology that connects 2 remote (tens of miles apart) LANs-

answer

T-1

question

11. Ethernet comes in several flavors. Which is NOT a variant of Ethernet-

answer

OC-3

question

11. At the center of a 100/1000 Base_T LAN you will find a ___________connecting all of the nodes-

answer

Switch

question

11. Data-link technologies that are designed to work over Fiber-Optic cables (like OC-3) must produce-

answer

Light signals

question

11. Which technology NEVER has personal computers directly connected to it-

answer

T-1

question

12. A Tier_1 or Tier_2 ISP, such as the fiber optic cables provided by AT&T or Level 3, would be a ___________ layer 3 devices, such as are provided by Cisco and Juniper Networks

answer

provider/vendor to

question

12. Internet Protocol (IP, layer_3) handles all but which-

answer

Creating a serial bit-stream

question

12. Which network layer deals with the fact that packets arrive at the destination out-of-order:

answer

TCP

question

12. A device that receives packets from one network, then forwards the packet onto another network-

answer

Router

question

12. An automated service for assigning IP numbers to computers on a LAN-

answer

DHCP

question

12. Incoming data is "handed off" to an application (such as Cyberduck or WinSCP, or a web browser) based on a(n)-

answer

Port number

question

12. Breaking a data-stream into 1000-byte chunks is done by which-

answer

IP

question

12. Incoming packets-

answer

Must be rearranged into their original order

question

12. The process of translating Domain_Names into IP numbers is handled by-

answer

DNS

question

12. An example of valid version 4 IP number-

answer

205.45.201.48

question

13. The term used to describe the emerging "converged" network-

answer

Next Generation Network

question

13. Which term refers t the convergence of telephone and data-networks-

answer

VOIP

question

13. Which is NOT a reason the world is moving toward convergence-

answer

Ease of pricing products and services

question

13. Network controls that can assure proper data rates for VOIP and video streams-

answer

Quality of Service

question

13. This digitizes a human voice, putting the resulting bits into IP packets and sending them out onto the internet-

answer

IP Phone

question

13. A popular Internet service based on VOIP-

answer

Skype

question

13. Who (what type of organization) might resist the movement toward net-convergence-

answer

Traditional phone companies

question

13. In a converged network, ALL data (voice, video, music..) moves from sender to receiver-

answer

Over the Internet using TCPIP

question

13. Voice messages are stored as MP3 files in the e-mail-in-box. This statement best describes-

answer

Unified Messaging

question

13. In a converged, Next Generation Network, a videoconference appliance would insert________into a stream of IP packets-

answer

Digitized voice/video

question

14. A network engineer would be expected to do all the following except-

answer

Develop web applications in Coldfusion or PHP

question

14. Referring to network policy statements, "active equipment" could mean-

answer

Ethernet switches, Routers, Wireless access points

question

14. The network policy rule in the sample template requiring use of only network addresses issued by their department is referring to-

answer

IP Addresses

question

14. According to the sample Network Engineer Job description, the MOST important qualification for the job is-

answer

A good deal of experience in the field

question

14. "Remote Access" means-

answer

A dial-up connection

question

14. Having an agency computer connected to the agency network and connected externally via dial-up could introduce-

answer

A back-door security breach

question

14. Which is a standard that a non-agency computer being connected to the agency's network would be expected to comply with-

answer

Must have adequate password control and virus protection

question

14. Violation of network policy could result in-

answer

Termination or Loss of access privileges

question

14. Network policy should prohibit a user from installing which device on the agency network-

answer

Router

question

14. The individual who would be held accountable for setting and enforcing network policy within the agency-

answer

Information Resource Manager

question

15. An I.T. governance model where common services like networks and help-desks are centrally provided, while more departmentally specific services like application software development are the responsibility of the local department-

answer

Federal

question

15. The primary objective of developing an internal IT services business model is to-

answer

Assure equitable cost burden for I.T. across the organization

question

15. A common method for explicitly defining and managing expectations of I.T. service delivery-

answer

Service level agreements (SLA)

question

15. All are common services provided to the organization by the I.T. department except-

answer

Computer chip design and fabrication

question

15. The term used to describe the strategy of providing a high level of resources to user support, while asserting a high level of control over user's I.T. behavior-

answer

Controlled growth

question

15. Which would suffer most in a fully decentralized I.T service model-

answer

I.T. Standards and Interoperability

question

15. An I.T. business model wherein ALL services consumed by a department are accounted for and billed for-

answer

Full charge-back

question

15. In a service level agreement, the expectation is that the more the severe the problem, the __________the guaranteed response time-

answer

Quicker

question

15. A common, rule-of-thumb ratio to determine the number of I.T. support staff required by an organization-

answer

One I.T. support staff to every 100 PCs

question

15. A trouble ticket system can help-

answer

Track and report on I.T. problems, Enforce SLAs, Organize and manage I.T. support staff time and activity

V369: Quizzes 8-15 – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards