Question.
Continue action if a lookup on a link fails

a)Drops the row and Job fails
b)Drops the row and will skip next lookup
c) Drops the row and will skill all further lookups
d) Drops the row and continues with the next lookup

Answer: Drops the row and continues with the next lookup

Question.
Fail action if a lookup on a link fails

a) Causes the job to reject records
b) Causes the job to issue a fatal error and continues with next lookup
c) Causes the job to issue a fatal error and stop
d) Causes the job to issue a fatal error and falls records from subsequent lookup

Answer: Causes the job to issue a fatal error and stop

Question.
Which phase is used to compute sum of salary collected together by deptno?
a)Join
b)Aggregate
c)Merge
d) Copy

Answer: Aggregate

Question.
Which activity is used to execute shell scripts or bat files?

a) Wait for File activity
b) Execute Command activity
c) Program activity
d) Run Program activity

Answer: Execute Command activity

Question.
Change_Code value of three of Change Capture Stage in DataStage represents

a) Copy
b) Delete
c) New
d) Edit

Answer: Edit

Question.
Change_Code value of zero of Change Capture Stage in DataStage represents

a) Edit
b) Delete
c) New
d) Copy

Answer: Copy

Question.
Change_Code value of one of Change Capture Stage in DataStage represents
a) Copy
b) Delete
c) Edit
d) New

Answer: New

Question.
Which one is used to remove duplicates in data?

a) Unique property set in Join Stage
b)Unique property set in Merge Stage
c)Remove Duplicate Stage
d)Dedup Sort Stage

Answer: Remove Duplicate Stage

Question.
Which of the below stages are used to achieve Union all operation on input data sources?

a)Join
b) Funnel
c) Lookup
d) Filter

Answer: Funnel

Question.
Which of the following is not type of view in Datastage Director?

a)Job View
b)Log View
c)Status View
d) Parallel View

Answer: Parallel View

Question.
Which one of the following can be used to schedule jobs

a) DataStage Director
b)DataStage Designer
c)DataStage Administrator
d) Data Stage Exporter

Answer: DataStage Director

Question.
Which one is used to create workflows in DataStage?

a) Parallel Jobs
b) Sequence Jobs
c) Server Jobs
d) Workflow Activity

Answer: Sequence Jobs

Question.
Change_Code value of two of Change Capture Stage in DataStage represents

a) Copy
b) Delete
c) New
d) Edit

Answer: Delete

Question.
Change Capture stage is

a) File Stage
b) Database Stage
c) Processing Stage
d) Miscellaneous Stage

Answer: Processing Stage

Question.
Which Stage allows you to specify several Reject links?

a) Lookup
b)Merge
c)Join
d) filter

Answer: Merge

Question.
If two rows in Change Capture have same key columns, you can match the columns in the rows to understand if one is an modified copy of the other.

a) Key Column
b) Value Columns
c)After Data Column
d)Before Data Column

Answer: Value Columns

Question.
Which action will wait for file to seem in a folder?

a)Wait for file activity
b)Job Activity
c)Execute Command Activity
d)Sequential file Stage activity

Answer: Wait for file activity

Question.
Which of the below phases are used to Restrict Data created on Where Clause Predicates?

a)Join
b)Funnel
c) Filter
d) Copy

Answer: Filter

Question.
using Copy stage

a)Order of columns can be changed but data type of columns cannot be changed
b)Order of columns cannot be changed but data type of columns can be changed
c)Order of columns can be changed and data type of columns can be changed
d) both the Order of columns and data type of columns cannot be changed

Answer: Order of columns can be changed but data type of columns cannot be changed

Question.
Which option will send record with null values when a lookup failure happens

a) Reject
b) Drop
c) Fail
d) Continue

Answer: Continue

Question.
Which of the following are true about Hadoop?
Open Source
Distributed Processing Framework
Distributed Storage Framework
All of these

Answer: All of these

Question.
Which of the following are false about Hadoop?
Hadoop works in Master-Slave fashion
Master & Slave both are worker nodes
User submit his work on master, which distribute it to slaves
Slaves are actual worker node

Answer: Master & Slave both are worker nodes

Question.
What is a Metadata in Hadoop?
Data stored by user
Information about the data stored in datanodes
User information
None of these

Answer: Information about the data stored in datanodes

Question.
What is a Daemon?
Process or service that runs in background
Applications submitted by user
Web application running on web server
None of these

Answer: Process or service that runs in background

Question.
All of the following accurately describe Hadoop EXCEPT?
a. Batch processing
b.Open-source
c. Distributed computing
d. Real-time

Answer: Real-time

Question.
All of the following is a core component of Hadoop EXCEPT?
a. Hive
b. HDFS
c. MapReduce
d. YARN

Answer: Hive

Question.
Hadoop is a framework that uses a variety of related tools. Common tools included in a typical implementation include:
a. MapReduce, HDFS, Spool
b. MapReduce, MySQL, Google Apps
c. Cloudera, HortonWorks, MapR
d. MapReduce, Hive, Hbase

Answer: MapReduce, Hive, Hbase

Question.
Which of the following can be used to create workflows when multiple MapReduce and Pig programs need to be executed?
a. Sqoop
b. Zookeeper
c. Oozie
d. Hbase

Answer: Oozie

Question.
Which of the following can be used to transfer bulk data between Hadoop and structured databases
a. Sqoop
b. Hive
c. Pig
d. Spark

Answer: Sqoop

Question.
How many single points of failure does a High Availability HDFS architecture have?
a. 0
b. 1
c. 2
d. 3

Answer: 0

Question.
If a file of size 300MB needs to be stored in the HDFS (block size=64MB, replication factor=2), how many blocks are created for this file in the HDFS?
a. 10
b. 11
c. 12
d. 15

Answer: 10

Question.
What is not a default value for a data block size in the HDFS?
a. 64MB
b. 128MB
c. 512MB
d. 256MB

Answer: 512MB

Question.
Which of the following architectures best describes the HDFS architecture?
a. High Availability
b. Master-Slave
c. Connected
d. Peer

Answer: Master-Slave

Question.
Which of the following is a master process in the HDFS architecture?
a. Datanode
b. JobTracker
c. Namenode
d. Secondary Namenode

Answer: Namenode

Question.
Which of the following is true about Hadoop?

Before storing data we need to specify the schema
We will loss data if one data node crashes
We can add n no of nodes in cluster on the fly (n ~ 15000)
Data is firstly processed on master then on slaves

Answer: We can add n no of nodes in cluster on the fly (n ~ 15000)

Question.
Choose the correct statement?

Master assigns work to all the slaves
We cannot edit data once written in Hadoop
Client need to interact with master first, as it is the single place where all the meta data is available
All of these

Answer: All of these

Question.
Which of the following is the essential module of HDFS?
Node Manager
Resource Manager
DataNode
ALL of the above

Answer: DataNode

Question.
Which of the below is NOT a kind of metadata in NameNode?

Block locations of files
List of files
File access control information
No. of file records

Answer: No. of file records

Question.
Which statement is true about DataNode?

It is the actual worker node that saves and stores meta data.
It is the slave node that saves and stores metadata.
It is the Master node that saves and stores actual data.
It is the slave node that saves and stores actual data.


Answer: It is the slave node that saves and stores actual data.

Question.
Is the Secondary NameNode is the Backup node?
TRUE
FALSE

Answer: FALSE

Question.
Which of the below is programming model planned for handling out large capacities of data in parallel by dividing the effort into a set of independent tasks.

MapReduce
Hive
Pig
HDFS

Answer: MapReduce

Question.
Mappers sorted output is Input to the-
Reducer
Mapper
Shuffle
All of the mentioned

Answer: Reducer


Question.
Which of the following generate intermediate key-value pair?
Reducer
Mapper
Combiner
Partitioner

Answer: Mapper

Question.
What is the major advantages of storing data in block size 128MB?
It saves disk seek time
It saves disk processing time
It saves disk access time
It saves disk latency time

Answer: It saves disk seek time

Question.
Role of Partitioned in Map Reduce Job is :

a) To partition input data into equal parts
b) Distribute data among available reducers
c) To partition data and send to each mapper
d) Distribute data among available mappers

Answer:  Distribute data among available reducers

Question.
Which of the following is Single point of Failure?
NameNode
Secondary NameNode
DataNode
None of above

Answer: NameNode

Question.
Apache Hbase is

a) Column family oriented NoSQL database
b) Relational Database
c) Document oriented NoSQL database
d) Not part of Hadoop eco system

Answer: Column family oriented NoSQL database

Question.
Which of the following is a Table Type in Hive ?

a)Managed Table
b)Local Table
c)Persistent Table
d)Memory Table

Answer: Managed Table

Question.
Which of the following is a demon process in Hadoop?

a) NameNode
b) JobNode
c) taskNode
d) mapreducer

Answer: NameNode

Question.
Information about locations of the blocks of a file is stored at ________

a)data nodes
b)name node
c)secondary name node
d)job tracker

Answer: name node

Question.
Apache Sqoop is used to

a) Move data from local file system to HDFS
b) Move data from streaming sources to HDFS
c) Move data from RDBMS to HDFS
d) Move data between Hadoop Clusters

Answer: Move data from RDBMS to HDFS

Question.
In a Map Reduce Program, role of combiner is

a) To combine output from multiple map tasks
b) To combine output from multiple reduce tasks
c) To merge data and create a single output file
d) To aggregate the output of each map task

Answer: To aggregate the output of each map task

Question.
Hive External tables store data in

a) default Hive warehouse location in HDFS
b) default Hive warehouse location in Local file system
c) a custom location in HDFS
d) a custom location in local file system

Answer: a custom location in HDFS

Question.
MapReduce programming model is ________

a)Platform Dependent but not language-specific
b)Neither platform- nor language-specific
c)Platform independent but language-specific
d)Platform Dependent and language-specific

Answer: Neither platform- nor language-specific

Question.
Hive generates results using

a) DAG of Map Reduce Jobs
b) sequencial processing of files
c) MySQL query engine
d) List processing

Answer: DAG of Map Reduce Jobs

Question.
Clients access the blocks directly from ________for read and write

a)data nodes
b)name node
c)secondarynamenode
d)primary node

Answer: data nodes

Question.
In Apache Pig, a Data Bag stores

a) Set of columns
b) set of columns with the same data type
c) set of columns with different data type
d) Set of tuples

Answer: set of columns with the same data type

Question.
You can execute a Pig Script in local mode using the following command

a) pig -mode local
b) pig -x local
c) pig -run local
d) pig -f

Answer: pig -x local

Question.
Default bock size in HDFS is____________

a)128 KB
b)64 KB
c)32 MB
d)128MB

Answer:128MB

Question.
Apache Flume is used to

a) Move data from RDBMS to HDFS
b) Move data from HDFS to RDBMS
c) Move data from One HDFS Cluster to another
d) Move data from Streaming source to HDFS

Answer: Move data from Streaming source to HDFS

Question.
Default data field delimiter used by Hive is

a) Ctrl-a character
b) Tab
a) Ctrl-b character
d) Space

Answer: Ctrl-a character

Question.
What are the characteristics of Big Data?

a)volume, quality, variety
b)volume,velocity, variety
c)volume, quality, quantity
d)qantity and quality only

Answer: volume,velocity, variety

Question.
Which is optional in map reduce program?

a)Mapper
b)Reducer
c)both are optional
d)both are mandatory

Answer: Reducer

Question.
In Hive tables, each table partition data is stored as ?

a) files in separate folders
b) multiple files in same folder
c) a single file
d) multiple xml files

Answer: files in separate folders

Question.
What is the default storage class in Pig Called ?

a)TextStorage
b)DefaultStorage
c)PigStorage
d)BinaryStorage

Answer: PigStorage

Question.
In a Workflow , you need to run an operating system script between two sessions. How can you best accomplish this?
a)Call from Post SQL
b)Call the script from a Command task
c)Use a custom transformation
d)Use Event raise and Event wait tasks

Answer: Call the script from a Command task

Question.
An Active Transformation :

a)Does not change the number of rows that pass through it
b)Represents the data flow between sources and targets
c)Can change the number of rows that pass through it
d)Creates a target definition based on a source definition

Answer: Can change the number of rows that pass through it

Question.
NetSal= bassic+hra. In which transformation we can achieve this?

Lookup
Expression
Filter
Aggregator

Answer: Expression

Question.
How many return ports are allowed in unconnected lookup transformation ?

3
2
1
Any number

Answer: 1

Question.
Which one is not correct about filter transformation?

Act as a 'where' condition
Can't passes multiple conditions
Act like 'Case' in pl/sql
If one record does not match condition, the record is blocked

Answer: Act as a 'where' condition

Question.
Are user-defined events supported in PowerCenter workflows?

a)No, because only File Wait events are supported in the Event-Wait task.
b)Yes, but only in workflows containing worklets.
c)No, because Event-raise tasks do not support user-defined events.
d)Yes, using a combination of Event-Raise and Event-Wait tasks

Answer: Yes, using a combination of Event-Raise and Event-Wait tasks

Question.
Every mapping must contain which of the following components :

a)Source definition
b)Target definition
c)Source definition, Target definition, Transformation, Links
d)Source and Target definition

Answer: Source definition, Target definition, Transformation, Links

Question.
Which transformation is used to combine data from different sources?

Lookup
Joiner
Union
Expression

Answer: Union

Question.
Aggregator Transformation performs :

a)calculation of values in a single row
b)concatenation of columns/ports in a row
c)aggregate calculations, such as averages and sums
d)calculations on a row-by-row basis

Answer: aggregate calculations, such as averages and sums

Question.
For triming leading & trailing spaces of a in Informatica the following function is used

a)TRIM(VALUE)
b)LTRIM(VALUE)
c)LTRIM(RTRIM(VALUE))
d)AllTRIM(VALUE)

Answer: LTRIM(RTRIM(VALUE))

Question.
In Joiner Transformation, if Master Outer Join type is used, it will :

a)Keep all rows of data from the detail source and the matching rows from the master source, and discards the unmatched rows from the master source
b)Discard all rows of data from the master and detail source that do not match, based on the condition
c)Keep all rows of data from the master source and the matching rows from the detail source, and discards the unmatched rows from the detail source
d)Keep all rows of data from both the master and detail sources

Answer: Keep all rows of data from the detail source and the matching rows from the master source, and discards the unmatched rows from the master source

Question.
Chrological details of workflow tasks can be viewed in

a)Gantt chart view
b)task view
c)Workflow view
d)we cant view chronological details in worklow monitor

Answer: Gantt chart view

Question.
Which transformation only works on relational source?

Lookup
Joiner
Union
SQL

Answer: SQL

Question.
A transformation that does not change the number of rows that pass through it, is called :

a)Passive Transformation
b)Connected Transformation
c)Mapplet
d)Source Qualifier

Answer: Passive Transformation

Question.
which command is used to execute workflow tasks from the command line

REPCMD
PMCMD
CMD
PMREP

Answer: PMCMD

Question.
Which of the following transformations does not have variable port ?

Filter
Expression
Rank
Aggregator

Answer: Filter

Question.
A set of instructions to execute tasks such as sessions, emails, shell commands etc is called :

a)Mapping
b)Load Balancer
c)Workflow
d)Transformation

Answer: Workflow

Question.
Which of the following is a type of workflow task?

Ranking
Database Bulk Loading
sorting
Event Raise

Answer: Event Raise

Question.
Which of the following is not a Active Transformation ?

Router
Filter
Sequence Generator
Update Strategy

Answer: Sequence Generator

Question.
How to execute PL/SQL script from Informatica mapping?

Lookup
Store Procdure
Expression
Non of these
Answer: Store Procdure

Question.
What is a mapplet?

Combination of reusable transformation.
Set of transformations and it allows us to reuse
None of these

Answer: Set of transformations and it allows us to reuse

Question.
Which one is not a type of  fact?

Semi-aditive
Additive
Confirm fact
Not additive

Answer: Confirm fact

Question.
Which one is not a type of dimension ?

Conformed dimension
Rapidly changing dimension
Junk dimension
Degenerated dimension

Answer: Rapidly changing dimension

Question.
What does reusable transformation mean?

It can be re-used across repositories
I can only be used in mapplet.
It can use in multiple mapping only once
It can use in multiple mapping multiple times

Answer: It can use in multiple mapping multiple times

Question.
Which one is not an option in update strategy?

dd_reject
4
2
dd_delete

Answer: 4 

Topic: IRCTC
Subject: OOAD
Task: Assignment
Subject: Object Oriented Analysis and Design
Prepared by: Srinivas


Objective and scope of the Project:
   
The objective of the Project
In order to overcome the drawback of the current IRCTC website, we have tried to offer passenger a growing facility for booking tickets which is not provided by IRCTC.

The scope of the Project

• To understand the current system and implement the software with the current system.
• To execute the software without any problems or error without creating any complications.
• Automating the set.

• The proposed system is fully computerized, making ticket booking easier and cheaper.
• It provides the user with more options for traveling.
• According to the user's trust, you can book tickets between the source and the destination by breaking the journey in two half.
• The price is calculated on the basis of the end to end distance rather than calculating for two different transaction.
• The second part of the journey should start within 48 hours of the first part of the journey. The ticket for the second part of the trip is invalid without the first part of the trip.
• A senior citizen is provided with discount only if they have valid ID proof of their age. 
• The ticket can be printed and downloaded in pdf format.

 UML DIAGRAM:

• GRASP defines General Responsibility Assignment Software Patterns.
• A collection of general objected‐oriented design patterns related to assigning defining objects.
• There are nine GRASP patterns, maybe some are already recognizable and some not:

1. Creator 
2. Information Expert (or just Expert) 
3. Low Coupling 
4. Controller 
5. High Cohesion 
6. Polymorphism 
7. Pure Fabrication
8. Indirection 
9. Protected Variations.