Question
a.
standard SQL only
b.
extensions to SQL only
c.
OLAP only
d.
both standard SQL and extensions to SQL
Posted under DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Business Intelligence (BI) reporting analyses can be performed using ________ .
Similar Questions
Discover Related MCQs
Q. We have been given access to the company's operational data, and have been asked to produce a report. We discover that some of the data we need are in an SQL server database while other needed data are in a separate Oracle database. This is an example of ________ .
View solution
Q. The reports generated by a reporting system are usually not delivered in which of the following media?
View solution
Q. Data mining applications are used accomplish which of the following tasks?
View solution
Q. Which of the following is an unsupervised data mining technique?
View solution
Q. In OLAP, we are interested in ________ .
View solution
Q. Which of the following is not a reason that operational data are difficult to read?
View solution
Q. We have Market Basket data for 1,000 rental transactions at a Video Store. There are four videos for rent -- Video A, Video B, Video C and Video D. The probability that Video D will be rented given that Video C has been rented is known as ________ .
View solution
Q. One popular classification technique in Business Intelligence (BI) reporting is ________ .
View solution
Q. We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .
View solution
Q. Fact constellation is a good alternative to the
View solution
Q. Which operation mainly used to access the live data online and analyse it
View solution
Q. In data mining, the slice operation performs a selection on _______
View solution
Q. In data mining, the dice operation performs a selection on
View solution
Q. In star schema there is _________ relationship between fact table and dimension table
View solution
Q. Fact constellation is also known as
View solution
Q. __________ is the bridge between data warehouse and decision support application.
View solution
Q. Which one referes to the finding of relevant and useful information from databases
View solution
Q. Preprocessing step is used in Data _______
View solution
Q. True or False : "Selection and interpretation is a data mining functionality"
View solution
Q. Which type of metadata is held in the catalog of the warehouse database system
View solution
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!