Datastage,Db2,MicroStrategy
.
- 1.
DataStage is
- A.
ETL Tool
- B.
Metadata Tool
- C.
BI Tool
- D.
None of the Options
Correct Answer
A. ETL Tool -
- 2.
Order of execution in DataStage
- A.
Stage Variable -----> Constraints ---------> Derivations
- B.
Constraints ----->Stage Variable ---------> Derivations
- C.
Derivations -----> Constraints ---------> Stage Variable
- D.
Stage Variable ----->Derivations ---------> Constraints
Correct Answer
A. Stage Variable -----> Constraints ---------> Derivations -
- 3.
How many Client tools are there in DataStage?
- A.
5
- B.
6
- C.
4
- D.
3
Correct Answer
C. 4 -
- 4.
Which client tool is used to schedule, run and validate the job
- A.
DS Director
- B.
DS Administrator
- C.
DS Designer
- D.
DS Manager
Correct Answer
A. DS Director -
- 5.
Which client tool is used to create or move the projects?
- A.
DS Administrator
- B.
DS Designer
- C.
DS Director
- D.
DS Manager
Correct Answer
A. DS Administrator -
- 6.
Which client tool is used to import and export components?
- A.
DS Manager
- B.
DS Adminiastrator
- C.
DS Designer
- D.
DS Director
Correct Answer
A. DS Manager -
- 7.
Which client tool is used to view or edit repository data?
- A.
DS Manager
- B.
DS Administrator
- C.
DS Designer
- D.
DS director
Correct Answer
A. DS Manager -
- 8.
How many numbers of DataStage Server tools are there?
- A.
5
- B.
6
- C.
3
- D.
2
Correct Answer
C. 3 -
- 9.
Select the server component of DataStage
- A.
Repository
- B.
DataStage Server
- C.
DataStage Package Installer
- D.
DS administrator
- E.
DS Manager
- F.
DS Designer
Correct Answer(s)
A. Repository
B. DataStage Server
C. DataStage Package Installer -
- 10.
Select Client Components
- A.
DS Administrator
- B.
DS Manager
- C.
DS Designer
- D.
DS Director
Correct Answer(s)
A. DS Administrator
B. DS Manager
C. DS Designer
D. DS Director -
- 11.
How many input links are there in DataStage?
- A.
2
- B.
4
- C.
3
- D.
5
Correct Answer
A. 2 -
- 12.
Which input link is represented in dotted line
- A.
Stream Input link
- B.
References Input Link
- C.
Both Stream and Referenced
- D.
None
Correct Answer
B. References Input Link -
- 13.
Select true facts about stream input links
- A.
It is represented by solid line
- B.
It represents table reference of lookup
- C.
It represents flow of data
- D.
It is used by both active and Passive Stage
- E.
It is represented by dotted line
Correct Answer(s)
A. It is represented by solid line
C. It represents flow of data
D. It is used by both active and Passive Stage -
- 14.
Select true about reference input link
- A.
It represented by dotted line
- B.
It represents table reference lookup
- C.
It is used by only active state jobs
- D.
None of theotions
Correct Answer(s)
A. It represented by dotted line
B. It represents table reference lookup
C. It is used by only active state jobs -
- 15.
Auto Purge is used to
- A.
Delete log file automatically
- B.
Delete Metadata automatically
- C.
Keep log file in table
- D.
None
Correct Answer
A. Delete log file automatically -
- 16.
How many stages are there in DataStage?
- A.
2
- B.
4
- C.
6
- D.
8
Correct Answer
A. 2 -
- 17.
Select Active stage component
- A.
Transformer
- B.
Aggregrator
- C.
ODBC
- D.
Hashed File
Correct Answer(s)
A. Transformer
B. Aggregrator -
- 18.
Select components of passive stage
- A.
ODBC
- B.
ORACLE
- C.
Universe
- D.
Hashed
- E.
Sequential
- F.
Inter-Process
Correct Answer(s)
A. ODBC
B. ORACLE
C. Universe
D. Hashed
E. Sequential
F. Inter-Process -
- 19.
Which passive stage component act as intermediate for quick look up
- A.
Hashed File
- B.
Inter-process
- C.
ODBC
- D.
ORACLE
Correct Answer
A. Hashed File -
- 20.
Which edition of DataStage is for mainframe system?
- A.
MVS
- B.
Server
- C.
Enterprise
- D.
DataStage for PeopleSoft
Correct Answer
A. MVS -
- 21.
Which edition of DataStage supports complex transaction
- A.
MVS
- B.
Server
- C.
DS TX
- D.
DS for PeopleSoft
Correct Answer
C. DS TX -
- 22.
Which edition of DataStage can supports both Parallel and Server jobs
- A.
Enterprise Edition
- B.
MVS Edition
- C.
DS Tx
- D.
DS for PeopleSoft
Correct Answer
A. Enterprise Edition -
- 23.
Cache size can be changed in
- A.
DS Administrator
- B.
DS Designer
- C.
DS Director
- D.
DS Manager
Correct Answer
A. DS Administrator -
- 24.
When we import a job, the job will be in which state?
- A.
Not compiled state
- B.
Aborted state
- C.
State while exported
Correct Answer
A. Not compiled state -
- 25.
Iconv is used to convert string into internal storage format.
- A.
True
- B.
False
Correct Answer
A. True -
- 26.
Which command is used to convert an expression to output format?
- A.
ICONV
- B.
OCONV
- C.
Both OCONV and ICONV
- D.
None of these
Correct Answer
B. OCONV -
- 27.
If a primary key uses multiple columns to identify a record then it is known as compound key.
- A.
True
- B.
False
Correct Answer
A. True -
- 28.
From where to import DS sources?
- A.
ERP application
- B.
Mainframe datasets
- C.
Flat file
Correct Answer(s)
A. ERP application
B. Mainframe datasets
C. Flat file -
- 29.
In which of the following stages a job cannot be run?
- A.
Abort
- B.
Compiled
- C.
None of the Options
Correct Answer
A. Abort -
- 30.
What is the default connection timed out time in DataStage?
- A.
86400
- B.
84600
- C.
10000
- D.
Never Time Out
Correct Answer
A. 86400 -
- 31.
Which client tool is used to see CPU utilization in DataStage?
- A.
DataStage Director
- B.
DataStage Administrator
- C.
DataStage Designer
- D.
None of the Options
Correct Answer
A. DataStage Director -
- 32.
Which client component is used to grant permission ?
- A.
DS Administrator
- B.
DS Manager
- C.
DS Director
- D.
DS Designer
Correct Answer
A. DS Administrator -
- 33.
Fast export is used to export all the data
- A.
True
- B.
False
Correct Answer
B. False -
- 34.
Which unix command is used to start a DataStage job ?
- A.
Dsjob
- B.
Dsrun
- C.
Dsstop
- D.
Dsstart
Correct Answer
A. Dsjob -
- 35.
The Datastage home directory location will always be specified in the “.dshome”
- A.
True
- B.
False
Correct Answer
A. True -
- 36.
Not a DB2 license method
- A.
Memory
- B.
CPU
- C.
No of User
Correct Answer
A. Memory -
- 37.
Select true about locklist
- A.
Memory that holds information about locks held by all applications concurrently connected to the database
- B.
Increase this value if there is a problem with lock escalation.
Correct Answer
A. Memory that holds information about locks held by all applications concurrently connected to the database -
- 38.
Select the product line of DB2 version 9
- A.
DB2 Express
- B.
DB2 Workgroup
- C.
DB2 Enterprise Edition
Correct Answer(s)
A. DB2 Express
B. DB2 Workgroup
C. DB2 Enterprise Edition -
- 39.
Table can span across table space
- A.
True
- B.
False
Correct Answer
A. True -
- 40.
Instance can have multiple databases.
- A.
True
- B.
False
Correct Answer
A. True -
- 41.
Database manager Configuration parameter file name is
- A.
DB2SYSTEM
- B.
SQLDBCON
Correct Answer
A. DB2SYSTEM -
- 42.
Coordinator Agent provides service to DB2 agents.
- A.
True
- B.
False
Correct Answer
A. True -
- 43.
Database configuration parameter is
- A.
SQLDBCON
- B.
DB2SYSTEM
Correct Answer
A. SQLDBCON -
- 44.
Which of the below can access data from bufferpool
- A.
Sub-Agent
- B.
Coordinator Agent
- C.
DB2 Agent
- D.
None
Correct Answer
A. Sub-Agent -
- 45.
Select correct options about page cleaner
- A.
It operates Independently
- B.
It is asynchronous
- C.
It cleans the data from bufferpool that is not needed
- D.
It holds data at BP
Correct Answer(s)
A. It operates Independently
B. It is asynchronous
C. It cleans the data from bufferpool that is not needed -
- 46.
Log strategies are in DB2 is
- A.
Circular Logging
- B.
Retain Logging
- C.
Both Circular and Retain Logging
- D.
None of these
Correct Answer
C. Both Circular and Retain Logging -
- 47.
Container is file, directory, raw device where data actually stored
- A.
True
- B.
False
Correct Answer
A. True -
- 48.
TS made up of one or more containers
- A.
True
- B.
False
Correct Answer
A. True -
- 49.
A table space can span across in multiple containers
- A.
True
- B.
False
Correct Answer
A. True -
- 50.
System managed space and data managed space are two types of table sapce
- A.
True
- B.
False
Correct Answer
A. True -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Feb 28, 2017Quiz Edited by
ProProfs Editorial Team -
Feb 21, 2017Quiz Created by
Arafatkazi
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
- Software Quizzes
Back to top