CGS TEST 2 STUDY GUIDE CHAPTER 7 1 Q Prior to Google early search engines ranked Web pages by A Counting the number of times the key word or phrase appeared on the page 2 Q In a customer database a customer s surname would be keyed into a n field A text 3 Q The act of obtaining data about an individual and then using that data to fraudulently obtain goods and services in that individual s name is called A identity theft 4 Q A report generally uses all the fields that are in the database 5 Q A relational database requires one or more 6 Q This search engine is the most visited on the planet 7 Q When looking for a specific customer in a large credit database is more efficient than 8 Q A relational database is composed of and each of those is composed of fields 9 Q Oracle offers support for multidimensional database products 10 Q All of the following are advantages of SQL EXCEPT A the power and features are exactly the same as Haskell C and Java 11 Q The following is an example of Select Student ID From Students Where Credits 46 12 Q When a person uses language such as ordinary English to query a database it is known as a n language query A natural 13 Q In 2004 Google A offered shares of stock to the public 14 Q Producing paychecks twice a month is an example of processing 15 Q Google s original algorithm was written to improve the way search engines looked for Web A False A tables A Google browsing A querying A records A True A SQL A batch pages by A counting the number of times other related Web pages linked to it 16 Q A key field must A uniquely identify a record 17 Q Navigation by browsing through the records in a database is the most efficient way to search 18 Q One example of a GIS is for information A False A MapQuest A dirty data A customer ID query the word Newark A True them the same time in one large set A Batch 19 Q Data records with errors for example spelling errors or incorrect values are called 20 Q For a customer database a good choice of key field would be 21 Q A contextual search tool might ask Did you mean Newark Delaware or Newark NJ if you 22 Q processing is used when a college accumulates course registrations and processes 23 Q When checking your bank account balance through the Internet you use processing A interactive A numeric and software systems A False fields A computed A file cabinet many times it takes away A privacy 24 Q The number of newspapers sold on May 30 would be kept in a field 25 Q Using SQL requires the user to learn a new language each time they work with new hardware 26 Q The kind of information a field can hold is determined by A the field s data type 27 Q In a database a field shows results of calculations performed on data in other numeric 28 Q A computerized is a good comparison to a database 29 Q Database technology has given us convenience in gathering data however at the same time 30 Q One popular open source database is MySQL A True 31 Q The Children s Online Privacy Protection Act requires Internet based businesses to obtain parental consent before collecting information from children years of age and younger 32 Q Databases make it simple to store small quantities of information but are not suited for A 12 large quantities of information A False 33 Q In a client server environment the server A processes a query from a client and then sends the answer back to the client 34 Q All of the following are true statements about databases EXCEPT A information from the database cannot be printed 35 Q A database that stores data in cubes rather than tables is known as a n database A multidimensional 36 Q In 2005 Google agreed to allow the government to censor searches made by their citizens A Chinese A sorting 37 Q Arranging all customer record in customer number order is an example of 38 Q Google is a play on the term googol which means A a 1 followed by 100 zeroes 39 Q All of the following are true regarding data warehouses EXCEPT A data warehouses are an obsolete concept 1 Q All of the following domains are open to anyone without restriction EXCEPT CHAPTER 8 A gov 2 Q URLs uniquely identify A a Web page documents including blogs A RSS 3 Q is an XML based family of formats used to publish info about frequently updated 4 Q The digital divide separates people in the world with access to technology and digital information from those who do not A True 5 Q Which department of the U S government developed the initial stages of the Internet A Department of Defense 6 Q Which of the following is a legal IP address A 144 12 18 8 7 Q XML is used to write small programs called applets A False 8 Q The World Wide Web was introduced in A 1991 A plug ins A http 9 Q Downloadable software extensions that add new features to a browser are known as 10 Q The protocol used to transfer Web pages is 11 Q To register a business name and create a unique URL a business pays a fee that goes to A a domain name registry company 12 Q Net neutrality is the principle that Internet access should be free from restrictions related to the type of communication taking place on it A True 15 Q The protocol is designed solely to allow files to be transferred from a server to a client 13 Q ARPANET was funded by A the U S government 14 Q The gov domain is used by A the United States 16 Q Which of the following domains is restricted 17 Q The latest version of the Internet Protocol is IPv9 A FTP A edu A False visible on the Web A Web example http A protocol A DNS A server A True A True 18 Q After an HTML document is completed it needs to be uploaded onto a server before it s 19 Q The first part of a URL refers to the that must be used to access information for 20 Q A server maintains look up tables that map domain names to IP addresses 21 Q A URL can specify the IP address of the Web that houses a Web page 22 Q In the e mail address bowles sou edu sou is the A DNS identifier for email addressed to an educational domain 23 Q Browsers can be enhanced with software extensions called plug ins 24 Q The top level domains for countries consist of two letters 25 Q One example of a scripting language is PHP 26 Q The World Wide Web is a distributed browsing and …
View Full Document
Unlocking...