Online MCQ Assignment Answer
QN1: Which type of decision is one that happens repeatedly, and often periodically, whether weekly, monthly, quarterly, or yearly?
a) Structured decision
b) Non structured decision
c) Nonrecurring decision
d) None of the above
Answer
Answer: b) Non structured decision
QN2: In multi-dimensional analysis, roll-up can be achieved by:
a) Moving up a dimension hierarchy like city -> state, etc.
b) Moving down a dimension hierarchy like state -> city, etc.
c) Adding a new dimension
d) Removing one or more dimensions
Answer
Answer: a) Moving up a dimension hierarchy like city -> state, etc.
QN3: Which technique can be used to reduce the size of the candidate k-itemsets in Apriori Algorithm?
a) Pruning
b) Cleaning
c) Hash based
d) Partitioning
Answer
Answer: a) Pruning
QN4: Classification belongs to which type of learning?
a) Supervised
b) Unsupervised
c) Rote
d) Machine
Answer
Answer: a) Supervised
QN5: Structured query language (SQL) is a standardized fourth generation query language found in most DBMSs
a) True
b) false
c) nil
d) nil
Answer
Answer: a) True
QN6: A data warehouse is a logical collection of information – gathered from many different operational databases – used to create business intelligence that supports business analysis activities and decision-making tasks.
a) true
b) false
c) nil
d) nil
Answer
Answer: a) true
QN7: Online transactions processing (OLTP) is the manipulation of information to support decision making.
a) true
b) false
c) nil
d) nil
Answer
Answer: b) false
QN8: Data warehouses support only OLAP.
a) True
b) false
c) nil
d) nil
Answer
Answer: a) True
QN9: A database is a collection of information that you organize and access according to the physical structure of that information.
a) True
b) False
c) nil
d) nil
Answer
Answer: b) False
QN10: The physical view of information focuses on how you need to arrange and access information to meet the needs of the business.
a) true
b) false
c) nil
d) nil
Answer
Answer: b) false
QN11: A view helps you add, change, and delete information in a database and mine it for valuable information
a) True
b) false
c) nil
d) nil
Answer
Answer: b) false
QN12: Apriori algorithm used in–
a) Clustering
b) Classification
c) Association Rule mining
d) None of these
Answer
Answer: c) Association Rule mining
QN13: DBSCAN technique comes under–
a) Classification
b) Clustering
c) Prediction
d) Other
Answer
Answer: b) Clustering
QN14: Data warehouse schema can be–
a) Star schema
b) Asynchronous table
c) Formula
d) None of these
Answer
Answer: a) Star schema
QN15: In Association Rule Mining support (A=>B) is–
a) Probability (AUB)
b) Subtraction i.e. (A-B)
c) Addition i.e. (A+B)
d) None of these
Answer
Answer: a) Probability (AUB)
QN16: Select the Non Data Mining techniques–
a) Association rule mining
b) Clustering
c) Classification
d) Selection Sort
Answer
Answer: d) Selection Sort
QN17: Which step in Apriori algorithm uses apriori property?
a) Join step
b) Prune step
c) Candidate generation step
d) Query processing
Answer
Answer: a) Join step
QN18: Which among the following is an accuracy measure of classifier?
a) Support
b) Confidence
c) Specificity
d) Recall
Answer
Answer: b) Confidence
QN19: Which decision type below represents employing a new marketing campaign?
a) Structured decision
b) Non structured decision
c) Nonrecurring decision
d) Recurring decision
Answer
Answer: c) Nonrecurring decision
QN20: Which phrase describes a decision support system?
a) Highly flexible IT system
b) Interactive IT system
c) Designed to support decision making
d) All of the above
Answer
Answer: d) All of the above
QN21: Which component of a DSS consists of both the DSS models and the DSS model management system?
a) Data management
b) Model management
c) User interface management
d) All of the above
Answer
Answer: b) Model management
QN22: Which type of AI system is an adaptive system that works independently, carrying out specific, repetitive, or predictable tasks?
a) Expert systems
b) Neural networks
c) Genetic algorithms
d) None of the above
Answer
Answer: d) None of the above
QN23: All of the following are IT components of an expert system, except:
a) Knowledge base
b) User acquisition
c) Inference engine
d) User interface
Answer
Answer: b) User acquisition
QN24: An intelligent agent that checks your e-mail and sorts it according to priority is called
a) User agent
b) Monitoring-and-surveillance agent
c) Data-mining agent
d) Buyer agent
Answer
Answer: a) User agent
QN25: Which of the following uses a series of logically related two-dimensional tables or files to store information in the form of a database?
a) Database
b) Database management system
c) Data warehouse
d) None of the above
Answer
Answer: d) None of the above
QN26: All of the following terms describe OLAP, except
a) The gathering of input information
b) Processing input information
c) Updating existing information to reflect to the gathered and processed information
d) None of the above
Answer
Answer: d) None of the above
QN27: Which tool is used to help an organization build and use business intelligence?
a) Data warehouse
b) Data mining tools
c) Database management systems
d) All of the above
Answer
Answer: d) All of the above
QN28: What does the data dictionary identify?
a) Field names
b) Field types
c) Field formats
d) All of the above
Answer
Answer: d) All of the above
QN29: What DBMS component contains facilities to help you develop transaction-intensive applications?
a) DBMS engine
b) Data definition subsystem
c) Application generation subsystem
d) Data administration subsystem
Answer
Answer: c) Application generation subsystem
QN30: Which of the following is a data manipulation tool?
a) File generators
b) Query by example tool
c) Structure question language
d) All of the above
Answer
Answer: b) Query by example tool
QN31: What data manipulation tool is a standardized fourth-generation query language found in most DBMSs?
a) Report generator
b) Query-by-example tool
c) Statistical tool
d) None of the above
Answer
Answer: d) None of the above
QN32: The data administration subsystem helps you perform all of the following, except
a) Backups and recovery
b) Query optimization
c) Security management
d) Create, change, and delete information
Answer
Answer: d) Create, change, and delete information
QN33: Which data administration subsystem periodically backs up information contained in a database?
a) Concurrency control facilities
b) Reorganization facilities
c) Backup and recovery facilities
d) Security management facilities
Answer
Answer: c) Backup and recovery facilities
QN34: Who is the person responsible for the more technical and operational aspects of managing the information contained in organizational databases?
a) Chief information officer
b) Data administration
c) Data information officer
d) None of the above
Answer
Answer: d) None of the above
QN35: Which phase of decision-making carries out the chosen solution, monitors the results, and makes adjustments as necessary?
a) Intelligence
b) Design
c) Choice
d) None of the above
Answer
Answer: d) None of the above
QN36: Which type of intelligent agent travels around a network finding information and bringing it back to you?
a) Personal agent
b) User agent
c) Monitoring-and-surveillance agent
d) Shopping bots
Answer
Answer: d) Shopping bots
QN37: Intelligent agents are software that does all of the following, except–
a) Assists you
b) Acts on your behalf
c) Performs repetitive computer-related tasks
d) Performs repetitive information-processing tasks
Answer
Answer: d) Performs repetitive information-processing tasks
QN38: Business intelligence is information about your–
a) Customers
b) Competitors
c) Partners
d) Competitive environment
Answer
Answer: b) Competitors
QN39: Operational databases are databases that support OLTP.
a) True
b) False
c) nil
d) nil
Answer
Answer: a) True
QN40: A primary key field can be blank
a) true
b) false
c) NIL
d) nil
Answer
Answer: b) false
Total Views: 13