Question 1

A car parts inventory database that includes a picture of the part itself as a graphic would most likely be stored in which type of database?
A)Multidimensional database
B)Hierarchical database
C)Object oriented database
D)Data dictionary

Accepted Answer

An object oriented database would be the best choice because it allows for the storage of complex data types such as graphics and images. This type of database also allows for flexible and efficient data modeling, making it ideal for storing information about car parts.

Question 2

Which of these is true about finding data in multimedia databases?
A)It is not possible to search them because graphics have no text keys for searching
B)It is not possible to search them because audio objects have no text keys for searching
C)It is possible to search for items in them because such characteristics as "speaker" or "subject" can be used as search parameters
D)It is possible to search for items in them if the name of the embedded graphics or audio file is also known

Accepted Answer

It is possible to search for items in them because such characteristics as "speaker" or "subject" can be used as search parameters

Question 3

Which of these types of databases might also store instructions that indicate how to compute an employee's net pay?
A)Multidimensional database
B)Hierarchical database
C)Object oriented database
D)Data dictionary

Accepted Answer

An object-oriented database can store complex data types, including instructions or methods, which can be used to compute an employee's net pay.

Question 4

Which of these is an example of a data query language?
A)ABC
B)SQL
C)DDL
D)JPG

Accepted Answer

SQL (Structured Query Language) is a data query language used to manage and manipulate relational databases. The other choices (ABC, DDL, JPG) are not data query languages.

Question 5

A school administrator wishes to select the names of all students who live in a certain city.That city has exactly two zip codes in it.Which of these would be the best approach to use for this task?
A)Perform two separate select queries,using only one zip code for each task
B)Perform a single select query,placing the zip codes on the same Criteria line of the query
C)Perform a single select query,placing the zip codes on separate Criteria lines of the query
D)Perform a single,update query
E)none of these (this is not possible using Microsoft Access)

Accepted Answer

Performing a single select query with the zip codes on separate Criteria lines would be the best approach. This allows the administrator to retrieve all student names who live in either of the two zip codes without having to perform multiple queries or manually combine results from separate queries.

Question 6

Sorting and Indexing database records are similar in that:
A)Neither require underlying table records
B)Both require the user to first define data validation rules
C)Both reorganize the way record data appear in outputs
D)none of these

Accepted Answer

Both sorting and indexing reorganize the way record data appear in outputs. Sorting reorders the records based on a specified field or criteria, while indexing creates a separate data structure that maps the values in a specific field to their corresponding records. Both techniques improve data access and efficiency. Choices A and B are incorrect because both sorting and indexing rely on the underlying table records, and data validation rules may not be necessary for either technique. Choice D is incorrect because there is a similarity between sorting and indexing.

Question 7

Sorting records are unlike indexing records in that:
A)Sorting physically rewrites records on disks whereas indexing does not
B)Sorting requires a primary key whereas indexing does not
C)Indexing requires a separate database file whereas sorting does not
D)none of these

Accepted Answer

Sorting involves physically arranging records on disks based on some criteria, which requires rewriting the records in the new order. Indexing, on the other hand, creates a separate database file that contains pointers to the original records, without physically modifying their order. Choice B and C are incorrect as both sorting and indexing can be done with or without a primary key, and without requiring a separate file, respectively.

Question 8

A school administrator wishes to select the names of all students who have taken at least 130 units of credit at your university to see if they qualify for graduation.Which of these is the best type of query to use for this task?
A)Append query
B)Update query
C)Make table query
D)Select query
E)Make report query

Accepted Answer

A select query is the best type of query to use for this task as it allows for selecting specific data based on criteria, in this case, students who have taken at least 130 units of credit. The other query types (append, update, make table, make report) are not relevant for this task.

Question 9

You could append the term "Jr." to selected names in a customer database using Microsoft's:
A)Append query
B)Update query
C)Make table query
D)Select query
E)none of these (this is not possible using an action query)

Accepted Answer

The answer of You could append the term "Jr." to...

Question 10

In Access,the terms "size," "data type," and "input mask" are mostly closely associated with:
A)A table
B)A record
C)A data field
D)A database

Accepted Answer

Size, data type, and input mask are all properties of a data field in Microsoft Access. Size refers to the maximum number of characters a field can hold, data type determines the type of data that can be stored in the field (e.g. text, number, date/time), and input mask is a pattern that controls how data is entered into the field (e.g. phone number, social security number).

Question 11

As a general rule,creating data warehouses is:
A)Easy
B)Habit forming
C)Challenging but often worth the cost
D)Challenging,and historically rarely worth the cost

Accepted Answer

Creating data warehouses is challenging due to the complexity of collecting data from multiple sources, integrating it, and ensuring its quality. However, the benefits of having a centralized source of high-quality data for analysis and decision-making often outweigh the costs and effort involved in building and maintaining a data warehouse.

Question 12

An advantage of a multimedia database is that:
A)They can store graphics and pictures as well as numeric data
B)They are also object-oriented databases
C)They allow users to upload pictures in web applications
D)all of these are advantages

Accepted Answer

A multimedia database can store different types of data including graphics, pictures, and numeric data. It can be considered as an object-oriented database as well. Additionally, it allows users to upload pictures in web applications. Therefore, all of these are advantages of a multimedia database.

Question 13

All of these are characteristics of the data stored in a data warehouse except:
A)Data are clean of errors
B)Data are defined uniformly
C)Data are stored in consistent formats
D)Data are simplified,and thus cannot be used to answer complex questions

Accepted Answer

The statement "Data are simplified,and thus cannot be used to answer complex questions" is incorrect. Data stored in a data warehouse are not necessarily simplified, but they are structured in a way that facilitates complex analysis and reporting. The other three characteristics mentioned in the options (cleanliness, uniformity, consistency of formats) are indeed characteristics of data stored in a data warehouse.

Question 14

Another word for "cleaning" the data in preparation for storing it in a data warehouse in order to ensure uniform accuracy is:
A)Scrubbing
B)Sanitizing
C)Validating
D)Coding

Accepted Answer

Scrubbing is the process of cleaning and transforming the data to ensure that it is accurate and consistent before it is entered into the data warehouse. This process involves identifying and correcting errors, removing duplicates, and standardizing formats. Sanitizing typically refers to removing sensitive or private information from data, validating refers to ensuring that data meets certain quality standards, and coding refers to programming tasks rather than data cleaning.

Question 15

All of these are examples of action queries that you can create in Microsoft Access except:
A)Append query
B)Update query
C)Make table query
D)Delete query
E)Validation query

Accepted Answer

Validation query is not an action query in Microsoft Access. Action queries (Append, Update, Make Table, and Delete) are used to modify data or structure in the database, while validation is a process for checking data integrity and constraints, not a specific query type in Access.

Question 16

You can increase the prices of selected products systematically using Microsoft's:
A)Append query
B)Update query
C)Make table query
D)Delete query
E)Select query

Accepted Answer

An update query allows you to change the values in a particular field of a table. This is the best choice to systematically increase prices of selected products in a table.

Question 17

Using Access,which of these terms is not associated with defining a data field within a record?
A)Field name
B)Data type
C)Currency value
D)Description

Accepted Answer

Field name, data type, and description are all terms that are typically associated with defining a data field within a record in Access. However, currency value is not a term used in defining a data field, as currency values are typically stored within a field that has already been defined with a specific data type (such as "Currency" or "Number" with a format of "Currency").

Question 18

Which of these is a desirable guideline to follow when creating queries with Microsoft Access?
A)Spell accurately
B)Don't worry about capitalization
C)Join each table at least twice to ensure their connectivity
D)Name each query you create "Query"

Accepted Answer

Accurate spelling is important in order to ensure that the query can accurately retrieve the desired data. Capitalization can affect the query's results as well, so it's best to follow proper capitalization rules. Joining tables multiple times is not necessary and can actually lead to errors. Naming each query "Query" can lead to confusion and make it difficult to manage multiple queries.

Question 19

These databases can include graphics,audio,and animation:
A)Multidimensional databases
B)Hierarchical databases
C)Object-oriented databases
D)Multimedia databases

Accepted Answer

Multimedia databases are designed to accommodate audio, video, graphics, animation, and other media types. These databases differ from other types of databases that only handle text and numerical data. In a multimedia database, the data can include images, audio, video, and text, making it more flexible and robust in terms of handling various data formats.

Question 20

OLAP stands for:
A)Object Language for Access Programming
B)Object Level Analytical Programming
C)Online Analytical Processing
D)none of these

Accepted Answer

OLAP stands for Online Analytical Processing. It is a technology used for performing complex and multi-dimensional analysis of business data. Option A is incorrect as it stands for Object Language for Access Programming, which is used to program Microsoft Access databases. Option B is incorrect as there is no such term as Object Level Analytical Programming. Option D is incorrect as none of the given choices match the correct definition of OLAP.

Quiz 4: Organizing and Manipulating the Data in Databases

A car parts inventory database that includes a picture of the part itself as a graphic would most likely be stored in which type of database?

Which of these is true about finding data in multimedia databases?

Which of these types of databases might also store instructions that indicate how to compute an employee's net pay?

Which of these is an example of a data query language?

A school administrator wishes to select the names of all students who live in a certain city.That city has exactly two zip codes in it.Which of these would be the best approach to use for this task?

Sorting and Indexing database records are similar in that:

Sorting records are unlike indexing records in that:

A school administrator wishes to select the names of all students who have taken at least 130 units of credit at your university to see if they qualify for graduation.Which of these is the best type of query to use for this task?

You could append the term "Jr." to selected names in a customer database using Microsoft's:

In Access,the terms "size," "data type," and "input mask" are mostly closely associated with:

As a general rule,creating data warehouses is:

An advantage of a multimedia database is that:

All of these are characteristics of the data stored in a data warehouse except:

Another word for "cleaning" the data in preparation for storing it in a data warehouse in order to ensure uniform accuracy is:

All of these are examples of action queries that you can create in Microsoft Access except:

You can increase the prices of selected products systematically using Microsoft's:

Using Access,which of these terms is not associated with defining a data field within a record?

Which of these is a desirable guideline to follow when creating queries with Microsoft Access?

These databases can include graphics,audio,and animation:

OLAP stands for: