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!

Computer Graphics

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

Embedded Systems

Dive into the world of specialized computing systems with our Embedded Systems MCQs....

SQL Server

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

CSS

Polish your web design skills with our CSS MCQs. Learn about selectors, properties,...

MongoDB

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

Artificial Intelligence

Get started on the path to the future with our Artificial Intelligence MCQs. Covering...

Java Programming

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

Object Oriented Programming

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

Web Technologies

Master the building blocks of the web with our Web Technologies MCQs. From HTML and...