Which of the following is true about a crosstab query

Assignment Help Database Management System
Reference no: EM131383994

Question 1.Data aggregates

are used to perform calculations on individual records in a table or query.

cannot be used in a report.

perform calculations on entire columns of data.

return multiple values.

Question 2. All of the following are Access data types EXCEPT:

autonumber.

date/time.

number.

string.

Question 3. Which of the following is NOT true of a single-table query?

It can be created using the Simple Query Wizard.

Queries can be created using the Query Design Tool.

You can overwrite Table data using the Datasheet View of a Query.

The top portion of the Query Design View displays the fields and criteria.

Question 4. Access has __________ data types.

six

eight

10

12

Question 5. The command language used with relational databases is

PNPI

RDBMS

SQL

tuple.

Question 6. Another term for an expression is

formula.

function.

parameter.

query.

Question 7.A function used to isolate a specific portion of a date such as year, month, or day in a date field is

Date.

DateDiff.

DateParse.

DatePart.

Question 8. A primary key

can be computer generated.

consists of one field only that uniquely identifies each record in a table.

is a relationship between two or more tables.

All of the above

Question 9. A parameter query is

a select query where the user provides the criterion at run time.

an action query used to modify data.

an aggregate query used to summarize field data.

used to backup databases.

Question 10.Which of the following is true about a crosstab query?

It is an action query.

It is used to retrieve parameter data.

It summarizes a data source into rows and columns with aggregate data displayed at the intersection of the rows and columns.

It summarizes unmatched records from a data source.

Reference no: EM131383994

Questions Cloud

Find the angle through which the comet is deflected : By using the path equation, find the angle through which the comet is deflected and the distance of closest approach.
Describe the envelope seal : Describe the "envelope", seal, and the early Mesopotamian writing process. Identify the issue being kept "on file," and comment on what this reveals about Mesopotamian society and the primary ways it compares to modern society in these respects.
Explain why the navy is likely to choose your company : Imagine that you have received a Request for Proposal (RFP).You also find out through a reliable source that a local competitor has also received an RFP for a similar type of product and service.you will be required to negotiate the contract, and w..
What is the probability of either x or y occurring : The eventsXandYare mutually exclusive. SupposeP(X)_.05 andP(Y)_.02. What is the probability of either X or Y occurring? What is the probability that neitherXnorYwill happen?
Which of the following is true about a crosstab query : A function used to isolate a specific portion of a date such as year, month, or day in a date field is.Which of the following is true about a crosstab query?A function used to isolate a specific portion of a date such as year, month, or day in a date..
Which divides each line in the given ratio : Show that the lines AP, B Q, C R, DS all meet in a point (called the centroid of the tetrahedron), which divides each line in the ratio 3:1.
Give the answer of muliple choice question : The Acme Products case study notes that the senior management at Acme is concerned because the company takes so long to bring new products to the market. Which of the following approaches would your trainees identify as the most likely solution to..
Find the protein concentration in a fraction : The equation from the BSA standard curve is y=0.0264x+0.0129 where y is the absorbance and x is the concentration in µg/mL
What is the purpose of sds in the cell lysis solution : What is the purpose of SDS in the cell lysis solution? What is the function of the alcohol solution?

Reviews

Write a Review

 

Database Management System Questions & Answers

  Describe and support database schema with relevant arguments

Create a database schema that supports the company's business and processes. Explain and support the database schema with relevant arguments that support the rationale for the structure.

  Describe the values of the two business intelligence tools

Estimate the costs and describe the values of the two business intelligence tools you have identified from Part 1 of this discussion based on their functionality, integrating architecture, and benefits to the enterprise. Provide your rationale

  Explain the three factors that influence the cost of a query

Discuss the reasons for converting SQL queries into relational algebra queries before optimization is done.  Explain the three factors that influence the cost of a query

  How referential integrity constraint prevent data

In physical database design, referential integrity constraints can be defined. What actions does referential integrity constraint prevent from happening when data is inserted in table which contains this constraint?

  How organizations can use data warehouses

Write a one- to two-page (250-500 word) paper that discusses the differences between data warehouses and data marts. Also, discuss how organizations can use data warehouses and data marts to acquire data

  Discuss process went through to select appropriate data type

Discuss the process you went through to select the appropriate data types, primary and foreign keys, and other constraints that are necessary to maintain the integrity of the database.

  How does access identify each record within a database

How does Access identify each record within a database? What is the benefit for your data entry people by providing their data entries via combo boxes? What is the purpose of creating a lookup column in Access?

  Evaluation team in order to meet sarbanes-oxley compliance

Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley compliance.

  Distribution of resource consumption

Compute the activity rates for the Filling Orders and Product Support activity cost pools by filling - Distribution of resource consumption

  Execution of the SQL commands - Create Tables using SQL DDL

The appropriate SQL command which should be copied from your source code in MySQL and resultant tables, which must be screenshots to show the change due to the execution of the SQL commands

  What are the title and special features for films

What are the title and special features for films rated PG-13 and longer than 180 minutes? What are the three most popular firstnames among the actors in the database?

  Electronic spreadsheets in data modeling

Explain in detail with supporting illustrations the six stages of the problem solving process and explain when the choice for using electronic spreadsheets is the preferred tool of choice.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd