CIW Lesson 6: (M) Databases and Web Search Engines

Front

Which term is used to describe the component that relates multiple tables of information in a relational database? Options: Primary Key, Common Field, Foreign Key

Back

Common Field

Front

What is the term for a database that contains multiple tables related through common fields?

Back

Relational database

Front

A one-to-many database table relationship can best be described as a table relationship in which:

Back

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.

Front

In a relational database, what distinguishes a primary key from other database components?

Back

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

Front

A many-to-many database table relationship can best be described as a table relationship in which:

Back

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

Front

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

Back

A many-to-many relationship

Front

What is the standard language for accessing information from a relational database?

Back

SQL

Front

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?

Back

Database management systems (DBMSs)

Front

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

Back

Keywords

Front

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

Back

A keyword