Questions and answers - MCQ with explanation on Computer Science subjects like System Architecture, Introduction to Management, Math For Computer Science, DBMS, C Programming, System Analysis and Design, Data Structure and Algorithm Analysis, OOP and Java, Client Server Application Development, Data Communication and Computer Networks, OS, MIS, Software Engineering, AI, Web Technology and many other subjects also make available Q & A for exam, interview, competitive exam and entrance test.

Redirect blogger page in same blog

How to redirect blogger page in same blog

Recently i wanted to redirect my one of this blog's page to another page in this same blog as that post was duplicated with different url by me but while i come to know that page was crawled so it is need to be redirect to another page and delete.

Just want to share this Solution as i worked hard for found the solution.

Go to Settings--> Search Preferences from your blogger side navigation bar as i showed in below image.

Now Click on Edit from Custom Redirects under Errors and redirections.

Now copy and past your page url in from field which you want to redirect and in To field past url on which page to be shown instead of that page.

Everything is done now. Hope this solution will help you.

Data Warehousing and Data Mining

Questions 1 to 10

Set 1

Set 2

Set 3

1. Which of the following is the most important when deciding on the data structure of a data mart?
(a) XML data exchange standards
(b) Data access tools to be used
(c) Metadata naming conventions
(d) Extract, Transform, and Load (ETL) tool to be used
(e) All (a), (b), (c) and (d) above.

2. The process of removing the deficiencies and loopholes in the data is called as
(a) Aggregation of data
(b) Extracting of data
(c) Cleaning up of data.
(d) Loading of data
(e) Compression of data.

3. Which one manages both current and historic transactions?
(a) OLTP
(b) OLAP
(c) Spread sheet
(d) XML
(e) All (a), (b), (c) and (d) above.

4. Which of the following is the collection of data objects that are similar to one another within the same group?
(a) Partitioning
(b) Grid
(c) Cluster
(d) Table
(e) Data source.

5. Which of the following employees data mining techniques to analyze the intent of a user query, provided additional generalized or associated information relevant to the query?
(a) Iceberg query method
(b) Data analyzer
(c) Intelligent query answering
(d) DBA
(e) Query parser.

6. Which of the following process includes data cleaning, data integration, data selection, data transformation, data mining, pattern evolution and knowledge presentation?
(a) KDD process
(b) ETL process
(c) KTL process
(d) MDX process
(e) None of the above.

7. At which level we can create dimensional models?
(a) Business requirements level
(b) Architecture models level
(c) Detailed models level
(d) Implementation level
(e) Testing level.

8. Which of the following is not related to dimension table attributes?
(a) Verbose
(b) Descriptive
(c) Equally unavailable
(d) Complete
(e) Indexed.

9. Data warehouse bus matrix is a combination of
(a) Dimensions and data marts
(b) Dimensions and facts
(c) Facts and data marts
(d) Dimensions and detailed facts
(e) All (a), (b), (c) and (d) above.

10. Which of the following is not the managing issue in the modeling process?
(a) Content of primary units column
(b) Document each candidate data source
(c) Do regions report to zones
(d) Walk through business scenarios
(e) Ensure that the transaction edit flat is used for analysis.

Answers

Ans Reason

1. B Data access tools to be used when deciding on the data structure of a data mart.

2. C The process of removing the deficiencies and loopholes in the data is called as cleaning up of data.

3. B Online Analytical Processing (OLAP) manages both current and historic transactions.

4. C Cluster is the collection of data objects that are similar to one another within the same group.

5. C Intelligent Query Answering employee’s data mining techniques to analyze the intent of a user query provided additional generalized or associated information relevant to the query.

6. A KDD Process includes data cleaning, data integration, data selection, data transformation, data mining, pattern evolution, and knowledge presentation.

7. B Dimensional models can be created at Architecture models level.

8. C Equally unavailable is not related to dimension table attributes.

9. A Data warehouse bus matrix is a combination of Dimensions and data marts.

10. E Ensure that the transaction edit flat is used for analysis is not the managing issue in the modeling process.

Data Warehousing and Data Mining

Questions 11 to 21

Set 1

Set 2

Set 3

11. Data modeling technique used for data marts is
(a) Dimensional modeling
(b) ER – model
(c) Extended ER – model
(d) Physical model
(e) Logical model.

12. A warehouse architect is trying to determine what data must be included in the warehouse. A meeting has been arranged with a business analyst to understand the data requirements, which of the following should be included in the agenda?
(a) Number of users
(b) Corporate objectives
(c) Database design
(d) Routine reporting
(e) Budget.

13. An OLAP tool provides for
(a) Multidimensional analysis
(b) Roll-up and drill-down
(c) Slicing and dicing
(d) Rotation
(e) Setting up only relations.

14. The Synonym for data mining is
(a) Data warehouse
(b) Knowledge discovery in database
(c) ETL
(d) Business intelligence
(e) OLAP.

15. Which of the following statements is true?
(a) A fact table describes the transactions stored in a DWH
(b) A fact table describes the granularity of data held in a DWH
(c) The fact table of a data warehouse is the main store of descriptions of the transactions stored in a DWH
(d) The fact table of a data warehouse is the main store of all of the recorded transactions over time
(e) A fact table maintains the old records of the database.

16. Most common kind of queries in a data warehouse
(a) Inside-out queries
(b) Outside-in queries
(c) Browse queries
(d) Range queries
(e) All (a), (b), (c) and (d) above.

17. Concept description is the basic form of the
(a) Predictive data mining
(b) Descriptive data mining
(c) Data warehouse
(d) Relational data base
(e) Proactive data mining.

18. The apriori property means
(a) If a set cannot pass a test, all of its supersets will fail the same test as well
(b) To improve the efficiency the level-wise generation of frequent item sets
(c) If a set can pass a test, all of its supersets will fail the same test as well
(d) To decrease the efficiency the level-wise generation of frequent item sets
(e) All (a), (b), (c) and (d) above.

19. Which of following form the set of data created to support a specific short lived business situation?
(a) Personal data marts
(b) Application models
(c) Downstream systems
(d) Disposable data marts
(e) Data mining models.

20. What is/are the different types of Meta data?
I. Administrative.
II. Business.
III. Operational.
(a) Only (I) above
(b) Both (II) and (III) above
(c) Both (I) and (II) above
(d) Both (I) and (III) above
(e) All (I), (II) and (III) above.

Answers

Ans Explanation

11. A Data modeling technique used for data marts is Dimensional modeling.

12. D Routine reporting should be included in the agenda.

13. C An OLAP tool provides for Slicing and dicing.

14. C The synonym for data mining is Knowledge discovery in Database.

15. D The fact table of a data warehouse is the main store of all of the recorded transactions over time is the correct statement.

16. A The Most common kind of queries in a data warehouse is Inside-out queries.

17. B Concept description is the basis form of the descriptive data mining.

18. B The apriori property means to improve the efficiency the level-wise generation of frequent item sets.

19. D Disposable Data Marts is the form the set of data created to support a specific short lived business situation.

20. E The different types of Meta data are Administrative, Business and Operational.

Data Warehousing and Data Mining

Questions 21 to 30

Set 1

Set 2

Set 3

21. Multiple Regression means
(a) Data are modeled using a straight line
(b) Data are modeled using a curve line
(c) Extension of linear regression involving only one predicator value
(d) Extension of linear regression involving more than one predicator value
(e) All (a), (b), (c) and (d) above.

22. Which of the following should not be considered for each dimension attribute?
(a) Attribute name
(b) Rapid changing dimension policy
(c) Attribute definition
(d) Sample data
(e) Cardinality.

23. A Business Intelligence system requires data from:
(a) Data warehouse
(b) Operational systems
(c) All possible sources within the organization and possibly from external sources
(d) Web servers
(e) Database servers.

24. Data mining application domains are
(a) Biomedical
(b) DNA data analysis
(c) Financial data analysis
(d) Retail industry and telecommunication industry
(e) All (a), (b), (c) and (d) above.

25. The generalization of multidimensional attributes of a complex object class can be performed by examining each attribute, generalizing each attribute to simple-value data and constructing a multidimensional data cube is called as
(a) Object cube
(b) Relational cube
(c) Transactional cube
(d) Tuple
(e) Attribute.

26. Which of the following project is a building a data mart for a business process/department that is very critical for your organization?
(a) High risk high reward
(b) High risk low reward
(c) Low risk low reward
(d) Low risk high reward
(e) Involves high risks.

27. Which of the following tools a business intelligence system will have?
(a) OLAP tool
(b) Data mining tool
(c) Reporting tool
(d) Both(a) and (b) above
(e) (a), (b) and (c) above.

28. Which of the following is/are the Data mining tasks?
(a) Regression
(b) Classification
(c) Clustering
(d) inference of associative rules
(e) All (a), (b), (c) and (d) above.

29. In a data warehouse, if D1 and D2 are two conformed dimensions, then
(a) D1 may be an exact replica of D2
(b) D1 may be at a rolled up level of granularity compared to D2
(c) Columns of D1 may be a subset of D2 and vice versa
(d) Rows of D1 may be a subset of D2 and vice versa
(e) All (a), (b), (c) and (d) above.

30. Which of the following is not an ETL tool?
(a) Informatica
(b) Oracle warehouse builder
(c) Datastage
(d) Visual studio
(e) DT/studio.

Answers

Ans Explanation

21. D Multiple Regression means extension of linear regression involving more than one predicator value.

22. B Rapid changing dimension policy should not be considered for each dimension attribute.

23. A A business Intelligence system requires data from Data warehouse

24. E Data mining application domains are Biomedical, DNA data analysis, Financial data analysis and Retail industry and telecommunication industry

25. A The generalization of multidimensional attributes of a complex object class can be performed by examining each attribute, generalizing each attribute to simple-value data and constructing a multidimensional data cube is called as object cube.

26. A High risk high reward project is a building a data mart for a business process/department that is very critical for your organization

27. A Business intelligence system will have OLAP, Data mining and reporting tolls.

28. E Regression, Classification and Clustering are the data mining tasks.

29. A In a data warehouse, if D1 and D2 are two conformed dimensions, then D1 may be an exact replica of D2.

30. D Visual Studio is not an ETL tool.

Enterprise Java Questions and Answers Set 3

Set 1 Set 2 Set 3

Questions 21 to 30

21. Which method of the servlet is/are called several times in its life?

(a) init()

(b) doPost()

(d) Both (a) and (b) above

(e) Both (a) and (c) above.

22. Which EJB uses EJB-QL for query operations?

(a) BMP Entity Bean

(b) CMP Entity Bean

(d) Message-Driven Bean

(e) MCP Entity Bean.

23. Which object is used to forward the request processing from one servlet to another?

(a) ServeltContext

(b) ServletConfig

(d) ResponseDispatcher

(e) ResponseRedirect.

24. Which is not a valid scope for Java bean in JSP?

(a) Page

(b) Session

(d) Application

(e) Global.

25. Which of the following allows substitution of code to occur at the translation time in a JSP page?

(a) <jsp:include> Tag

(b) <@ include> directive

(d) Declaration block

(e) None of the above.

26. Which of the following property of Java Bean represents a single value?

(a) Simple property

(b) Boolean property

(d) Both (a) and (b) above

(e) Both (b) and (c) above.

27. Which of the following is used to redirect the response from a servlet to a JSP page?

(a) response.sendRedirect()

(b) request.sendRedirect()

(d) response.forward()

(e) request.dispatch().

28. Which of the following is true for Java Bean?

(a) It can not be a GUI component

(b) It never implements serializable interface

(d) It is a distributed component

(e) It has a non zero argument constructor.

29. Which of the following is not true for <jsp:useBean> tag in JSP page?

(a) Locates a bean instance

(b) Stores object reference of the bean in a variable

(d) Does not execute the body tag if any

(e) All the above.

30. Which of the following are not an implicit object in JSP?

I. Request.

II. Session.

III. Vector.

IV. In.

(a) Both (I) and (II) above

(b) Both (II) and (III) above

(d) Both (II) and (IV) above

(e) Both (III) and (IV) above.

Answers And Explanation

Ans Explanation

21. B dopost() method of the servlet is called several times in its life.

22. B cmp entity bean uses ejb-ql for query operations.

23. C Request Dispatcher is used to forward the request processing from one servlet

to another.

24. E Global is not a valid scope for java bean in Jsp.

25. B <@ include> directive allows substitution of code to occur at the translation

time in a JSP page

26. D simple property and bolean property represents a single value.

27. A response.sendRedirect() is used to redirect the response from a servlet to a

JSP page.

28. C java bean has a zero-argument constructor

29. D jsp:use bean tag is not used to execute the body of tag if any.

30. E vector and in are not implicit objects.

Enterprise Java Questions and Answers Set 2

Set 1 Set 2 Set 3

Questions 11 to 20

11. Which of the following is not true for servlet?

(a) It is persistent

(b) Platform independent

(d) It is multi threaded

(e) It is single threaded.

12. Which JSP tag is used to transfer processing to another JSP page?

(a) <jsp:include>

(b) <jsp:forward>

(d) <jsp:useBean>

(e) <jsp:use:include>.

13. Which of the following is an approach for state maintenance in Web applications?

(a) Hidden Form Field

(b) URL Rewriting

(d) HTTP Session

(e) All of the above.

14. Which of the following are not a container for EJB?

I. Internet Information Server.

II. Java System Application Server.

III. Tomcat.

IV. WebLogic.

(a) Both (I) and (II) above

(b) Both (II) and (III) above

(d) Both (I) and (IV) above

(e) Both (I) and (III) above.

15. Which EJB usually represents persistent data?

(a) Entity Bean

(b) Stateless Session Bean

(d) Message-Driven Bean

(e) Static Bean.

16. Which is least visibility scope for Java bean in JSP?

(a) Page

(b) Session

(d) Application

(e) Global.

17. Which of the following is/are true for JSP technology?

I. It is persistent.

II. Platform independent.

III. Browser executes the code.

(a) Only (I) above

(b) Only (II) above

(d) Both (II) and (III) above

(e) All (I), (II) and (III) above.

18. Which of the following is true for JNDI?

(a) Database service

(b) Naming and Directory Service

(d) Web Service

(e) XML Service.

19. Which method of the request object is used to extract values of the input fields in a form when it is submitted?

(a) getParameter

(b) getParameterNames

(d) putValues

(e) getParameters.

20. Which of the following is true for CORBA?

(a) Protocol for distributed computing

(b) Database specification

(d) Components can be language neutral

(e) Both (c) and (d) above.

Answers and Explanation

Ans Explanation

11. E Servlet is not single threaded.

12. B <jsp:forward> is used to transfer processing to another jsp page.

13. E All the approaches are used for state maintenance in Web applications

14. E Internet information server and tomcat are not container for EJB.

15. A Entity bean usually represents persistent data.

16. A Page is least visbility scope for java bean in jsp.

17. C jsp technology is persistent and platform independent.

18. B jNDI is naming and directory service.

19. A Get parameter is usedto extract values of the input fields in a form

20. E Both a and b are contradicting.

Enterprise Java Questions and Answers Set 1

Set 1 Set 2 Set 3

1. Which of the following is the format for EJB deployment descriptor files?

(a) XML
(b) XSL
(c) HTML
(d) Java
(e) DHTML.

2. EJB is a

(a) Middleware
(b) Scalable component architecture
(c) Component architecture to integrate legacy systems
(d) Component architecture to encapsulate business logic
(e) All of the above.

3. Which of the following EJB has no state?

i. Message-Driven Bean.
ii. BMP Entity Bean.
iii. Stateless Session Bean.
iv. Stateful Session Bean.

(a) Both (I) and (II) above
(b) Both (II) and (III) above
(c) Both (III) and (IV) above
(d) Both (I) and (IV) above
(e) Both (I) and (III) above.

4. Which of the following is true for EJB?

(a) EJB is server-side component architecture for distributed applications in Java
(b) EJB facilitates scalable, secure and transaction-oriented applications
(c) EJB supports portability and reusability
(d) EJB specification allows different vendor implementation of it
(e) All of the above.

5. Which of the following EJB type has no Remote interfaces?

(a) Message-Driven Bean
(b) BMP Entity Bean
(c) CMP Entity Bean
(d) Session Bean
(e) Sessionless Bean.

6. Which role in EJB architecture is responsible for EJB Server?

(a) EJB Deployer
(b) Application Assembler
(c) Network Engineer
(d) Server Provider
(e) Tool Vendor.

7. Which of the EJB has a passive state in its life cycle?

I. Stateless Session Bean.
II. Message-Driven Bean.
III. BMP Entity Bean.

(a) Only (I) above
(b) Only (II) above
(c) Only (III) above
(d) Both (I) and (II) above
(e) Both (II) and (III) above.

8. Which part of multi-tier enterprise application contains EJB component?

(a) Application Server
(b) Web Server
(c) Database Server
(d) Fat Client
(e) Thin Client.

9. Which of the following distributed object technology is/are not included in Java?

I. CORBA.
II. DCOM.
III. RMI.
IV. EJB.

(a) Only (I) above
(b) Only (II) above
(c) Only (III) above
(d) Only (IV) above
(e) All (I), (II), (III) and (IV) above.

10. Which of the following is not a property of EJB transaction?

(a) Atomicity
(b) Consistency
(c) Isolation
(d) Distributed
(e) Durability.

Answers

Answer Explanation

1. A The format for EJB deployment descriptor files is XML.

2. E EJB is a middleware, Scalable component architecture, Component

architecture to integrate legacy systems, Component architecture to

encapsulate business logic.

3. E Message Driven bean and stateless session bean has no state.

4. E All the above statements are true with respect to EJB.

5. A Message driven bean has no remote interface.

6. D Server provider is responsible for EJB server.

7. C BMP Entity Bean has a passive state in its life cycle.

8. A Application server contains ejb component.

9. B DCOM is a Microsoft object technology.

10. D Distributed is not a property of EJB transaction.

Subscribe to: Posts ( Atom )

All the content available on this blog is for informational purposes only. The content in this blog is fetched through online and offline research. If any of the information available on this blog violates or infringes any of your copyright protection, leave a comment or contact us by using the above form. Appropriate action will be taken as soon as possible. This blog makes no representations as to accuracy, completeness, correctness or validity of any information on this site and will not be liable for any errors, or delays in this information. The information contained in this blog is subject to change without notice. You can use contents in this blog only for personal use. Reproduction and republishing of any contents from here to any other websites or blogs is strictly prohibited.

Pages

Redirect blogger page in same blog

How to redirect blogger page in same blog

Data Warehousing and Data Mining Set 1

Data Warehousing and Data Mining

Questions 1 to 10

Answers

Data Warehousing and Data Mining Set 2

Data Warehousing and Data Mining

Questions 11 to 21

Answers

Data Warehousing and Data Mining Set 3

Data Warehousing and Data Mining

Questions 21 to 30

Answers

Enterprise Java MCQs with Answers Set 3

Enterprise Java Questions and Answers Set 3

Questions 21 to 30

Answers And Explanation

Enterprise Java MCQs with Answers Set 2

Enterprise Java Questions and Answers Set 2

Questions 11 to 20

Answers and Explanation

Enterprise JAVA MCQs with answer and explanation

Enterprise Java Questions and Answers Set 1

Answers