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!

Digital Image Processing (DIP)

Delve into the techniques of enhancing digital images with our Digital Image...

MATLAB

Hone your computational mathematics skills with our MATLAB MCQs. Understand...

Computer Graphics

Step into the visual side of computing with our Computer Graphics MCQs. Cover topics...

Digital Logic Design

Understand the foundation of digital computers with our Digital Logic Design MCQs....

Compiler Design

Unravel the process of translating source code into executable programs with our...

Discrete Mathematics

Refine your mathematical skills essential for computer science with our Discrete...

Object Oriented Programming

Enhance your coding skills with our Object Oriented Programming MCQs. Understand...

DBMS

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

Reverse Engineering

Strengthen your understanding of Reverse Engineering with our curated set of MCQs....