Study

CIW CH 6 Review

  •   0%
  •  0     0     0

  • 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
  • Which of the following should IT professionals use to store, access and manipulate corporate database information?
    Database management system (DBMS)
  • When browsing websites, error pages most commonly occur when you:
    Click a dead link
  • What is the reason for creating a relational database?
    To store, categorize and analyze a complex set of information
  • What is the term for a field in a related database that refers to the primary key in the primary table?
    Foreign key
  • Which of the following enables an operating system to access databases systems from various vendors?
    Open Database Connectivity (ODBC)
  • 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
  • How is a many-to-many relationship between two database tables established?
    By creating two one-to-many relationships with a junction table
  • What is the term for a field containing a value that uniquely identifies each record in a database table?
    Primary key
  • 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 open information sources are students sometimes told to avoid retrieving information from because it is considered non-authoritative or unverified?
    Wikipedia
  • Which of the following are typically an example of secondary resources?
    Biographies
  • 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 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
  • 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 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)
  • When specifying keywords to conduct an Internet search, which of the following parts of speech will be the most useful?
    Nouns
  • Which type of database table relationship is the most common?
    One-to-many relationship
  • 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 will internet search results contain when you use the AND Boolean operator in a two-keyword search string?
    Both keywords
  • Which type of online resource accepts input only from scholars and recognized authorities?
    Authoritative peer-reviewed
  • How is a table relationship established?
    By matching data in key fields between two database tables
  • What is a search index?
    A catalog consisting of many webpage references
  • 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
  • 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 collection of information consisting of one or more related fields about a specific entity, such as a person, product, or event?
    Record
  • Which of the following would a search engine use to reference a Website?
    Keyword
  • An information portal is a search engine that will only find:
    Websites that have been registered with search engines