adplus-dvertising
frame-decoration

Question

What is the primary difference between a pivot table report and a cross tab query?

a.

A pivot table report can contain sums, counts, and averages while a cross tab query cannot.

b.

You cant pivot a cross tab query

c.

A cross tab query lets you group similar items. A pitot table report does not

d.

None of the above

Posted under DBMS

Answer: (b).You cant pivot a cross tab query

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. What is the primary difference between a pivot table report and a cross tab query?
Add Comment

Similar Questions

Discover Related MCQs

Q. The largest unit of a database is

View solution

Q. Whats the best Access object for an invoice youll mail to customers?

View solution

Q. What is a Grouped Report?

View solution

Q. Which field allow to select items from drop down list?

View solution

Q. What did the first Table Analyzer do?

View solution

Q. Pivot Table reports are good for

View solution

Q. Which of the following are common ways to enforce data validation when entering data into an Access form?

View solution

Q. The purpose of the Add-in Manager is to

View solution

Q. Sub-schema can be used to

View solution

Q. If you are entering data in a form, a quick way to cpy a value from the previous record is to press

View solution

Q. DBMS is

View solution

Q. COPY STRUCTURE command is used to

View solution

Q. COUNT command is used to

View solution

Q. What is the term to ask the computer to pt information in order numerically or alphabetically ?

View solution

Q. The raw facts are called

View solution

Q. The term refers to a collection of related information

View solution

Q. A form that is used to collect data in a structured manner for entry to a database is called a

View solution

Q. The following command is used for inserting records

View solution

Q. The Query is a statement requesting for

View solution

Q. The following statement is not valid about indexing

View solution
View All MCQs on DBMS

Suggested Topics

Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Java Programming

Level up your coding skills with our Java Programming MCQs. From object-oriented...

SQL Server

Master Microsoft's database server with our SQL Server MCQs. Topics cover database...

Systems Analysis and Design Methods

Get familiar with the process of designing and improving business systems with our...

DBMS

Get a firm grasp on database systems with our DBMS MCQs. Explore relational...

R Programming

Unleash the power of statistical computing with our R Programming MCQs. Topics cover...

Management Information Systems

Discover how businesses leverage technology with our Management Information Systems...

Operating System

Dive deep into the core of computers with our Operating System MCQs. Learn about...

Digital Communication

Master the basics of electronic communication with our Digital Communication MCQs....

Object Oriented Programming Using C++

Enhance your programming skills with our MCQs on Object Oriented Programming using...