CIW: Lesson 6

A database can best be described as: a collection of data about a limited topic, displayed in rows and columns. a category of information in a table. a collection of data that can be sorted and searched using search algorithms. a collection of information consisting of one or more related fields about a specific entity.

A collection of data that can be sorted and searched using search algorithms.

Which of the following would you enter in a search engine to locate Webpages containing information about a topic? A file name A keyword A Uniform Resource Locator A dotted-quad Internet address

A keyword

In which database table relationship type is a junction table a necessary component? A one-to-one relationship A one-to-many relationship A many-to-many relationship A many-to-one relationship

A many-to-many relationship

Which term is used to describe the component that relates multiple tables of information in a relational database? Primary key Common field Foreign key Junction table

Common field

When you search for topics using a Web search engine, what are you searching? All websites on the World Wide Web All computers connected to the Internet An index or database of all computers connected to the Internet An index or database referenced websites

An index or database referenced websites

What distinguishes an information portal from a search engine? An information portal allows only keyword index searches. An information portal allows only static index/site map searches. An information portal will only index Websites based on manual submissions. An information portal uses a robot or spider program to browse the Web and index the content that it finds.

An information portal will only index Websites based on manual submissions.

It is vital that you understand how to evaluate information you retrieve from resources on the Internet because the source of information can directly affect the quality and authenticity of the information. Which of the following types of resources only accept input from scholars and recognized authorities? Authoritative peer-reviewed Open peer-reviewed Individual Primary

Authoritative peer-reviewed

What kind of software do vendors such as IBM, Computer Associates, Oracle, Microsoft, Sybase and MySQL provide mainly to IT professionals so they can store, access and manipulate corporate database information? Database management systems (DBMSs) Open Database Connectivity (ODBC) standards Common Gateway Interface (CGI) applications Structured Query Language (SQL) programs

Open Database Connectivity (ODBC) standards

The <meta> tag can be used in Webpages for which purpose? Providing search engines with a description of the Website Preventing early-version browsers from viewing the Website Containing the content that appears on each Webpage Linking the Website to other related Webpages

Providing search engines with a description of the Website

Which operator would you use in a Web search to find a multi-word phrase with the words in a specified order? Ampersand & Brackets [ ] Quotation marks " " Parentheses ( )

Quotation marks " "

What is the term for a database that contains multiple tables related through common fields? Relational database Non-relational database Common database Joined database

Relational database

How do robot or spider programs usually find keywords for a Webpage? By reading the banner ads on each Website By reading every word contained on each Website By reading each site's source code embedded in the <meta> tags By reading the title of each Website

By reading each site's source code embedded in the <meta> tags

What is the standard language for accessing information from a relational database? XML PHP ODBC SQL

SQL

It is vital that you understand how to evaluate information you retrieve from resources on the Internet because the source of information can directly affect the quality and authenticity of the information. Which of the following resource types bases information on primary sources? Scholarly Popular Individual Open peer-reviewed

Scholarly

It is vital that you understand how to evaluate information you retrieve from resources on the Internet because the source of information can directly affect the quality and authenticity of the information. Which of the following resource categories is the most common type of Internet resource you will use? Secondary Primary Open peer-reviewed Authoritative peer-reviewed

Secondary

Which statement is true regarding the use of Internet searches for job-related research? The Internet provides fast, convenient access to a vast amount of information and services. The Internet should be used as a secondary resource to information found in scholarly journals. The Internet is unreliable because too much false information is generated via popular search engines. The Internet provides fast, convenient access to social networking, but should not be used as a research tool.

The Internet provides fast, convenient access to a vast amount of information and services.

Search engines use a ranking system to help you determine how closely a site matches the topic for which you are searching. Generally, how does this ranking system work? The more keywords you specify in your search criteria, the higher the relevancy scores assigned to the retrieved documents. The more hyperlinks included in a Web document, the higher the relevancy score that document receives. The more reference sources included in a Web document, the higher the relevancy score that document receives. The more frequently your specified keywords are found in a particular document, the higher the relevancy score that document receives.

The more frequently your specified keywords are found in a particular document, the higher the relevancy score that document receives.

In a relational database, what distinguishes a primary key from other database components? The primary key can contain duplicate data in the field. The primary key uniquely identifies each record in a database table. The primary key is always the first field in a database table. The primary key can be found only in a junction table.

The primary key uniquely identifies each record in a database table.

What is the purpose of a Boolean operator? To assign a relevancy ranking to search engine findings To narrow search results by including or excluding words or phrases To determine the alphabetical order of search engine findings To perform a static search or a keyword search

To narrow search results by including or excluding words or phrases

You are performing a keyword search with your browser. Which strategy should you use for the keywords you choose? Use mostly verbs rather than nouns. Use as few keywords as possible. Use mostly nouns rather than verbs. Include at least one preposition such as "the" or "an".

Use mostly nouns rather than verbs.

A database field can best be described as: a category of information in a table. a collection of data about a limited topic, organized into rows and columns. a collection of data that can be sorted and searched using search algorithms. a collection of information consisting of one or more related pieces of information.

a category of information in a table.

A database record can best be described as: a collection of data about a limited topic, organized into rows and columns. a collection of data that can be sorted and searched using search algorithms. a category of information in a table. a collection of information consisting of one or more related fields about a specific entity

a collection of information consisting of one or more related fields about a specific entity.

A one-to-many database table relationship can best be described as a table relationship in which: a record in Table A can have multiple matching records in Table B, but a record in Table B has only one matching record in Table A. each record in Table A can have only one matching record in Table B, and vice versa. one record in Table A can relate to many matching records in Table B, and vice versa. no record in Table A has any matching records in Table B.

a record in Table A can have multiple matching records in Table B, but a record in Table B has only one matching record in Table A.

After you have found the information you need on the Web, you must still evaluate its accuracy and value. To determine whether information is reliable or factual, you should consult: authoritative peer-reviewed resources. open peer-reviewed resources. secondary resources. popular resources.

authoritative peer-reviewed resources.

During a Web search, entering erroneous search criteria, clicking dead links or accessing a busy server is likely to: return less relevant results for your keywords. activate the robot or spider program. use all the space in your browser cache. cause an error page to display.

cause an error page to display.

A one-to-one database table relationship can best be described as a table relationship in which: no record in Table A has any matching records in Table B. one record in Table A can relate to many matching records in Table B, and vice versa. each record in Table A can have only one matching record in Table B, and vice versa. a record in Table A can have multiple matching records in Table B, but a record in Table B has only one matching record in Table A.

each record in Table A can have only one matching record in Table B, and vice versa.

Patrick wants to search for Fender guitars other than Stratocasters. He plans to use a keyword search engine. He does not want to see any results for Stratocaster guitars, only other Fender models. Which of the following search strings should he use? guitar Fender |Stratocaster guitar Fender !Stratocaster guitar Fender <Stratocaster> guitar Fender *Stratocaster

guitar Fender !Stratocaster

Using the Boolean OR operator with keywords in a search means that the search results: may include a particular keyword. must include a particular keyword. must include at least one of the keywords. may include at least one of the keywords.

must include a particular keyword.

A many-to-many database table relationship can best be described as a table relationship in which: no record in Table A has any matching records in Table B. each record in Table A can have only one matching record in Table B, and vice versa. one record in Table A can relate to many matching records in Table B, and vice versa. a record in Table A can have multiple matching records in Table B, but a record in Table B has only one matching record in Table A.

one record in Table A can relate to many matching records in Table B, and vice versa.

Which of the following search engines uses cross-referencing fields for conceptual searches, in addition to allowing keywords searches? Google Yahoo! WebCrawler Excite

Excite

What is the purpose of the Boolean operator AND? It requires the search results to exclude one keyword. It requires the search results to include multiple keywords. It requires the search results to include one keyword and one URL. It requires the search results to include one keyword and exclude another.

It requires the search results to include multiple keywords.

What is the purpose of the Boolean operator OR? It requires the search results to include multiple keywords. It requires the search results to include one keyword or one URL. It requires the search results to include one keyword and exclude another. It requires the search results to include one keyword or the other or both.

It requires the search results to include one keyword or the other or both.

You access a search engine and enter the words "African" and "safari" in the search box. The search engine returns a list of Websites that include these words. Which type of search index did you use? Static index/site map Keyword index Full-text index Structured directory index

Keyword index

A search engine database contains titles, URLs and short descriptions for registered Webpages. What else would the database most likely contain? Robots Spiders Keywords Scripts

Keywords

Why might you receive different results using the same keywords on different search engines? Because search engines can only show Websites that were found by their robot or spider programs. Because different search engines interpret keywords differently Because not every Website is registered with every search engine Because not every search engine recognizes the same keywords

Because not every Website is registered with every search engine

You are an avid user of Facebook and Twitter. Which of the following search engines accommodates social networking to find more relevant information for your queries? Excite Bing Google Yahoo!

Bing

Which type of search index enables users to manually search information portals to locate indexed information? Keyword index Full-text index Boolean index Static index/site map

Static index/site map

Which is the most important reason you should properly cite information that you obtain from an Internet search? To avoid plagiarizing someone else's work To avoid contacting the original author To avoid crediting the creators of the sites you use To avoid using someone else's work for your own site or publication

To avoid plagiarizing someone else's work