McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Bachelor of Science in Computer Science TY (BSc CS) , Master of Science in Computer Science (MSc CS) , Bachelor of Science in Computer Science (BSc CS) .
| 251. |
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» D. create, change, and delete information. | |
| 252. |
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» C. Backup and recovery facilities. | |
| 253. |
Which of the following is true of three-tier data warehouses |
| A. | Once created, the data marts will keep on being updated from the data warehouse at periodic times. |
| B. | Once created, the data marts will directly receive their new data from the operational databases. |
| C. | The data marts are different groups of tables in the data warehouse. |
| D. | A data mart becomes a data warehouse when it reaches a critical size. |
| Answer» A. Once created, the data marts will keep on being updated from the data warehouse at periodic times. | |
| 254. |
Which of the given technology is not well-suited for data mining |
| A. | Expert system technology. |
| B. | Data visualization. |
| C. | Technology limited to specific data types such as numeric data types. |
| D. | Parallel architecture. |
| Answer» C. Technology limited to specific data types such as numeric data types. | |
| 255. |
What is true about the multidimensional model |
| A. | It typically requires less disk storage. |
| B. | It typically requires more disk storage. |
| C. | Typical business queries requiring aggregate functions take more time. |
| D. | Typical business queries requiring aggregate functions take more time. |
| Answer» B. It typically requires more disk storage. | |
| 256. |
The most common source of change data in refreshing a data warehouse is__________. |
| A. | queryable change data. |
| B. | cooperative change data. |
| C. | logged change data. |
| D. | snapshot change data. |
| Answer» A. queryable change data. | |
| 257. |
Which of the following statements is not true about refreshing a data warehouse |
| A. | It is a process of managing timing differences between the updating of data sources and the related data warehouse objects. |
| B. | Updates to dimension tables may occur at different times than the fact table. |
| C. | The data warehouse administrator has more control over the load time lag than the valid time lag. |
| D. | None of the above. |
| Answer» D. None of the above. | |
| 258. |
The ________ is responsible for running queries and reports against data warehouse tables. |
| A. | hardware. |
| B. | software. |
| C. | end users. |
| D. | middleware. |
| Answer» C. end users. | |
| 259. |
Query tool is meant for __________. |
| A. | data acquisition. |
| B. | information delivery. |
| C. | information exchange. |
| D. | communication. |
| Answer» A. data acquisition. | |
| 260. |
Which of the following function involves data cleaning, data standardizing and summarizing |
| A. | Storing data. |
| B. | Transforming data. |
| C. | Data acquisition. |
| D. | Data Access. |
| Answer» B. Transforming data. | |
| 261. |
Which of the following clustering analysis method uses multi resolution approach |
| A. | STUNT. |
| B. | OPTICS. |
| C. | CLIQUE. |
| D. | Wave Cluster. |
| Answer» D. Wave Cluster. | |
| 262. |
Which type of following clustering computes augmented cluster ordering |
| A. | OPTICS. |
| B. | CLIQUE. |
| C. | STING. |
| D. | CLUSTER. |
| Answer» A. OPTICS. | |
| 263. |
Data compression is to compress the given data by encoding in terms of _________. |
| A. | bytes. |
| B. | bits. |
| C. | cluster. |
| D. | group. |
| Answer» C. cluster. | |
| 264. |
Which of the following feature is supported by the physical design of data warehouse |
| A. | Support backup and recovery. |
| B. | Planning. |
| C. | Analysis. |
| D. | Coding. |
| Answer» A. Support backup and recovery. | |
| 265. |
Classification rules are extracted from__________. |
| A. | root node. |
| B. | decision tree. |
| C. | siblings. |
| D. | branches. |
| Answer» B. decision tree. | |
| 266. |
Dimensionality reduction reduces the data set size by removing _________. |
| A. | relevant attributes. |
| B. | irrelevant attributes. |
| C. | derived attributes. |
| D. | composite attributes. |
| Answer» B. irrelevant attributes. | |
| 267. |
___________is a method of incremental conceptual clustering. |
| A. | CORBA. |
| B. | OLAP. |
| C. | COBWEB. |
| D. | STING. |
| Answer» C. COBWEB. | |
| 268. |
Effect of one attribute value on a given class is independent of values of other attribute is called__________. |
| A. | value independence. |
| B. | class conditional independence. |
| C. | conditional independence. |
| D. | unconditional |
| Answer» A. value independence. | |
| 269. |
Which of the following are special programs that are stored on database and fired when certain predefined action occurs |
| A. | Snapshots. |
| B. | Relations. |
| C. | Triggers. |
| D. | Cursors. |
| Answer» C. Triggers. | |
| 270. |
The _________ refers to extracting knowledge from larger amount of data. |
| A. | data abstraction. |
| B. | data warehouse. |
| C. | database. |
| D. | data mining. |
| Answer» D. data mining. | |
| 271. |
___________ is a knowledge discovery process. |
| A. | Data cleaning. |
| B. | Data warehousing. |
| C. | Data mining. |
| D. | Data transformation. |
| Answer» A. Data cleaning. | |
| 272. |
OLAP is used for __________. |
| A. | online application processing. |
| B. | online analytical processing. |
| C. | online aptitude processing. |
| D. | online administration and processing. |
| Answer» B. online analytical processing. | |
| 273. |
Maintenance of cache consistency is the limitation of _____________. |
| A. | NUMA. |
| B. | UNAM. |
| C. | MPP. |
| D. | PMP. |
| Answer» C. MPP. | |
| 274. |
Data warehouse architecture is based on _______________. |
| A. | DBMS. |
| B. | RDBMS. |
| C. | Sybase. |
| D. | SQL Server. |
| Answer» B. RDBMS. | |
| 275. |
Source data from the warehouse comes from ___________. |
| A. | ODS. |
| B. | TDS. |
| C. | MDDB. |
| D. | ORDBMS. |
| Answer» A. ODS. | |
| 276. |
The ___________is a data transformation process. |
| A. | comparison. |
| B. | projection. |
| C. | selection. |
| D. | filtering. |
| Answer» D. filtering. | |
| 277. |
Technology area associated with CRM is _____________. |
| A. | specialization. |
| B. | generalization. |
| C. | personalization. |
| D. | summarization. |
| Answer» C. personalization. | |
| 278. |
SMP stands for __________. |
| A. | symmetric multiprocessor. |
| B. | symmetric multiprogramming. |
| C. | symmetric meta programming. |
| D. | symmetric microprogramming. |
| Answer» A. symmetric multiprocessor. | |
| 279. |
The __________is designed to overcome any limitations placed on the warehouse by the nature of the relational data model. |
| A. | operational database. |
| B. | relational database. |
| C. | multidimensional database. |
| D. | data repository. |
| Answer» C. multidimensional database. | |
| 280. |
MDDB stands for _________. |
| A. | multiple data doubling. |
| B. | multidimensional databases. |
| C. | multiple double dimension. |
| D. | multi-dimension doubling. |
| Answer» B. multidimensional databases. | |
| 281. |
__________ is data about data. |
| A. | Metadata. |
| B. | Microdata. |
| C. | Minidata |
| D. | Multidata. |
| Answer» A. Metadata. | |
| 282. |
The ___________ is an important functional component of the metadata. |
| A. | digital directory. |
| B. | repository. |
| C. | information directory. |
| D. | data dictionary. |
| Answer» C. information directory. | |
| 283. |
EIS stands for __________. |
| A. | extended interface system. |
| B. | executive interface system. |
| C. | executive information system. |
| D. | extendable information system. |
| Answer» C. executive information system. | |
| 284. |
____________ is data collected from natural systems. |
| A. | MRI scan. |
| B. | ODS data. |
| C. | Statistical data. |
| D. | Historical data. |
| Answer» A. MRI scan. | |
| 285. |
Which one of the following feature is provided by an effective data visualization tool |
| A. | Capability to update data. |
| B. | Capability to delete or alter data. |
| C. | Capability in append data. |
| D. | Capability to compare data |
| Answer» D. Capability to compare data | |
| 286. |
The __________ are inexpensive desktop tools designed for end users. |
| A. | production tools. |
| B. | report writers. |
| C. | query tools. |
| D. | application tools. |
| Answer» B. report writers. | |
| 287. |
___________is an example of application development environments. |
| A. | Visual Basic. |
| B. | Oracle. |
| C. | Sybase. |
| D. | SQL Server. |
| Answer» A. Visual Basic. | |
| 288. |
Which of the following is not an issue related to concept learning |
| A. | Supervised learning. |
| B. | Unsupervised learning. |
| C. | Self learning. |
| D. | Concept learning. |
| Answer» D. Concept learning. | |
| 289. |
___________are some popular OLAP tools. |
| A. | Metacube, informix. |
| B. | Oracle express, essbase. |
| C. | HOLAP. |
| D. | MOLAP. |
| Answer» A. Metacube, informix. | |
| 290. |
Capability of data mining is to build __________ models. |
| A. | retrospective. |
| B. | interrogative. |
| C. | predictive. |
| D. | imperative. |
| Answer» C. predictive. | |
| 291. |
The _________is a process of determining the preference of customers majority. |
| A. | association. |
| B. | preferencing. |
| C. | segmentation. |
| D. | classification. |
| Answer» B. preferencing. | |
| 292. |
Which of the following is a process to humanize the mass of data |
| A. | Visualizing. |
| B. | Segmentation. |
| C. | Discovery. |
| D. | Correction. |
| Answer» A. Visualizing. | |
| 293. |
Strategic value of data mining is___________. |
| A. | cost-sensitive. |
| B. | work-sensitive. |
| C. | time-sensitive. |
| D. | technical-sensitive. |
| Answer» C. time-sensitive. | |
| 294. |
Which of the following is a data store that is a subsidiary of a data warehouse of integrated data |
| A. | Data mart. |
| B. | Data store. |
| C. | Database. |
| D. | Data house. |
| Answer» A. Data mart. | |
| 295. |
_________proposed the approach for data integration issues. |
| A. | Ralph Campbell. |
| B. | Ralph Kimball. |
| C. | John Raphlin. |
| D. | James Gosling. |
| Answer» B. Ralph Kimball. | |
| 296. |
The terms equality and roll up are associated with___________. |
| A. | OLAP. |
| B. | visualization. |
| C. | data mart. |
| D. | decision tree. |
| Answer» C. data mart. | |
| 297. |
Exceptional reporting in data warehousing is otherwise called as_______. |
| A. | exception. |
| B. | alerts. |
| C. | errors. |
| D. | bugs. |
| Answer» B. alerts. | |
| 298. |
_________ is a metadata repository. |
| A. | Prism solution directory manager. |
| B. | CORBA. |
| C. | STUNT. |
| D. | COBWEB. |
| Answer» A. Prism solution directory manager. | |
| 299. |
Which year was the beginning of new generation of machine learning |
| A. | 1880. |
| B. | 1980. |
| C. | 1970. |
| D. | 1960. |
| Answer» C. 1970. | |
| 300. |
The __________ is an expensive process in building an expert system. |
| A. | analysis. |
| B. | study. |
| C. | design. |
| D. | information collection. |
| Answer» D. information collection. | |
Done Studing? Take A Test.
Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.