NEW
Font size
WorksheetsIBA - Lesson 6.1
Total questions: 20
Worksheet time: 10mins
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 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.
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
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.
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
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 (URL)
A dotted-quad Internet address
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.
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.
Why might you receive different results using the same keywords on different search engines?
Because not every search engine recognizes the same keywords
Because different search engines interpret keywords differently
Because not every Website is registered with every search engine
Because search engines can only show Websites that were found by their robot or spider programs.
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-one relationship
A many-to-many relationship
How do robot or spider programs usually find keywords for a Webpage?
By reading each site's source code embedded in the <meta> tags
By reading every word contained on each Website
By reading the banner ads on each Website
By reading the title of each Website
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
What is the standard language for accessing information from a relational database?
XML
PHP
ODBC
SQL
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
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 referenced Websites
An index or database of all computers connected to the Internet
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 can be found only in a junction table.
The primary key is always the first field in a database table.
The primary key uniquely identifies each record in a database table.
What is the term for a database that contains multiple tables related through common fields?
Relational database
Non-relational database
Common database
Joined database
A relational 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 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.
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
