CGS2100 EXAM 2 STUDY GUIDE Chapter 7 Questions 1 Database technology has given us convenience in gathering data however at the same time many times it takes away 2 A report generally uses all the field that are in the database 3 When a person uses language such as ordinary English to query a database it is known as a n language query 4 Data records with errors for example spelling errors or incorrect values are called 5 Navigation by browsing through the records in a database is the most efficient way a Privacy a False a Natural a Dirty Data to search for information a False 6 All of the following are true statements regarding data warehouses EXCEPT a Data warehouses are an obsolete concept 7 A key field must a Uniquely identify a record 8 For a customer database a god choice of key field would be a Customer ID 9 All of the following are true statements about databases EXCPET a Information from the database cannot be printed One popular open source database in MySQL Producing paychecks twice a month is an example of processing Oracle offers support for multidimensional database products The following is an example of Select Student ID From Students Where Credits 46 14 In a database a field shows results of calculations performed on data in 10 11 12 13 a True a Batch a True a SQL other numeric fields a Computed processing 15 When checking your bank account balance through the Internet you use a Batch a 12 a Google a Text a False 16 A database the stores data in cubes rather than tables is known as a n a Interactive database a Multidimensional 17 processing is used when a college accumulates course registrations and processes them at the same time in one large set 18 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 19 The search engine is the most visited site on the planet 20 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 21 In a customer database a customer s surname would be keyed into a n field 22 Using SQL requires the user to learn a new language each time they work with new hardware and software systems 23 A relational database table is composed of and each of those is composed of fields a Records In a client server environment the server a Processes a query from a client and then sends the answer back to the client The kind of information a field can hold is determined by a The field s data type A relational database requires one or more a Tables a File cabinet A computerized is a good comparison to a database Databases make it simple to store small quantities of information but are not suited for large quantities of information a False In 2004 Google a Offered shares of stock to the public In 2005 Google agreed to allow the government to censor certain searches made by their citizens a Chinese 31 All of the following are advantages of SQL EXCEPT 24 25 26 27 28 29 30 a The power and features are exactly the same as Haskell C and Java 32 When looking for a specific customer in a large credit card database is more efficient than browsing a Querying 33 A contextual search tool might ask Did you mean Newark Delaware or Newark NJ if you query the word Newark a True 34 Google is a play on the term googol which means a 1 followed by 100 zeroes 35 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 One example of a GIS is 36 37 a MapQuest a Numeric a Sorting The number of newspapers sold on May 30 would be kept in a field 38 Arranging all customer records in customer number order is an example of 39 Google s original algorithm was written to improve the way search engines looked for Web pages by a Counting the number of times other related Web pages linked to it Chapter 8 Questions 1 XML is used to write small programs called applets 2 Which of the following domains is restricted 3 Browsers can be enhanced with software extensions called plug ins 4 The protocol used to transfer Web pages is 5 Which department of the U S government developed the initial stages of the a False a edu a True a http Internet a Department of Defense 6 The gov domain is used by a The United States Senate 7 In what decade was ARPANET developed a 1960 s 8 Downloadable software extensions that add new features to a browser are known as 9 When radio or TV broadcasts are streaming at the same time they are happening it 10 Which of the following is a popular scripting language for programming Web 11 After an HTML document is completed it needs to be uploaded onto a server before it s visible on the Web The World Wide Web was introduced in URLs uniquely identify In the email address bowles sou edu bowles is the is an XML based family of formats used to publish information about frequently updated documents including blogs Which of the following is a legal IP address The protocol is designed solely to allow files to be transferred from a Bill Gates was the original developer of the World Wide Web The following are all examples of broadband access EXCEPT The latest version of the Internet Protocol is IPv9 RSS reading applications which periodically visit Web sites examine the feeds and display new content are known as a Aggregators Which of the following statements about Web page authoring is FALSE a Programs such as Microsoft Word cannot be used to author Web pages ARPANET was funded by a The US Government The digital divide separates people in the world with access to technology and digital information from those who do not a Plug ins is called a Real time servers a PHP a Wed a 1991 a A wed page a Username a RSS a 144 12 18 8 server to a client a FTP a False a Dial up a False 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 32 33 34 35 36 37 38 39 40 a True The Internet is controlled by a No one in particular To register a business name and create a unique URL a business pays a fee that goes to a A domain name registry company The top level domains for countries consist of two letters Net neutrality is the principle that Internet access should be free from restrictions related to the type of communication taking place on it One example of a scripting language is PHP The first part of a URL refers to the that must …
View Full Document
Unlocking...