Lesson 6 - Databases and Web Search Engines

Structured Query Language (SQL)

A language used to create and maintain professional, high-performance corporate databases.

search engine

A powerful software program that searches Internet databases for user-specified information.

Common Gateway Interface (CGI)

A program that processes data submitted by the user. Allows a Web server to pass control to a software application, based on user request. The application receives and organizes data, then returns it in a consistent format.

database management system (DBMS)

A program used to store, access and manipulate database information.

query

A question posed by a user to a database to request database information. The database returns the query results based on the criteria supplied by the user in the query.

In databases, what is a one-to-many relationship?

A 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

meta search engine

A search engine that scans Web pages for <meta> tag information.

Boolean operator

A symbol or word used in Internet searches to narrow search results by including or excluding certain words or phrases from the search criteria.

keyword

A word that appears on a Web page and is used by search engines to identify relevant URLs. Some words, such as "the" or "and," are too common to be used as keywords.

Which of the following search engines uses your social network (Facebook and Twitter) to find more relevant information for your query?

Bing

Which of the following are typically an example of secondary resources?

Biographies

What will Internet search results contain when you use the AND Boolean operator in a two-keyword search string?

Both keywords

How can database information be provided to users via the Web?

By connecting a Web server to a database server

How is a many-to-many relationship between two database tables established?

By creating two one-to-many relationships with a junction table

How is a table relationship established?

By matching data in key fields between two database tables

What is the best way to find the exact information you need from the vast amount of data on the Internet?

By using Web search engines and search techniques

What is the term for a database that contains multiple tables of information that can be joined through common fields?

Relational database

When using multiple Boolean operators to conduct an Internet search, how can you indicate the order in which the Boolean phrases should be considered?

Use parentheses to combine Boolean phrases.

An information portal is a search engine that will only find:

Web sites that have been registered with search engines.

In which instance would using an advanced Web search technique be most appropriate?

When conducting an Internet search for a complex subject, or to narrow the results of a standard search

You should create a relational database in order to:

eliminate data duplication.

The catalog that is queried when you conduct a Web search using a search engine is called a:

search index.

Why would you use quotation marks in a search string when conducting an Internet search?

To narrow your search to yield Web pages that contain only the keywords as they appear together in the specified order

index

A catalog of the contents of a database. Each entry identifies a unique database record.

field

A category of information in a database table.

table

A collection of data about a limited topic, organized into rows and columns in a database.

database

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

record

A collection of information in a database table consisting of one or more related fields about a specific entity, such as a person, product or event.

relationship

A connection between two or more database tables that is based on a field that the tables have in common.

junction table

A database table containing foreign-key fields that refer to the primary-key fields from the primary tables in a many-to-many relationship.

relational database

A database that contains multiple tables related through common fields.

common field

A field contained in two or more database tables that forms a connection between the tables.

primary key

A field containing a value that uniquely identifies each record in a database table.

foreign key

A field in a related database table that refers to the primary key in the primary table.

Which type of online resource accepts input only from scholars and recognized authorities?

Authoritative peer-reviewed

Which of the following is used to process data submitted by a user by passing data back and forth between a server and an application program?

Common Gateway Interface (CGI)

Which of the following should IT professionals use to store, access and manipulate corporate database information?

Database management system (DBMS)

In which type of Web search does the search engine display a list of categories and subcategories that you can browse?

Directory search

In addition to allowing keyword searches, which of the following search engines also allows conceptual searches?

Excite

What is the term for a field in a related database table that refers to the primary key in the primary table?

Foreign key

one-to-many relationship

In databases, a 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.

one-to-one relationship

In databases, a relationship in which each record in Table A can have only one matching record in Table B, and vice versa.

many-to-many relationship

In databases, a relationship in which one record in Table A can relate to many matching records in Table B, and vice versa.

Which of the following would a search engine use to reference a Web site?

Keyword

What is the term for a collection of information consisting of one or more related fields about a specific entity, such as a person, product or event?

Record

When specifying keywords to conduct an Internet search, which of the following parts of speech will be the most useful?

Nouns

What will Internet search results contain when you use the OR Boolean operator in a two-keyword search string?

One keyword or the other or both

Which type of database table relationship is the most common?

One-to-many relationship

Which of the following enables an operating system to access databases from various vendors?

Open Database Connectivity (ODBC)

Which of the following are typically an example of primary resources?

Physical objects and relics

What is the term for a field containing a value that uniquely identifies each record in a database table?

Primary key

Which language should you use to create and maintain large relational databases?

Structured Query Language (SQL)

What is the purpose of using Internet research tools such as Zotero?

They enable you to organize the information you find and store it on your local hard drive.

Which of the following open information sources are students sometimes told to avoid retrieving information from because it is considered non-authoritative or unverified?

Wikipedia

Error pages most commonly occur when you:

click a dead link.

Unexpected Web pages and advertisements most commonly occur when you:

click a link for a site that was added to a search engine's database by its spider program.