Tables
How is a table relationship established?
By matching data in key fields between two database tables
Which of the following search engines uses your social network (Facebook and Twitter) to find more relevant information for your query?
Bing
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
What will internet search results contain when you use the AND Boolean operator in a two-keyword search string?
Both keywords
When specifying keywords to conduct an Internet search, which of the following parts of speech will be the most useful?
Nouns
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
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-many relationship
An information portal is a search engine that will only find:
Websites that have been registered with search engines
What is the term for a field containing a value that uniquely identifies each record in a database table?
Primary key
Why would you use quotation marks in a search string when conducting an Internet search?
To narrow your search to yield Webpages that contain only the keywords as they appear together in the specified order
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
Which of the following would a search engine use to reference a Website?
Keyword
In databases, a relationship in which each record in Table A can have only one matching record in Table B, and vice versa.
one-to-one relationship
What is a search index?
A catalog consisting of many webpage references
What is the reason for creating a relational database?
To store, categorize and analyze a complex set of information
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 of the following enables an operating system to access databases systems from various vendors?
Open Database Connectivity (ODBC)
Which of the following are typically an example of secondary resources?
Biographies
Which type of database table relationship is the most common?
One-to-many relationship
In which type of Web search does the search engine display a list of categories and subcategories that you can browse?
Directory search
What is the term for a field in a related database that refers to the primary key in the primary table?
Foreign key
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
Which language should you use to create and maintain large relational databases?
Structured Query Language (SQL)
Which of the following are typically an example of primary resources?
Physical objects and relics
How is a many-to-many relationship between two database tables established?
By creating two one-to-many relationships with a junction table
When browsing websites, error pages most commonly occur when you:
Click a dead link
What is the term for a database that contains multiple tables of information that can be joined through common fields?
Relational database
Which of the following should IT professionals use to store, access and manipulate corporate database information?
Database management system (DBMS)
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 type of online resource accepts input only from scholars and recognized authorities?
Authoritative peer-reviewed