MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 347 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Science Engineering (CSE) knowledge and support exam preparation. Choose a topic below to get started.
| 301. |
Identity correct equation of Jacard Coefficient: |
| A. | j= f11/f01+f10+f11 |
| B. | j= f11+f00/f01+f10+f11 |
| C. | j= f11+f00/f01+f10 |
| D. | none of these |
| Answer» B. j= f11+f00/f01+f10+f11 | |
| 302. |
A single axon makes ___________ of synapses with other neurons. |
| A. | ones. |
| B. | hundreds. |
| C. | thousands. |
| D. | millions. |
| Answer» D. millions. | |
| 303. |
Which of the following is not a primary grain in analytical modeling? |
| A. | transaction. |
| B. | periodic snapshot. |
| C. | accumulating snapshot. |
| D. | all of the above. |
| Answer» C. accumulating snapshot. | |
| 304. |
In ________ the groups are not predefined. |
| A. | association rules. |
| B. | summarization. |
| C. | clustering. |
| D. | prediction. |
| Answer» D. prediction. | |
| 305. |
Granularity is determined by ______. |
| A. | number of parts to a key. |
| B. | granularity of those parts. |
| C. | both a and b. |
| D. | none of the above. |
| Answer» D. none of the above. | |
| 306. |
Reconciled data is ___________. |
| A. | data stored in the various operational systems throughout the organization. |
| B. | current data intended to be the single source for all decision support systems. |
| C. | data stored in one operational system in the organization. |
| D. | data that has been selected and formatted for end-user support applications. |
| Answer» C. data stored in one operational system in the organization. | |
| 307. |
BIRCH is a ________. |
| A. | agglomerative clustering algorithm. |
| B. | hierarchical algorithm. |
| C. | hierarchical-agglomerative algorithm. |
| D. | divisive. |
| Answer» D. divisive. | |
| 308. |
__________ clustering techniques starts with all records in one cluster and then try to split thatcluster into small pieces. |
| A. | agglomerative. |
| B. | divisive. |
| C. | partition. |
| D. | numeric. |
| Answer» C. partition. | |
| 309. |
_________ matrix represents the distance between all objects in the dataset |
| A. | confusion |
| B. | dissimilarity |
| C. | similarity |
| D. | square |
| Answer» C. similarity | |
| 310. |
Database is |
| A. | Large collection of data mostly stored in a computer system |
| B. | The removal of noise errors and incorrect input from a database |
| C. | The systematic description of the syntactic structure of a specific database. It describes the structure of the attributes the tables and foreign key relationships. |
| D. | None of these |
| Answer» B. The removal of noise errors and incorrect input from a database | |
| 311. |
_________maps the core warehouse metadata to business concepts, familiar and useful to endusers. |
| A. | application level metadata. |
| B. | user level metadata. |
| C. | enduser level metadata. |
| D. | core level metadata. |
| Answer» B. user level metadata. | |
| 312. |
___________ is data collected from natural systems. |
| A. | mri scan. |
| B. | ods data. |
| C. | statistical data. |
| D. | historical data. |
| Answer» B. ods data. | |
| 313. |
A link is said to be _______ link if it is between pages with the same domain name. |
| A. | intrinsic. |
| B. | transverse. |
| C. | direct. |
| D. | contrast. |
| Answer» B. transverse. | |
| 314. |
. ___________ is a system created for rule induction. |
| A. | rbs. |
| B. | cbs. |
| C. | dbs. |
| D. | lers. |
| Answer» E. | |
| 315. |
If a set is a frequent set and no superset of this set is a frequent set, then it is called ________. |
| A. | maximal frequent set. |
| B. | border set. |
| C. | lattice. |
| D. | infrequent sets. |
| Answer» B. border set. | |
| 316. |
The ____________ of data could result in the disclosure of information that is deemed to beconfidential. |
| A. | authorized use. |
| B. | unauthorized use. |
| C. | authenticated use. |
| D. | unauthenticated use. |
| Answer» C. authenticated use. | |
| 317. |
____________ proposed the approach for data integration issues. |
| A. | ralph campbell. |
| B. | ralph kimball. |
| C. | john raphlin. |
| D. | james gosling. |
| Answer» C. john raphlin. | |
| 318. |
The extract process is ______. |
| A. | capturing all of the data contained in various operational systems. |
| B. | capturing a subset of the data contained in various operational systems. |
| C. | capturing all of the data contained in various decision support systems. |
| D. | capturing a subset of the data contained in various decision support systems. |
| Answer» C. capturing all of the data contained in various decision support systems. | |
| 319. |
An algorithm called________is used to generate the candidate item sets for each pass after the first. |
| A. | apriori. |
| B. | apriori-gen. |
| C. | sampling. |
| D. | partition. |
| Answer» C. sampling. | |
| 320. |
GA stands for _______________. |
| A. | genetic algorithm |
| B. | gene algorithm. |
| C. | general algorithm. |
| D. | geo algorithm. |
| Answer» B. gene algorithm. | |
| 321. |
The first International conference on KDD was held in the year _____________. |
| A. | 1996. |
| B. | 1997. |
| C. | 1995. |
| D. | 1994. |
| Answer» D. 1994. | |
| 322. |
__________ is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support ofmanagement decisions. |
| A. | data mining. |
| B. | data warehousing. |
| C. | web mining. |
| D. | text mining. |
| Answer» C. web mining. | |
| 323. |
The modern CASE tools belong to _______ category. |
| A. | a. analysis. |
| B. | b.development |
| C. | c.coding |
| D. | d.delivery |
| Answer» B. b.development | |
| 324. |
Bill Inmon has estimated___________of the time required to build a data warehouse, is consumed in the conversion process. |
| A. | 10 percent. |
| B. | 20 percent. |
| C. | 40 percent |
| D. | 80 percent. |
| Answer» E. | |
| 325. |
The source of all data warehouse data is the____________. |
| A. | operational environment. |
| B. | informal environment. |
| C. | formal environment. |
| D. | technology environment. |
| Answer» B. informal environment. | |
| 326. |
Data warehouse contains_____________data that is never found in the operational environment. |
| A. | normalized. |
| B. | informational. |
| C. | summary. |
| D. | denormalized. |
| Answer» D. denormalized. | |
| 327. |
Record cannot be updated in _____________. |
| A. | oltp |
| B. | files |
| C. | rdbms |
| D. | data warehouse |
| Answer» E. | |
| 328. |
The time horizon in operational environment is ___________. |
| A. | 30-60 days. |
| B. | 60-90 days. |
| C. | 90-120 days. |
| D. | 120-150 days. |
| Answer» C. 90-120 days. | |
| 329. |
Data can be updated in _____environment. |
| A. | data warehouse. |
| B. | data mining. |
| C. | operational. |
| D. | informational. |
| Answer» D. informational. | |
| 330. |
The star schema is composed of __________ fact table. |
| A. | one. |
| B. | two. |
| C. | three. |
| D. | four. |
| Answer» B. two. | |
| 331. |
The key used in operational environment may not have an element of__________. |
| A. | time. |
| B. | cost. |
| C. | frequency. |
| D. | quality. |
| Answer» B. cost. | |
| 332. |
_____________consists of information in the enterprise that is not in classical form. |
| A. | mushy metadata. |
| B. | differential metadata. |
| C. | data warehouse. |
| D. | data mining. |
| Answer» B. differential metadata. | |
| 333. |
_________maps the core warehouse metadata to business concepts, familiar and useful to end users. |
| A. | application level metadata. |
| B. | user level metadata. |
| C. | enduser level metadata. |
| D. | core level metadata. |
| Answer» B. user level metadata. | |
| 334. |
. ______________databases are owned by particular departments or business groups. |
| A. | informational. |
| B. | operational. |
| C. | both informational and operational. |
| D. | flat. |
| Answer» C. both informational and operational. | |
| 335. |
________________ is held in the catalog of the warehouse database system. |
| A. | application level metadata. |
| B. | algorithmic level metadata. |
| C. | departmental level metadata. |
| D. | core warehouse metadata. |
| Answer» C. departmental level metadata. | |
| 336. |
______consists of formal definitions, such as a COBOL layout or a database schema. |
| A. | classical metadata. |
| B. | transformation metadata. |
| C. | historical metadata. |
| D. | structural metadata. |
| Answer» B. transformation metadata. | |
| 337. |
________________ is the specialized data warehouse database. |
| A. | oracle. |
| B. | dbz. |
| C. | informix. |
| D. | redbrick. |
| Answer» E. | |
| 338. |
__________ is the heart of the warehouse. |
| A. | data mining database servers. |
| B. | data warehouse database servers. |
| C. | data mart database servers. |
| D. | relational data base servers. |
| Answer» C. data mart database servers. | |
| 339. |
________________defines the structure of the data held in operational databases and used by operational applications. |
| A. | user-level metadata. |
| B. | data warehouse metadata. |
| C. | operational metadata. |
| D. | data mining metadata. |
| Answer» D. data mining metadata. | |
| 340. |
____________predicts future trends & behaviors, allowing business managers to make proactive, knowledge-driven decisions. |
| A. | data warehouse. |
| B. | data mining. |
| C. | datamarts. |
| D. | metadata. |
| Answer» C. datamarts. | |
| 341. |
__________describes the data contained in the data warehouse. |
| A. | relational data. |
| B. | operational data. |
| C. | metadata. |
| D. | informational data. |
| Answer» D. informational data. | |
| 342. |
The data is stored, retrieved & updated in ____________. |
| A. | olap. |
| B. | oltp. |
| C. | smtp. |
| D. | ftp. |
| Answer» C. smtp. | |
| 343. |
The time horizon in Data warehouse is usually __________. |
| A. | 1-2 years. |
| B. | 3-4years. |
| C. | 5-6 years. |
| D. | 5-10 years. |
| Answer» E. | |
| 344. |
The important aspect of the data warehouse environment is that data found within the data warehouse is___________. |
| A. | subject-oriented. |
| B. | time-variant. |
| C. | integrated. |
| D. | all of the above. |
| Answer» E. | |
| 345. |
Expansion for DSS in DW is__________. |
| A. | decision support system. |
| B. | decision single system. |
| C. | data storable system. |
| D. | data support system. |
| Answer» B. decision single system. | |
| 346. |
The data Warehouse is__________. |
| A. | read only. |
| B. | write only. |
| C. | read write only. |
| D. | none. |
| Answer» B. write only. | |
| 347. |
__________ is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management decisions. |
| A. | data mining. |
| B. | data warehousing. |
| C. | web mining. |
| D. | text mining. |
| Answer» C. web mining. | |