Mininterno.net - Elenco domande di 70-229: SQL Server 2000 database design and implementation

Elenco in ordine alfabetico delle domande di 70-229: SQL Server 2000 database design and implementation

Seleziona l'iniziale:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

> Clicca qui per scaricare l'elenco completo delle domande di questo argomento in formato PDF!

- Mary wants to create a summary of the advances paid out by publishers for all the different types of books they publish. She would also like a summary of the total advances paid out by the publishers regardless of the book types. She decides to use the CUBE operator in her query to return the additional summary information about the publisher as a whole, without having to write a separate query. The statement she uses is as follows:
SELECT Pub_ID, Type, Sum(Advance)
FROM Titles
GROUP BY Pub_ID, Type
WITH CUBE
Which of the following best describes her solution to the problem?
This is a good solution and returns all the information she wants.