C and C++ programs and MySQL

How to protect selected cells in vba

2020-02-20T07:36:00.001-08:00

    Please paste these lines in VBA macro.

'To protect the cells
    Worksheets(DestWS).Range("A9:F75").Locked = True ' To lock
    Worksheets(DestWS).Range("G9:t75").Locked = False ' To edit and unlock
    ActiveSheet.Protect

How to use switch case in VBA

2020-02-20T07:33:00.003-08:00

Please paste these lines in VBA macro.

Select Case nowMonth

        Case 1

        Columns("H:K").EntireColumn.Hidden = False

        Case 2
        Columns("L:O").EntireColumn.Hidden = False

        Case 3
        Columns("P:S").EntireColumn.Hidden = False

        Case 4
        Columns("T:W").EntireColumn.Hidden = False

        Case 5
        Columns("X:AA").EntireColumn.Hidden = False

        Case 6
        Columns("AB:AE").EntireColumn.Hidden = False

        Case 7
        Columns("AF:AI").EntireColumn.Hidden = False

        Case 8
        Columns("AJ:AM").EntireColumn.Hidden = False

        Case 9
        Columns("AN:AQ").EntireColumn.Hidden = False

        Case 10
        Columns("AR:AU").EntireColumn.Hidden = False

        Case 11
        Columns("AV:AY").EntireColumn.Hidden = False

        Case 12
        Columns("AZ:BC").EntireColumn.Hidden = False

        End Select

How to get current month details using VBA

2020-02-20T07:32:00.005-08:00

Please paste these lines in VBA macro.

Dim nowMonth As Integer
nowMonth = Month(Now)

How to split string using vba

2020-02-20T07:29:00.001-08:00

Please paste these lines in VBA macro.

Dim Team As String
Dim LArray() As String

Team = "Others Others Others Others"
LArray() = Split(Team, " ") Or
LArray() = Split(Team) ' enough for space , if any other delimitter, please use above syntax

How to get input from user using vba

2020-02-20T07:27:00.004-08:00

Please paste these lines in VBA macro.
Dim Team As String

Team = Trim(InputBox("Give atleast 4 Team members name ", "Hi", "A B C Others"))

How to Freeze and Unfreeze pane using VBA

2020-02-20T07:26:00.001-08:00

Please paste these lines in VBA macro.

    'To Freeze Panes activate
    Worksheets(DestWS).Activate
    ActiveWindow.FreezePanes = False
    Range("H9").Select 'Temp
    ActiveWindow.FreezePanes = True

How to copy one sheet to another using vba

2020-02-20T07:25:00.001-08:00

Please paste these lines in VBA macro.
Sheets(SourceWS).Range("A1:G99").Copy Destination:=Sheets(DestWS).Range("A1") 'Temp
Application.CutCopyMode = False

How to get current workbook worksheet name using vba

2020-02-20T07:24:00.001-08:00

Please paste these lines in VBA macro.

Dim DestWS As String
Dim DestWB As String

DestWB = ThisWorkbook.Name
DestWS = ActiveSheet.Name

How to hide Unhide Rows and Columns using VBA

2020-02-20T07:22:00.001-08:00

Please paste these lines in VBA macro.

Columns("H:BC").EntireColumn.Hidden = False 'Temp
Rows("5:64").EntireRow.Hidden = False 'Temp

How to clear Chart in Excel using VBA

2020-02-20T07:21:00.000-08:00

Please paste these lines in VBA macro.

    Dim chtObj As ChartObject
    For Each chtObj In ActiveSheet.ChartObjects
    chtObj.Delete
    Next

How to clear Excel using VBA

2020-02-20T07:20:00.000-08:00

Please paste these lines in VBA macro.
    Sheets("Sheet1").Cells.Select
    Selection.ClearContents
    Selection.ClearFormats
    Selection.Clear

Quizz II Software Architectures

2017-10-03T04:51:00.004-07:00

Quizz II Software Architectures (S1-17_SSZG653)

227 Over the past few decades the number of software professionals who cut code has been

Select one:

a. is constant

b. none of the given choices

c. increasing

d. reducing

210 Which of the following is incorrect?

Select one:

a. Each layer provides services to the layer “below” and makes use of services provided by the layer “above”

b. Both the choices given

c. None the choices given

d. Layered-style program is divided into an array of modules or layers

203 In MVC pattern (choose the wrong answer)

Select one:

a. Model component informs Controller when underlying data changes

b. Controller helps in taking appropriate action when user provides an input

c. View implements business logic

d. Views get updated when underlying data changes

211 Which statement best describes the relationship between application, server, and client in a multitenancy environment?

Select one:

a. Single instance of software running on a server and serves one client.

b. Single instance of software running on a server and serves multiple clients.

c. Multiple instances of software running on a server and serves multiple clients.

d. Multiple instances of software running on multiple servers and serves one client.

214 What is one benefit of a cloud computing environment?

Select one:

a. It minimizes network traffic to the virtual machines.

b. It maximizes server utilization by implementing automated provisioning

c. It automatically transforms physical servers into virtual machines

d. It improves server performance.

216 In MVC, the view is made with ___________

Select one:

a. All the Above

b. Java Script

c. HTML

d. CSS

226 SLOC is a measure of

Select one:

a. Money spent on a project

b. Effort put into a project

c. Volume of work in a project

d. Labour deployed on a project

212 An enterprise needs highly controlled storage and access to their databases as well as managing the infrastructure for web front ends and other applications. They have a large existing IT infrastructure and they are continually expanding the capabilities. Which cloud computing model will satisfy all their current needs and enable them to reduce cost?

Select one:

a. private cloud

b. hybrid cloud

c. public cloud

d. internal cloud

219 In a Microkernel Architecture Adapter does not interact directly with:

Select one:

a. Internal Server

b. Microkernel

c. External Server

d. Client

217 Which of the following architectural patterns should be employed in virtually every software system

Select one:

a. Client Server

b. Layered

c. Pipe & Filter

d. All the given choices

Reflection Pattern is a device to implement the following tactics

Select one:

a. Defer Binding: Use runtime registration

b. Defer Binding: Runtime binding

c. Localize Change: Factor common services

d. Localize Change: Increase semantic coherence

222 Dependency Inversion Principal implies.

Select one:

a. A natural way of implementing such structures would be to write low level classes and the complex high level classes without any interdependency.

b. A natural way of implementing such structures would be to write low level classes and the complex high level classes taking care of the mutual interdependency.

c. A way of implementing such structures would be to write high level classes and once we have them to write the complex low level classes.

d. A natural way of implementing such structures would be to write low level classes and once we have them to write the complex high level classes.

209 Division of Responsibilities between PM and Architect (ignore reporting relationship between them)

Select one:

a. Mutually dependent

b. PM depends on Architect

c. No Overlap and independency

d. Architect depends on PM

204 In a Client server pattern (choose the wrong answer)

Select one:

a. Server processes requests and sends response to client

b. Client Server communication is synchronous

c. Server send requests to the Client for queries.

d. A server can be used by many clients

206 Quality attributes that are important in a cloud

Select one:

a. Security

b. Performance

c. Availability

d. All the Given Options

223 Substitution Principle of Object Oriented Design is named after

Select one:

a. Barbara Liskov

b. Bob Martin

c. Len Bass

d. Brady Booch

201 In a typical layered system (choose the wrong answer)

Select one:

a. A layer contains several modules

b. A layer invokes services provided by layer above

c. Implementation of one layer can be changed without affecting other layers

d. A layer invokes services provided by layer below

202 Broker

Select one:

a. All of the given options

b. Provides services such as fault tolerance

c. Can be a single point of failure

d. Adds a layer of indirection

208 Which of the statements is (are) true?

Select one:

a. Hypervisor Manages Virtualization

b. All the given options

c. hypervisor allows you to have several virtual machines all working optimally on a single piece of computer hardware

d. Hypervisor is an operating system for virtualized systems

205 _______ provides virtual machines, virtual storage, virtual infrastructure, and other hardware assets

Select one:

a. All the given choices

b. IAAS

c. SAAS

d. PAAS

221 One of the following is not a Mud and Structure Pattern. Which one?

Select one:

a. Pipes and Filters

b. Client Server

c. Blackboard

d. Layers

218 Microsoft dot net framework would be an example of

Select one:

a. Blackboard Pattern

b. Microkernel Pattern

c. Adaptor Pattern

d. Broker Pattern

224 Which of these is not one of minimal OS services that are implemented by primitives and system calls in the Microkernel approach?

Select one:

a. Mhread Management

b. Inter-process Communication Management

c. Layout Management

d. Address Spaces Management

207 Which statement best describes the relationship between application, server, and client in a multitenancy environment?

Select one:

a. Single instance of software running on a server and serves multiple clients.

b. Single instance of software running on a server and serves one client.

c. Multiple instances of software running on multiple servers and serves one client

d. Multiple instances of software running on a server and serves multiple clients.

225 Service-Oriented Architecture provides independent of (mark the odd one out)

Select one:

a. Vendors

b. Products

c. Technologies

d. Operating Systems

Data Warehouse Answer

2017-09-28T06:05:00.002-07:00

Multiple Choice Questions.
1. __________ 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: B
2. The data Warehouse is__________.
A. read only.
B. write only.
C. read write only.
D. none.
ANSWER: A
3. Expansion for DSS in DW is__________.
A. Decision Support system.
B. Decision Single System.
C. Data Storable System.
D. Data Support System.
ANSWER: A
4. 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: D
5. The time horizon in Data warehouse is usually __________.
A. 1-2 years.
B. 3-4years.
C. 5-6 years.
D. 5-10 years.
ANSWER: D
6. The data is stored, retrieved & updated in ____________.
A. OLAP.
B. OLTP.
C. SMTP.
D. FTP.
ANSWER: B
7. __________describes the data contained in the data warehouse.
A. Relational data.
B. Operational data.
C. Metadata.
D. Informational data.
ANSWER: C
8. ____________predicts future trends & behaviors, allowing business managers to make proactive,
knowledge-driven decisions.
A. Data warehouse.
B. Data mining.
C. Datamarts.
D. Metadata.
ANSWER: B
9. __________ 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: B
10. ________________ is the specialized data warehouse database.
A. Oracle.
B. DBZ.
C. Informix.
D. Redbrick.
ANSWER: D
11. ________________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: C
12. ________________ 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: B
13. _________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: A
14. ______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: A
15. _____________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: A
16. . ______________databases are owned by particular departments or business groups.
A. Informational.
B. Operational.
C. Both informational and operational.
D. Flat.
ANSWER: B
17. The star schema is composed of __________ fact table.
A. one.
B. two.
C. three.
D. four.
ANSWER: A
18. The time horizon in operational environment is ___________.
A. 30-60 days.
B. 60-90 days.
C. 90-120 days.
D. 120-150 days.
ANSWER: B
19. The key used in operational environment may not have an element of__________.
A. time.
B. cost.
C. frequency.
D. quality.
ANSWER: A
20. Data can be updated in _____environment.
A. data warehouse.
B. data mining.
C. operational.
D. informational.
ANSWER: C
21. Record cannot be updated in _____________.
A. OLTP
B. files
C. RDBMS
D. data warehouse
ANSWER: D
22. The source of all data warehouse data is the____________.
A. operational environment.
B. informal environment.
C. formal environment.
D. technology environment.
ANSWER: A
23. Data warehouse contains_____________data that is never found in the operational environment.
A. normalized.
B. informational.
C. summary.
D. denormalized.
ANSWER: C
24. The modern CASE tools belong to _______ category.
A. a. analysis.
B. b.Development
C. c.Coding
D. d.Delivery
ANSWER: A
25. 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: D
26. Detail data in single fact table is otherwise known as__________.
A. monoatomic data.
B. diatomic data.
C. atomic data.
D. multiatomic data.
ANSWER: C
27. _______test is used in an online transactional processing environment.
A. MEGA.
B. MICRO.
C. MACRO.
D. ACID.
ANSWER: D
28. ___________ is a good alternative to the star schema.
A. Star schema.
B. Snowflake schema.
C. Fact constellation.
D. Star-snowflake schema.
ANSWER: C
29. The biggest drawback of the level indicator in the classic star-schema is that it limits_________.
A. quantify.
B. qualify.
C. flexibility.
D. ability.
ANSWER: C
30. A data warehouse is _____________.
A. updated by end users.
B. contains numerous naming conventions and formats
C. organized around important subject areas.
D. contains only current data.
ANSWER: C
31. An operational system is _____________.
A. used to run the business in real time and is based on historical data.
B. used to run the business in real time and is based on current data.
C. used to support decision making and is based on current data.
D. used to support decision making and is based on historical data.
ANSWER: B
32. The generic two-level data warehouse architecture includes __________.
A. at least one data mart.
B. data that can extracted from numerous internal and external sources.
C. near real-time updates.
D. far real-time updates.
ANSWER: C
33. The active data warehouse architecture includes __________
A. at least one data mart.
B. data that can extracted from numerous internal and external sources.
C. near real-time updates.
D. all of the above.
ANSWER: D
34. 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: B
35. Transient data is _____________.
A. data in which changes to existing records cause the previous version of the records to be eliminated.
B. data in which changes to existing records do not cause the previous version of the records to be
eliminated.
C. data that are never altered or deleted once they have been added.
D. data that are never deleted once they have been added.
ANSWER: A
36. 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: B
37. Data scrubbing is _____________.
A. a process to reject data from the data warehouse and to create the necessary indexes.
B. a process to load the data in the data warehouse and to create the necessary indexes.
C. a process to upgrade the quality of data after it is moved into a data warehouse.
D. a process to upgrade the quality of data before it is moved into a data warehouse
ANSWER: D
38. The load and index is ______________.
A. a process to reject data from the data warehouse and to create the necessary indexes.
B. a process to load the data in the data warehouse and to create the necessary indexes.
C. a process to upgrade the quality of data after it is moved into a data warehouse.
D. a process to upgrade the quality of data before it is moved into a data warehouse.
ANSWER: B
39. Data transformation includes __________.
A. a process to change data from a detailed level to a summary level.
B. a process to change data from a summary level to a detailed level.
C. joining data from one source into various sources of data.
D. separating data from one source into various sources of data.
ANSWER: A
40. ____________ is called a multifield transformation.
A. Converting data from one field into multiple fields.
B. Converting data from fields into field.
C. Converting data from double fields into multiple fields.
D. Converting data from one field to one field.
ANSWER: A
41. The type of relationship in star schema is __________________.
A. many-to-many.
B. one-to-one.
C. one-to-many.
D. many-to-one.
ANSWER: C
42. Fact tables are ___________.
A. completely demoralized.
B. partially demoralized.
C. completely normalized.
D. partially normalized.
ANSWER: C
43. _______________ is the goal of data mining.
A. To explain some observed event or condition.
B. To confirm that data exists.
C. To analyze data for expected relationships.
D. To create a new data warehouse.
ANSWER: A
44. Business Intelligence and data warehousing is used for ________.
A. Forecasting.
B. Data Mining.
C. Analysis of large volumes of product sales data.
D. All of the above.
ANSWER: D
45. 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
46. 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
47. ________ are responsible for running queries and reports against data warehouse tables.
A. Hardware.
B. Software.
C. End users.
D. Middle ware.
ANSWER: C
48. Query tool is meant for __________.
A. data acquisition.
B. information delivery.
C. information exchange.
D. communication.
ANSWER: A
49. Classification rules are extracted from _____________.
A. root node.
B. decision tree.
C. siblings.
D. branches.
ANSWER: B
50. Dimensionality reduction reduces the data set size by removing ____________.
A. relevant attributes.
B. irrelevant attributes.
C. derived attributes.
D. composite attributes.
ANSWER: B
51. ___________ is a method of incremental conceptual clustering.
A. CORBA.
B. OLAP.
C. COBWEB.
D. STING.
ANSWER: C
52. 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 independence.
ANSWER: A
53. The main organizational justification for implementing a data warehouse is to provide ______.
A. cheaper ways of handling transportation.
B. decision support.
C. storing large volume of data.
D. access to data.
ANSWER: C
54. Multidimensional database is otherwise known as____________.
A. RDBMS
B. DBMS
C. EXTENDED RDBMS
D. EXTENDED DBMS
ANSWER: B
55. Data warehouse architecture is based on ______________.
A. DBMS.
B. RDBMS.
C. Sybase.
D. SQL Server.
ANSWER: B
56. Source data from the warehouse comes from _______________.
A. ODS.
B. TDS.
C. MDDB.
D. ORDBMS.
ANSWER: A
57. ________________ is a data transformation process.
A. Comparison.
B. Projection.
C. Selection.
D. Filtering.
ANSWER: D
58. The technology area associated with CRM is _______________.
A. specialization.
B. generalization.
C. personalization.
D. summarization.
ANSWER: C
59. SMP stands for _______________.
A. Symmetric Multiprocessor.
B. Symmetric Multiprogramming.
C. Symmetric Metaprogramming.
D. Symmetric Microprogramming.
ANSWER: A
60. __________ are 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
61. __________ are 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
62. MDDB stands for ___________.
A. multiple data doubling.
B. multidimensional databases.
C. multiple double dimension.
D. multi-dimension doubling.
ANSWER: B
63. ______________ is data about data.
A. Metadata.
B. Microdata.
C. Minidata.
D. Multidata.
ANSWER: A
64. ___________ is an important functional component of the metadata.
A. Digital directory.
B. Repository.
C. Information directory.
D. Data dictionary.
ANSWER: C
65. EIS stands for ______________.
A. Extended interface system.
B. Executive interface system.
C. Executive information system.
D. Extendable information system.
ANSWER: C
66. ___________ is data collected from natural systems.
A. MRI scan.
B. ODS data.
C. Statistical data.
D. Historical data.
ANSWER: A
67. _______________ is an example of application development environments.
A. Visual Basic.
B. Oracle.
C. Sybase.
D. SQL Server.
ANSWER: A
68. The term that is not associated with data cleaning process is ______.
A. domain consistency.
B. deduplication.
C. disambiguation.
D. segmentation.
ANSWER: D
69. ____________ are some popular OLAP tools.
A. Metacube, Informix.
B. Oracle Express, Essbase.
C. HOLAP.
D. MOLAP.
ANSWER: A
70. Capability of data mining is to build ___________ models.
A. retrospective.
B. interrogative.
C. predictive.
D. imperative.
ANSWER: C
71. _____________ is a process of determining the preference of customer's majority.
A. Association.
B. Preferencing.
C. Segmentation.
D. Classification.
ANSWER: B
72. Strategic value of data mining is ______________.
A. cost-sensitive.
B. work-sensitive.
C. time-sensitive.
D. technical-sensitive.
ANSWER: C
73. ____________ proposed the approach for data integration issues.
A. Ralph Campbell.
B. Ralph Kimball.
C. John Raphlin.
D. James Gosling.
ANSWER: B
74. The terms equality and roll up are associated with ____________.
A. OLAP.
B. visualization.
C. data mart.
D. decision tree.
ANSWER: C
75. Exceptional reporting in data warehousing is otherwise called as __________.
A. exception.
B. alerts.
C. errors.
D. bugs.
ANSWER: B
76. ____________ is a metadata repository.
A. Prism solution directory manager.
B. CORBA.
C. STUNT.
D. COBWEB.
ANSWER: A
77. ________________ is an expensive process in building an expert system.
A. Analysis.
B. Study.
C. Design.
D. Information collection.
ANSWER: D
78. The full form of KDD is _________.
A. Knowledge database.
B. Knowledge discovery in database.
C. Knowledge data house.
D. Knowledge data definition.
ANSWER: B
79. The first International conference on KDD was held in the year _____________.
A. 1996.
B. 1997.
C. 1995.
D. 1994.
ANSWER: C
80. Removing duplicate records is a process called _____________.
A. recovery.
B. data cleaning.
C. data cleansing.
D. data pruning.
ANSWER: B
81. ____________ contains information that gives users an easy-to-understand perspective of the
information stored in the data warehouse.
A. Business metadata.
B. Technical metadata.
C. Operational metadata.
D. Financial metadata.
ANSWER: A
82. _______________ helps to integrate, maintain and view the contents of the data warehousing system.
A. Business directory.
B. Information directory.
C. Data dictionary.
D. Database.
ANSWER: B
83. Discovery of cross-sales opportunities is called ________________.
A. segmentation.
B. visualization.
C. correction.
D. association.
ANSWER: D
84. Data marts that incorporate data mining tools to extract sets of data are called ______.
A. independent data mart.
B. dependent data marts.
C. intra-entry data mart.
D. inter-entry data mart.
ANSWER: B
85. ____________ can generate programs itself, enabling it to carry out new tasks.
A. Automated system.
B. Decision making system.
C. Self-learning system.
D. Productivity system.
ANSWER: D
86. The power of self-learning system lies in __________.
A. cost.
B. speed.
C. accuracy.
D. simplicity.
ANSWER: C
87. Building the informational database is done with the help of _______.
A. transformation or propagation tools.
B. transformation tools only.
C. propagation tools only.
D. extraction tools.
ANSWER: A
88. How many components are there in a data warehouse?
A. two.
B. three.
C. four.
D. five.
ANSWER: D
89. Which of the following is not a component of a data warehouse?
A. Metadata.
B. Current detail data.
C. Lightly summarized data.
D. Component Key.
ANSWER: D
90. ________ is data that is distilled from the low level of detail found at the current detailed leve.
A. Highly summarized data.
B. Lightly summarized data.
C. Metadata.
D. Older detail data.
ANSWER: B
91. Highly summarized data is _______.
A. compact and easily accessible.
B. compact and expensive.
C. compact and hardly accessible.
D. compact.
ANSWER: A
92. A directory to help the DSS analyst locate the contents of the data warehouse is seen in ______.
A. Current detail data.
B. Lightly summarized data.
C. Metadata.
D. Older detail data.
ANSWER: C
93. Metadata contains atleast _________.
A. the structure of the data.
B. the algorithms used for summarization.
C. the mapping from the operational environment to the data warehouse.
D. all of the above.
ANSWER: D
94. Which of the following is not a old detail storage medium?
A. Phot Optical Storage.
B. RAID.
C. Microfinche.
D. Pen drive.
ANSWER: D
95. The data from the operational environment enter _______ of data warehouse.
A. Current detail data.
B. Older detail data.
C. Lightly summarized data.
D. Highly summarized data.
ANSWER: A
96. The data in current detail level resides till ________ event occurs.
A. purge.
B. summarization.
C. archieved.
D. all of the above.
ANSWER: D
97. The dimension tables describe the _________.
A. entities.
B. facts.
C. keys.
D. units of measures.
ANSWER: B
98. The granularity of the fact is the _____ of detail at which it is recorded.
A. transformation.
B. summarization.
C. level.
D. transformation and summarization.
ANSWER: C
99. 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: B
100. 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: C
101. ___________ of data means that the attributes within a given entity are fully dependent on the entire
primary key of the entity.
A. Additivity.
B. Granularity.
C. Functional dependency.
D. Dimensionality.
ANSWER: C
102. A fact is said to be fully additive if ___________.
A. it is additive over every dimension of its dimensionality.
B. additive over atleast one but not all of the dimensions.
C. not additive over any dimension.
D. None of the above.
ANSWER: A
103. A fact is said to be partially additive if ___________.
A. it is additive over every dimension of its dimensionality.
B. additive over atleast one but not all of the dimensions.
C. not additive over any dimension.
D. None of the above.
ANSWER: B
104. A fact is said to be non-additive if ___________.
A. it is additive over every dimension of its dimensionality.
B. additive over atleast one but not all of the dimensions.
C. not additive over any dimension.
D. None of the above.
ANSWER: C
105. Non-additive measures can often combined with additive measures to create new _________.
A. additive measures.
B. non-additive measures.
C. partially additive.
D. All of the above.
ANSWER: A
106. A fact representing cumulative sales units over a day at a store for a product is a _________.
A. additive fact.
B. fully additive fact.
C. partially additive fact.
D. non-additive fact.
ANSWER: B
107. ____________ of data means that the attributes within a given entity are fully dependent on the entire
primary key of the entity.
A. Additivity.
B. Granularity.
C. Functional Dependency.
D. Dependency.
ANSWER: C
108. Which of the following is the other name of Data mining?
A. Exploratory data analysis.
B. Data driven discovery.
C. Deductive learning.
D. All of the above.
ANSWER: D
109. Which of the following is a predictive model?
A. Clustering.
B. Regression.
C. Summarization.
D. Association rules.
ANSWER: B
110. Which of the following is a descriptive model?
A. Classification.
B. Regression.
C. Sequence discovery.
D. Association rules.
ANSWER: C
111. A ___________ model identifies patterns or relationships.
A. Descriptive.
B. Predictive.
C. Regression.
D. Time series analysis.
ANSWER: A
112. A predictive model makes use of ________.
A. current data.
B. historical data.
C. both current and historical data.
D. assumptions.
ANSWER: B
113. ____________ maps data into predefined groups.
A. Regression.
B. Time series analysis
C. Prediction.
D. Classification.
ANSWER: D
114. __________ is used to map a data item to a real valued prediction variable.
A. Regression.
B. Time series analysis.
C. Prediction.
D. Classification.
ANSWER: B
115. In ____________, the value of an attribute is examined as it varies over time.
A. Regression.
B. Time series analysis.
C. Sequence discovery.
D. Prediction.
ANSWER: B
116. In ________ the groups are not predefined.
A. Association rules.
B. Summarization.
C. Clustering.
D. Prediction.
ANSWER: C
117. Link Analysis is otherwise called as ___________.
A. affinity analysis.
B. association rules.
C. both A & B.
D. Prediction.
ANSWER: C
118. _________ is a the input to KDD.
A. Data.
B. Information.
C. Query.
D. Process.
ANSWER: A
119. The output of KDD is __________.
A. Data.
B. Information.
C. Query.
D. Useful information.
ANSWER: D
120. The KDD process consists of ________ steps.
A. three.
B. four.
C. five.
D. six.
ANSWER: C
121. Treating incorrect or missing data is called as ___________.
A. selection.
B. preprocessing.
C. transformation.
D. interpretation.
ANSWER: B
122. Converting data from different sources into a common format for processing is called as ________.
A. selection.
B. preprocessing.
C. transformation.
D. interpretation.
ANSWER: C
123. Various visualization techniques are used in ___________ step of KDD.
A. selection.
B. transformaion.
C. data mining.
D. interpretation.
ANSWER: D
124. Extreme values that occur infrequently are called as _________.
A. outliers.
B. rare values.
C. dimensionality reduction.
D. All of the above.
ANSWER: A
125. Box plot and scatter diagram techniques are _______.
A. Graphical.
B. Geometric.
C. Icon-based.
D. Pixel-based.
ANSWER: B
126. __________ is used to proceed from very specific knowledge to more general information.
A. Induction.
B. Compression.
C. Approximation.
D. Substitution.
ANSWER: A
127. Describing some characteristics of a set of data by a general model is viewed as ____________
A. Induction.
B. Compression.
C. Approximation.
D. Summarization.
ANSWER: B
128. _____________ helps to uncover hidden information about the data.
A. Induction.
B. Compression.
C. Approximation.
D. Summarization.
ANSWER: C
129. _______ are needed to identify training data and desired results.
A. Programmers.
B. Designers.
C. Users.
D. Administrators.
ANSWER: C
130. Overfitting occurs when a model _________.
A. does fit in future states.
B. does not fit in future states.
C. does fit in current state.
D. does not fit in current state.
ANSWER: B
131. The problem of dimensionality curse involves ___________.
A. the use of some attributes may interfere with the correct completion of a data mining task.
B. the use of some attributes may simply increase the overall complexity.
C. some may decrease the efficiency of the algorithm.
D. All of the above.
ANSWER: D
132. Incorrect or invalid data is known as _________.
A. changing data.
B. noisy data.
C. outliers.
D. missing data.
ANSWER: B
133. ROI is an acronym of ________.
A. Return on Investment.
B. Return on Information.
C. Repetition of Information.
D. Runtime of Instruction
ANSWER: A
134. The ____________ of data could result in the disclosure of information that is deemed to be
confidential.
A. authorized use.
B. unauthorized use.
C. authenticated use.
D. unauthenticated use.
ANSWER: B
135. ___________ data are noisy and have many missing attribute values.
A. Preprocessed.
B. Cleaned.
C. Real-world.
D. Transformed.
ANSWER: C
136. The rise of DBMS occurred in early ___________.
A. 1950's.
B. 1960's
C. 1970's
D. 1980's.
ANSWER: C
137. SQL stand for _________.
A. Standard Query Language.
B. Structured Query Language.
C. Standard Quick List.
D. Structured Query list.
ANSWER: B
138. Which of the following is not a data mining metric?
A. Space complexity.
B. Time complexity.
C. ROI.
D. All of the above.
ANSWER: D
139. Reducing the number of attributes to solve the high dimensionality problem is called as ________.
A. dimensionality curse.
B. dimensionality reduction.
C. cleaning.
D. Overfitting.
ANSWER: B
140. Data that are not of interest to the data mining task is called as ______.
A. missing data.
B. changing data.
C. irrelevant data.
D. noisy data.
ANSWER: C
141. ______ are effective tools to attack the scalability problem.
A. Sampling.
B. Parallelization
C. Both A & B.
D. None of the above.
ANSWER: C
142. Market-basket problem was formulated by __________.
A. Agrawal et al.
B. Steve et al.
C. Toda et al.
D. Simon et al.
ANSWER: A
143. Data mining helps in __________.
A. inventory management.
B. sales promotion strategies.
C. marketing strategies.
D. All of the above.
ANSWER: D
144. The proportion of transaction supporting X in T is called _________.
A. confidence.
B. support.
C. support count.
D. All of the above.
ANSWER: B
145. The absolute number of transactions supporting X in T is called ___________.
A. confidence.
B. support.
C. support count.
D. None of the above.
ANSWER: C
146. The value that says that transactions in D that support X also support Y is called ______________.
A. confidence.
B. support.
C. support count.
D. None of the above.
ANSWER: A
147. If T consist of 500000 transactions, 20000 transaction contain bread, 30000 transaction contain jam,
10000 transaction contain both bread and jam. Then the support of bread and jam is _______.
A. 2%
B. 20%
C. 3%
D. 30%
ANSWER: A
148. 7 If T consist of 500000 transactions, 20000 transaction contain bread, 30000 transaction contain jam,
10000 transaction contain both bread and jam. Then the confidence of buying bread with jam is _______.
A. 33.33%
B. 66.66%
C. 45%
D. 50%
ANSWER: D
149. The left hand side of an association rule is called __________.
A. consequent.
B. onset.
C. antecedent.
D. precedent.
ANSWER: C
150. The right hand side of an association rule is called _____.
A. consequent.
B. onset.
C. antecedent.
D. precedent.
ANSWER: A
151. Which of the following is not a desirable feature of any efficient algorithm?
A. to reduce number of input operations.
B. to reduce number of output operations.
C. to be efficient in computing.
D. to have maximal code length.
ANSWER: D
152. All set of items whose support is greater than the user-specified minimum support are called as
_____________.
A. border set.
B. frequent set.
C. maximal frequent set.
D. lattice.
ANSWER: B
153. 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: A
154. Any subset of a frequent set is a frequent set. This is ___________.
A. Upward closure property.
B. Downward closure property.
C. Maximal frequent set.
D. Border set.
ANSWER: B
155. Any superset of an infrequent set is an infrequent set. This is _______.
A. Maximal frequent set.
B. Border set.
C. Upward closure property.
D. Downward closure property.
ANSWER: C
156. If an itemset is not a frequent set and no superset of this is a frequent set, then it is _______.
A. Maximal frequent set
B. Border set.
C. Upward closure property.
D. Downward closure property.
ANSWER: B
157. A priori algorithm is otherwise called as __________.
A. width-wise algorithm.
B. level-wise algorithm.
C. pincer-search algorithm.
D. FP growth algorithm.
ANSWER: B
158. The A Priori algorithm is a ___________.
A. top-down search.
B. breadth first search.
C. depth first search.
D. bottom-up search.
ANSWER: D
159. The first phase of A Priori algorithm is _______.
A. Candidate generation.
B. Itemset generation.
C. Pruning.
D. Partitioning.
ANSWER: A
160. The second phaase of A Priori algorithm is ____________.
A. Candidate generation.
B. Itemset generation.
C. Pruning.
D. Partitioning.
ANSWER: C
161. The _______ step eliminates the extensions of (k-1)-itemsets which are not found to be frequent, from
being considered for counting support.
A. Candidate generation.
B. Pruning.
C. Partitioning.
D. Itemset eliminations.
ANSWER: B
162. The a priori frequent itemset discovery algorithm moves _______ in the lattice.
A. upward.
B. downward.
C. breadthwise.
D. both upward and downward.
ANSWER: A
163. After the pruning of a priori algorithm, _______ will remain.
A. Only candidate set.
B. No candidate set.
C. Only border set.
D. No border set.
ANSWER: B
164. The number of iterations in a priori ___________.
A. increases with the size of the maximum frequent set.
B. decreases with increase in size of the maximum frequent set.
C. increases with the size of the data.
D. decreases with the increase in size of the data.
ANSWER: A
165. MFCS is the acronym of _____.
A. Maximum Frequency Control Set.
B. Minimal Frequency Control Set.
C. Maximal Frequent Candidate Set.
D. Minimal Frequent Candidate Set.
ANSWER: C
166. Dynamuc Itemset Counting Algorithm was proposed by ____.
A. Bin et al.
B. Argawal et at.
C. Toda et al.
D. Simon et at.
ANSWER: A
167. Itemsets in the ______ category of structures have a counter and the stop number with them.
A. Dashed.
B. Circle.
C. Box.
D. Solid.
ANSWER: A
168. The itemsets in the _______category structures are not subjected to any counting.
A. Dashes.
B. Box.
C. Solid.
D. Circle.
ANSWER: C
169. Certain itemsets in the dashed circle whose support count reach support value during an iteration
move into the ______.
A. Dashed box.
B. Solid circle.
C. Solid box.
D. None of the above.
ANSWER: A
170. Certain itemsets enter afresh into the system and get into the _______, which are essentially the
supersets of the itemsets that move from the dashed circle to the dashed box.
A. Dashed box.
B. Solid circle.
C. Solid box.
D. Dashed circle.
ANSWER: D
171. The itemsets that have completed on full pass move from dashed circle to ________.
A. Dashed box.
B. Solid circle.
C. Solid box.
D. None of the above.
ANSWER: B
172. The FP-growth algorithm has ________ phases.
A. one.
B. two.
C. three.
D. four.
ANSWER: B
173. A frequent pattern tree is a tree structure consisting of ________.
A. an item-prefix-tree.
B. a frequent-item-header table.
C. a frequent-item-node.
D. both A & B.
ANSWER: D
174. The non-root node of item-prefix-tree consists of ________ fields.
A. two.
B. three.
C. four.
D. five.
ANSWER: B
175. The frequent-item-header-table consists of __________ fields.
A. only one.
B. two.
C. three.
D. four.
ANSWER: B
176. The paths from root node to the nodes labelled 'a' are called __________.
A. transformed prefix path.
B. suffix subpath.
C. transformed suffix path.
D. prefix subpath.
ANSWER: D
177. The transformed prefix paths of a node 'a' form a truncated database of pattern which co-occur with a
is called _______.
A. suffix path.
B. FP-tree.
C. conditional pattern base.
D. prefix path.
ANSWER: C
178. The goal of _____ is to discover both the dense and sparse regions of a data set.
A. Association rule.
B. Classification.
C. Clustering.
D. Genetic Algorithm.
ANSWER: C
179. Which of the following is a clustering algorithm?
A. A priori.
B. CLARA.
C. Pincer-Search.
D. FP-growth.
ANSWER: B
180. _______ clustering technique start with as many clusters as there are records, with each cluster having
only one record.
A. Agglomerative.
B. divisive.
C. Partition.
D. Numeric.
ANSWER: A
181. __________ clustering techniques starts with all records in one cluster and then try to split that cluster
into small pieces.
A. Agglomerative.
B. Divisive.
C. Partition.
D. Numeric.
ANSWER: B
182. Which of the following is a data set in the popular UCI machine-learning repository?
A. CLARA.
B. CACTUS.
C. STIRR.
D. MUSHROOM.
ANSWER: D
183. In ________ algorithm each cluster is represented by the center of gravity of the cluster.
A. k-medoid.
B. k-means.
C. STIRR.
D. ROCK.
ANSWER: B
184. In ___________ each cluster is represented by one of the objects of the cluster located near the
center.
A. k-medoid.
B. k-means.
C. STIRR.
D. ROCK.
ANSWER: A
185. Pick out a k-medoid algoithm.
A. DBSCAN.
B. BIRCH.
C. PAM.
D. CURE.
ANSWER: C
186. Pick out a hierarchical clustering algorithm.
A. DBSCAN
B. BIRCH.
C. PAM.
D. CURE.
ANSWER: A
187. CLARANS stands for _______.
A. CLARA Net Server.
B. Clustering Large Application RAnge Network Search.
C. Clustering Large Applications based on RANdomized Search.
D. CLustering Application Randomized Search.
ANSWER: C
188. BIRCH is a ________.
A. agglomerative clustering algorithm.
B. hierarchical algorithm.
C. hierarchical-agglomerative algorithm.
D. divisive.
ANSWER: C
189. The cluster features of different subclusters are maintained in a tree called ___________.
A. CF tree.
B. FP tree.
C. FP growth tree.
D. B tree.
ANSWER: A
190. The ________ algorithm is based on the observation that the frequent sets are normally very few in
number compared to the set of all itemsets.
A. A priori.
B. Clustering.
C. Association rule.
D. Partition.
ANSWER: D
191. The partition algorithm uses _______ scans of the databases to discover all frequent sets.
A. two.
B. four.
C. six.
D. eight.
ANSWER: A
192. The basic idea of the apriori algorithm is to generate________ item sets of a particular size & scans
the database.
A. candidate.
B. primary.
C. secondary.
D. superkey.
ANSWER: A
193. ________is the most well known association rule algorithm and is used in most commercial products.
A. Apriori algorithm.
B. Partition algorithm.
C. Distributed algorithm.
D. Pincer-search algorithm.
ANSWER: A
194. 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: B
195. The basic partition algorithm reduces the number of database scans to ________ & divides it into
partitions.
A. one.
B. two.
C. three.
D. four.
ANSWER: B
196. ___________and prediction may be viewed as types of classification.
A. Decision.
B. Verification.
C. Estimation.
D. Illustration.
ANSWER: C
197. ___________can be thought of as classifying an attribute value into one of a set of possible classes.
A. Estimation.
B. Prediction.
C. Identification.
D. Clarification.
ANSWER: B
198. Prediction can be viewed as forecasting a_________value.
A. non-continuous.
B. constant.
C. continuous.
D. variable.
ANSWER: C
199. _________data consists of sample input data as well as the classification assignment for the data.
A. Missing.
B. Measuring.
C. Non-training.
D. Training.
ANSWER: D
200. Rule based classification algorithms generate ______ rule to perform the classification.
A. if-then.
B. while.
C. do while.
D. switch.
ANSWER: A
201. ____________ are a different paradigm for computing which draws its inspiration from neuroscience.
A. Computer networks.
B. Neural networks.
C. Mobile networks.
D. Artificial networks.
ANSWER: B
202. The human brain consists of a network of ___________.
A. neurons.
B. cells.
C. Tissue.
D. muscles.
ANSWER: A
203. Each neuron is made up of a number of nerve fibres called _____________.
A. electrons.
B. molecules.
C. atoms.
D. dendrites.
ANSWER: D
204. The ___________is a long, single fibre that originates from the cell body.
A. axon.
B. neuron.
C. dendrites.
D. strands.
ANSWER: A
205. A single axon makes ___________ of synapses with other neurons.
A. ones.
B. hundreds.
C. thousands.
D. millions.
ANSWER: C
206. _____________ is a complex chemical process in neural networks.
A. Receiving process.
B. Sending process.
C. Transmission process.
D. Switching process.
ANSWER: C
207. _________ is the connectivity of the neuron that give simple devices their real power. a. b. c. d.
A. Water.
B. Air.
C. Power.
D. Fire.
ANSWER: D
208. __________ are highly simplified models of biological neurons.
A. Artificial neurons.
B. Computational neurons.
C. Biological neurons.
D. Technological neurons.
ANSWER: A
209. The biological neuron's _________ is a continuous function rather than a step function.
A. read.
B. write.
C. output.
D. input.
ANSWER: C
210. The threshold function is replaced by continuous functions called ________ functions.
A. activation.
B. deactivation.
C. dynamic.
D. standard.
ANSWER: A
211. The sigmoid function also knows as __________functions.
A. regression.
B. logistic.
C. probability.
D. neural.
ANSWER: B
212. MLP stands for ______________________.
A. mono layer perception.
B. many layer perception.
C. more layer perception.
D. multi layer perception.
ANSWER: D
213. In a feed- forward networks, the conncetions between layers are ___________ from input to output.
A. bidirectional.
B. unidirectional.
C. multidirectional.
D. directional.
ANSWER: B
214. The network topology is constrained to be __________________.
A. feedforward.
B. feedbackward.
C. feed free.
D. feed busy.
ANSWER: A
215. RBF stands for _____________.
A. Radial basis function.
B. Radial bio function.
C. Radial big function.
D. Radial bi function.
ANSWER: A
216. RBF have only _______________ hidden layer.
A. four.
B. three.
C. two.
D. one.
ANSWER: D
217. RBF hidden layer units have a receptive field which has a ____________; that is, a particular input
value at which they have a maximal output.
A. top.
B. bottom.
C. centre.
D. border.
ANSWER: C
218. ___________ training may be used when a clear link between input data sets and target output values
does not exist.
A. Competitive.
B. Perception.
C. Supervised.
D. Unsupervised.
ANSWER: D
219. ___________ employs the supervised mode of learning.
A. RBF.
B. MLP.
C. MLP & RBF.
D. ANN.
ANSWER: C
220. ________________ design involves deciding on their centres and the sharpness of their Gaussians.
A. DR.
B. AND.
C. XOR.
D. RBF.
ANSWER: D
221. ___________ is the most widely applied neural network technique.
A. ABC.
B. PLM.
C. LMP.
D. MLP.
ANSWER: D
222. SOM is an acronym of _______________.
A. self-organizing map.
B. self origin map.
C. single organizing map.
D. simple origin map.
ANSWER: A
223. ____________ is one of the most popular models in the unsupervised framework.
A. SOM.
B. SAM.
C. OSM.
D. MSO.
ANSWER: A
224. The actual amount of reduction at each learning step may be guided by _________.
A. learning cost.
B. learning level.
C. learning rate.
D. learning time.
ANSWER: C
225. The SOM was a neural network model developed by ________.
A. Simon King.
B. Teuvokohonen.
C. Tomoki Toda.
D. Julia.
ANSWER: B
226. SOM was developed during ____________.
A. 1970-80.
B. 1980-90.
C. 1990 -60.
D. 1979 -82.
ANSWER: D
227. Investment analysis used in neural networks is to predict the movement of _________ from previous
data.
A. engines.
B. stock.
C. patterns.
D. models.
ANSWER: B
228. SOMs are used to cluster a specific _____________ dataset containing information about the patient's
drugs etc.
A. physical.
B. logical.
C. medical.
D. technical.
ANSWER: C
229. GA stands for _______________.
A. Genetic algorithm
B. Gene algorithm.
C. General algorithm.
D. Geo algorithm.
ANSWER: A
230. GA was introduced in the year __________.
A. 1955.
B. 1965.
C. 1975.
D. 1985.
ANSWER: C
231. Genetic algorithms are search algorithms based on the mechanics of natural_______.
A. systems.
B. genetics.
C. logistics.
D. statistics.
ANSWER: B
232. GAs were developed in the early _____________.
A. 1970.
B. 1960.
C. 1950.
D. 1940.
ANSWER: A
233. The RSES system was developed in ___________.
A. Poland.
B. Italy.
C. England.
D. America.
ANSWER: A
234. Crossover is used to _______.
A. recombine the population's genetic material.
B. introduce new genetic structures in the population.
C. to modify the population's genetic material.
D. All of the above.
ANSWER: A
235. The mutation operator ______.
A. recombine the population's genetic material.
B. introduce new genetic structures in the population.
C. to modify the population's genetic material.
D. All of the above.
ANSWER: B
236. Which of the following is an operation in genetic algorithm?
A. Inversion.
B. Dominance.
C. Genetic edge recombination.
D. All of the above.
ANSWER: D
237. . ___________ is a system created for rule induction.
A. RBS.
B. CBS.
C. DBS.
D. LERS.
ANSWER: D
238. NLP stands for _________.
A. Non Language Process.
B. Nature Level Program.
C. Natural Language Page.
D. Natural Language Processing.
ANSWER: D
239. Web content mining describes the discovery of useful information from the _______contents.
A. text.
B. web.
C. page.
D. level.
ANSWER: B
240. Research on mining multi-types of data is termed as _______ data.
A. graphics.
B. multimedia.
C. meta.
D. digital.
ANSWER: B
241. _______ mining is concerned with discovering the model underlying the link structures of the web.
A. Data structure.
B. Web structure.
C. Text structure.
D. Image structure.
ANSWER: B
242. _________ is the way of studying the web link structure.
A. Computer network.
B. Physical network.
C. Social network.
D. Logical network.
ANSWER: C
243. The ________ propose a measure of standing a node based on path counting.
A. open web.
B. close web.
C. link web.
D. hidden web.
ANSWER: B
244. In web mining, _______ is used to find natural groupings of users, pages, etc.
A. clustering.
B. associations.
C. sequential analysis.
D. classification.
ANSWER: A
245. In web mining, _________ is used to know the order in which URLs tend to be accessed.
A. clustering.
B. associations.
C. sequential analysis.
D. classification.
ANSWER: C
246. In web mining, _________ is used to know which URLs tend to be requested together.
A. clustering.
B. associations.
C. sequential analysis.
D. classification.
ANSWER: B
247. __________ describes the discovery of useful information from the web contents.
A. Web content mining.
B. Web structure mining.
C. Web usage mining.
D. All of the above.
ANSWER: A
248. _______ is concerned with discovering the model underlying the link structures of the web.
A. Web content mining.
B. Web structure mining.
C. Web usage mining.
D. All of the above.
ANSWER: B
249. The ___________ engine for a data warehouse supports query-triggered usage of data
A. NNTP
B. SMTP
C. OLAP
D. POP
ANSWER: C
250. ________ displays of data such as maps, charts and other graphical representation allow data to be
presented compactly to the users.
A. Hidden
B. Visual
C. Obscured
D. Concealed
ANSWER: B

My answers Quizz - 1 - 2017 - Artificial Intellengence (S1-17_ISZC444)

2017-09-12T20:29:00.002-07:00

Artificial Intellengence (S1-17_ISZC444)

A* with the heuristic

h (n) = 1

n

is not a goal node and

h (n) = 0

otherwise, is equivalent to

Select one:

BFS

Hill climbing

DFS

None of these

How to Compare one Column to other Column contents in Excel using VBA script.... Traceability...

2015-02-09T02:31:00.000-08:00

Sub Traceability()

Dim i As Long
Dim j As Long
Dim k As Long
Dim CheckReq As String

i = 1
j = 1
Sheets("Req").Select
Do While Not IsEmpty(Sheets("Req").Cells(i, 1))
Sheets("Req").Select
CheckReq = RTrim(Sheets("Req").Cells(i, 1))
Sheets("Req").Rows(i & ":" & i).Select
Selection.Copy
Sheets("Availability").Select
Sheets("Availability").Rows(j & ":" & j).Select
ActiveSheet.Paste

k = 1
Do While Not IsEmpty(Sheets("TestSpec").Cells(k, 1))

If (RTrim(Sheets("TestSpec").Cells(k, 1)) = CheckReq) Then
Sheets("Availability").Select
Sheets("Availability").Cells(j, 13) = "Available in Test Spec"
Exit Do
End If
k = k + 1

Loop

'This below variables for Req
j = j + 1
i = i + 1

Loop

End Sub

How to detect OS version in System

2015-02-09T02:14:00.004-08:00

/*
* Os_version.c
*
* Created on: 09.02.2015
* Author: Karthikeyan D
* This C code will be useful to detect the OS version in System...
* It can be adopted in in various application like Installation mode selection, Directory prediction, etc...
*
*/

# include <stdio.h>
# include <stdlib.h>
int main()
{
    // To execute system command in C program

    system("systeminfo | findstr /C:\"OS\"");

    printf("\n@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@\n");

    system(" systeminfo | findstr /B /C:\"OS Name\" /C:\"OS Version\"");

    printf("\n@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@\n");

    system("systeminfo");

    return 0;
}

Round Robin Algorithm Implementation in C program

2015-01-27T08:06:00.001-08:00

/*
* Round_Robin_Alg.c
*
* Created on: 13.01.2015
*      Author: karthikeyan dharmalingam */

# include "main_header.h"

//Declaration part
int nRound_Robin_Algorithm_fun(void);

// Definition part
int nRound_Robin_Algorithm_fun()
{

    printf("\nInside Round robin algorithm \n");

    //Variale declaration
    int nQuantumTime;     // To ge the quantum or slice number from user
    int nProcess,nRemainingProcess;     // To ge the number of process
    int nArrivalTime[255], nBurstTime[255], nRemainingTime[255]; //To get the arrival, burst,and remaing time of process.
    int nLoop, nTime, nFlagComplete;

    printf("\nEnter the number of process \n");
    scanf("%d",&nProcess); //To get the user input for number of process
    //To update remaining process count to complete all process
    nRemainingProcess = nProcess;

    printf("Enter the Quantum/Slice size 1 <--> 255\n");
    scanf("%d",&nQuantumTime); // To get the slice value from user

    //To get the individual timing information on each process.
    for (nLoop = 0; nLoop < nProcess; nLoop++ )
    {
        printf("Enter the arrival and Burst timing for process: P%d: ",nLoop+1);
        scanf("%d",&nArrivalTime[nLoop]);
        scanf("%d",&nBurstTime[nLoop]);
        nRemainingTime[nLoop] = nBurstTime[nLoop];
    }
    printf("\nSuccessfully input received from user\n");
    //Round robin Agorithm to schedule all the process.
    for (nLoop = 0, nTime = 0; nRemainingProcess != 0;)
    {
        //Check for remaining time greater than or equals to slice.
        if(nRemainingTime[nLoop] <= nQuantumTime && nRemainingTime[nLoop] > 0 )
        {

            nTime = nTime + nRemainingTime[nLoop];
            nRemainingTime[nLoop] = 0;
            nFlagComplete = 1; //Set the flag to notice the completion
            printf("\nInside IF \n");

        }
        //Check for remaining time lesser than slice.
        else if(nRemainingTime[nLoop] > 0)
        {
            nTime = nTime + nQuantumTime;
            nRemainingTime[nLoop] = nRemainingTime[nLoop] - nQuantumTime;
            printf("\nInside ELSE IF \n");
        }
        //process compeleted status
        if(nRemainingTime[nLoop] == 0 && nFlagComplete == 1)
        {
            nRemainingProcess--; //Reduce number of process by one.
            printf("P[%d]\t|\t%d\t|\t%d\n",nLoop+1,nTime-nArrivalTime[nLoop],nTime-nArrivalTime[nLoop]-nBurstTime[nLoop]);
            //Remove flag for uncompleted process
            nFlagComplete = 0;
        }

        if(nLoop == nProcess - 1)
        {
            nLoop = 0;
            printf("\nInside I \n");
        }
        else if(nArrivalTime[nLoop] <= nTime)
        {
            nLoop++;
            printf("\nInside II \n");

        }else
        {
            printf("\nInside III \n");
            nLoop = 0;
        }

    }

    return 0;
}

Reading system value through system function

2015-01-13T02:41:00.002-08:00

# include <stdio.h>
# include <stdlib.h>
# include <string.h>
# include <time.h>

int main()
{
        //Variable declaration
        FILE *fp;
        char hc1,hc2,mc1,mc2;
        int hi1,hi2,mi1,mi2,hour,minute;
        //Reading system value through system function
        system("echo %time% >time.txt");
        fp=fopen("time.txt","r");
        // Sanity Check
        if(fp==NULL)
           exit(1) ;
        //Assigning individual character information into char varialbels
        hc1=fgetc(fp);
        hc2=fgetc(fp);
        fgetc(fp); // to avoid : symbol from integer calculation
        mc1=fgetc(fp);
        mc2=fgetc(fp);
        fclose(fp);
        remove("time.txt");

        hi1=hc1;
        hi2=hc2;
        mi1=mc1;
        mi2=mc2;
        // Char to Integer conversion
        hi1-=48;
        hi2-=48;
        mi1-=48;
        mi2-=48;
        // adding characters for double digit
        hour=hi1*10+hi2;
        minute=mi1*10+mi2;
        //Final output
        printf("Current time is %d:%d\n",hour,minute);

        return 0;
}

Output:
Current time is 11:40

Macros in conditonal operation and data mismatch issue

2015-01-09T07:10:00.001-08:00

/*
* Debugger.c
*
* Created on: 09.01.2015
*      Author: karthik
*/

# include <stdio.h>
# include <stdlib.h>
# define CEILby2(X) ((X+1)/2)

int main()
{
    int nCycle,nCount=0;
    printf("Understanding of Macros and TypeCasting\n");
    printf("Enter the Cycle in even number for a scenario\n");
    scanf("%d",&nCycle);

    while(nCount <CEILby2(nCycle))
    {
        nCount++;
    }
    printf("Number of cycle executed: %d", nCount);

    return 0;
}

**************************************
Output:
Understanding of Macros and TypeCasting
Enter the Cycle in even number for a scenario
5
Number of cycle executed:3 ------ expected only 2.

Note: Integer is compared with floating(Real numbers)

To Write and Read the 32 bit Variable using 4 Byte Array

2013-06-29T09:43:00.000-07:00

/*
* Read_Array.c
*
* Created on: Jun 29, 2013
*      Author: Karthik
*/

/* To Write the 32 bit variable using 4 Byte Array*/

#include "stdio.h"
#include "stdlib.h"

int main()
{
    /* variable Initialization */

    int nArray[4] = {1,0,0,0};
    //int nOutVar = 0;
    unsigned int nlOutVar=0;

    printf("%d\n",nArray[0]);
    printf("%d\n",nArray[1]);
    printf("%d\n",nArray[2]);
    printf("%d\n",nArray[3]);
    nlOutVar = nArray[0];
    nlOutVar = nlOutVar << 8;
    printf("2byte usage%u\n",nlOutVar);
    nlOutVar = nlOutVar + nArray[1];
    nlOutVar = nlOutVar << 8;
    printf("3byte usage%u\n",nlOutVar);
    nlOutVar = nlOutVar + nArray[2];
    nlOutVar = nlOutVar << 8;
    printf("4byte usage%u\n",nlOutVar);
    nlOutVar = nlOutVar + nArray[3];

    printf("4byte content looks like %u\n",nlOutVar);

    nlOutVar = nlOutVar >> 16;
    printf("MSB first 2byte content reading %u\n",nlOutVar);

    nlOutVar = 4294967295;
    printf("maximum value %u\n",nlOutVar);

    return 0;

}

Output:

1
0
0
0
2byte usage256
3byte usage65536
4byte usage16777216
4byte content looks like 16777216
MSB first 2byte content reading 256
maximum value 4294967295

Sine Wave Generation in C Program

2013-04-11T06:53:00.003-07:00

/*
* SineWave.c
*
* Created on: Apr 11, 2013
*      Author: Karthik
*/

#include<stdio.h>
#include<conio.h>
#include<math.h>
#include <windows.h>

#define pi 3.142
int main()
{
    FILE *fp;
    fp = fopen("Sinewave.xls","w");

    if(fp == NULL)
    {
        MessageBox(0,"Error","File Creation",16);
        exit(0);

    }
int nfreq,nTime,nAmplitude=0;
double dSample, dCycle=0;
double dStopTime=0;
printf("enter the desired frequency of the signal:\n");
scanf("%d",&nfreq);
printf("enter the desired sampling Time:\n");
scanf("%d",&nTime);
printf("enter the amplitude of the signal:\n");
scanf("%d",&nAmplitude);
printf("Enter the Stop time:\n");
scanf("%lf",&dStopTime);

for (;dCycle <= dStopTime; )
{
    dSample = nAmplitude * sin(2*pi*nfreq*dCycle);

    fprintf(fp,"%lf\n",dSample);

    dCycle = dCycle + ((double)nTime/100);
}

    fclose(fp);
    getch();
    return 0;
}

Example for Dot and arrow usage of structural pointer and array.

2012-12-15T23:31:00.001-08:00

# include <stdio.h>
# include <stdlib.h>
# include <string.h>

typedef struct database
{
    int age;
    char name[10];

}DATA;

DATA Str;
DATA *Ptr;

int main()
{

    /*********** Dot format to Arrow format representation********/

     //Enter the values for database
    printf("1. Enter the values for database\n");
    printf("Enter your Age\n");
    scanf("%d",&(Str.age));
    scanf("%s",Str.name);

    printf("Your Age:%d is updated in database\n",(&Str)->age);
    printf("Your Name:%s is updated in database\n",(&Str)->name);
    /**************************************************************/

    Ptr =(DATA *)malloc(sizeof(DATA));
    /*********** Arrow format to Dot format representation *********/

        printf("2. Enter the values for database\n");
        printf("Enter your Age\n");
        scanf("%d",&(Ptr)->age);

        scanf("%s",Ptr->name);

        printf("Your Age:%d is updated in database\n",((*Ptr).age));
        printf("Your Name:%s is updated in database\n",(*Ptr).name);
    /**************************************************************/

     return 0;
}

Output:

F:\workspace\pointer_C\Debug>pointer_C.c.exe
1. Enter the values for database
Enter your Age
24
kumar
Your Age:24 is updated in database
Your Name:kumar is updated in database
2. Enter the values for database
Enter your Age
23
Ramesh
Your Age:23 is updated in database
Your Name:Ramesh is updated in database

F:\workspace\pointer_C\Debug>

Difference between Dot(.) and Arrow (*) in C language

2012-12-15T18:57:00.004-08:00

Difference between Dot(.) and Arrow (*) in C language

Representation
Dot (.)					Arrow (*)
The Dot (.) operator can't be overloaded.					Arrow (->) operator can be overloaded.
ex:(*foo).bar()					ex:foo->bar()

Note1: The parenthesizes above are necessary because of the binding strength of the * and . operators.
Note2: *foo.bar() wouldn't work because Dot (.) operator binds stronger and is executed first.

Possible way of dot and arrow usage for non pointer element in C.

ptr->fld == (*ptr).fld
str.fld == (&str)->fld

How to read element in Structural Array and pointer in C

2012-12-14T19:06:00.001-08:00

/*
* pointer.c
*
* Created on: Dec 15, 2012
*      Author: Karthik
*/

# include <stdio.h>
# include <stdlib.h>

struct database
{
    int nstArray[10];
    int *nstpointer;
}STDBase;

int main()
{
    // Initialization
    int nArray[10];
    char cArray[10];
    int *nPointer;
    int nLoop;

    //Memory allocation
    nPointer = calloc(1,10);

    // Initialization for int, char arrays and int pointer
    for(nLoop = 0; nLoop < 10; nLoop++)
    {
        // To int array
        nArray[nLoop] = nLoop;
        printf("%d\t",nArray[nLoop]);

        // To char array
        cArray[nLoop] = nLoop+48;
        printf("%c\t",cArray[nLoop]);

        // To int pointer
        *nPointer    = nLoop+2;
        printf("%d\n",*nPointer);
        nPointer++;

    }
   nLoop--;
   STDBase.nstArray[nLoop] =10;
   STDBase.nstpointer = (STDBase.nstArray);

   printf("%d\n",STDBase.nstArray[nLoop]);
   printf("%d\n",STDBase.nstpointer[nLoop]);

    return 0;
}

Output:
0   0   2
1   1   3
2   2   4
3   3   5
4   4   6
5   5   7
6   6   8
7   7   9
8   8   10
9   9   11
10
10

Difference Between Build and Compilation in C/C++

2012-10-13T19:26:00.000-07:00

Build is the process to compile and link only the source files that have changed since the last build (i.e. based on file creation date and time).

Rebuild is the process to compile and link all source files regardless of whether they changed or not. Build is the normal thing to do and is faster. Sometimes the versions of project target components can get out of sync and rebuild is necessary to make the build successful.

Compilation is compiles the source file currently being edited.

The compilation of code involves several steps:

Parsing of the statements for syntax (language based)
Translation of the statements into machine language
Setting up the addresses of all variables
Optimization of the code (if desired)

C and C++ programs and MySQL

How to protect selected cells in vba

How to use switch case in VBA

How to get current month details using VBA

How to split string using vba

How to get input from user using vba

How to Freeze and Unfreeze pane using VBA

How to copy one sheet to another using vba

How to get current workbook worksheet name using vba

How to hide Unhide Rows and Columns using VBA

How to clear Chart in Excel using VBA

How to clear Excel using VBA

Quizz II Software Architectures

Data Warehouse Answer

My answers Quizz - 1 - 2017 - Artificial Intellengence (S1-17_ISZC444)

Artificial Intellengence (S1-17_ISZC444)

Feedback

Feedback

Feedback

Feedback

Feedback

Feedback

Feedback

Feedback

Feedback

Feedback

How to Compare one Column to other Column contents in Excel using VBA script.... Traceability...

How to detect OS version in System

Round Robin Algorithm Implementation in C program

Reading system value through system function

Macros in conditonal operation and data mismatch issue

To Write and Read the 32 bit Variable using 4 Byte Array

Sine Wave Generation in C Program

Example for Dot and arrow usage of structural pointer and array.

Difference between Dot(.) and Arrow (*) in C language

How to read element in Structural Array and pointer in C

Difference Between Build and Compilation in C/C++