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 Basics 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 Basics

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!

R Programming

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

Data Structures and Algorithms

Journey through the fundamentals of Data Structures and Algorithms with our extensive...

C Programming

Master one of the most widely used programming languages with our C Programming MCQs....

Java Programming

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

Cloud Computing

Stay on top of the biggest trend in IT with our Cloud Computing MCQs. These questions...

Systems Analysis and Design Methods

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

Operating System

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

DBMS

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

MongoDB

Learn the leading NoSQL database with our MongoDB MCQs. Understand everything from...