Datastage,Db2,MicroStrategy

69 Questions | Attempts: 289
Please wait...
Question 1 / 70
🏆 Rank #-- ▾
Score 0/100

1. DataStage is 

Submit
Please wait...
About This Quiz
Database Quizzes & Trivia

.

2.

What first name or nickname would you like us to use?

You may optionally provide this to label your report, leaderboard, or certificate.

2. TS made up of one or more containers

Submit

3. System managed space and data managed space are two types of table sapce

Submit

4. The Datastage home directory location will always be specified in the ".dshome" 

Submit

5. Coordinator Agent provides service to DB2 agents.

Submit

6. Table can span across table space

Submit

7. Instance can have multiple databases. 

Submit

8. Iconv is used to convert string into internal storage format.

Submit

9. Which input link is represented in dotted line

Submit

10. In which of the following stages a job cannot be run?

Submit

11. If a primary key uses multiple columns to identify a record then it is known as compound key.

Submit

12. Container is file, directory, raw device where data actually stored

Submit

13. A table space can span across in multiple containers

Submit

14. Smallest unit of hard disk that database will read or write is page

Submit

15. Database partition is known as 

Submit

16. Which unix command is used to start a DataStage job ?

Submit

17. Which client component is used to grant permission ?

Submit

18. Lock escalation reduces concurrency

Submit

19. Which utility is used to export data from database to an external OS file

Submit

20. Select true about locklist

Submit

21. Which client tool is used to schedule, run and validate the job

Submit

22. Exported file does not contain table structure details so it cannot be used for table recreation

Submit

23. Database manager Configuration parameter file name is 

Submit

24. Which edition of DataStage can supports both Parallel and Server jobs

Submit

25. Log strategies are in DB2 is

Submit

26. Order of execution in DataStage

Submit

27. Auto Purge is used to 

Submit

28. How many Client tools are there in DataStage? 

Submit

29. How many input links are there in DataStage?

Submit

30. When we import a job, the job will be in which state?

Submit

31. Which client tool is used to create or move the projects?

Submit

32. Effects of locking improves concurrency and degrades performance

Submit

33. Select Client Components

Submit

34. Select Active stage component

Submit

35. Which passive stage component act as intermediate for quick look up

Submit

36. How many numbers of DataStage Server tools are there?

Submit

37. Which edition of DataStage supports complex transaction

Submit

38. Cache size can be changed in 

Submit

39. How many types of locking are available in DB2?

Submit

40. Select true facts about stream input links

Submit

41. Which command is used to convert an expression to output format?

Submit

42. Levels of Locking in Db2

Submit

43. Which client tool is used to view or edit repository data?

Submit

44. What is the default connection timed out time in DataStage?

Submit

45. Select true about reference input link

Submit

46. Select DDL commands 

Submit

47. Too many row level locks in a particular table can convert one table to table level lock is known as

Submit

48. Match the Following

Submit

49. Which edition of DataStage is for mainframe system?

Submit

50. Database configuration parameter is 

Submit

51. Which client tool is used to see CPU utilization in DataStage?

Submit

52. How many stages are there in DataStage? 

Submit

53. Select the server component of DataStage

Submit

54. Not a DB2 license method

Submit

55. A container is not a

Submit

56. From where to import DS sources?

Submit

57. The No. of CPUs used in DB2 Workgroup Edition

Submit

58. Select the product line of DB2 version 9

Submit

59. Select components of passive stage 

Submit

60. Which client tool is used to import and export components?

Submit

61. Fast export is used to export all the data

Submit

62. Isolation levels in DB2 are

Submit

63. Select correct options about page cleaner

Submit

64. Default page size(in KB) in DB2?

Submit

65. Which of the below can  access data from bufferpool

Submit

66. The No. of CPUs used in DB2 Enterprise edition

Submit

67. Data format that supported by import utility

Submit

68. Data format that supported by export utility

Submit

69. File format supported by Load utility 

Submit
×
Saved
Thank you for your feedback!
View My Results
Cancel
  • All
    All (69)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
DataStage is 
TS made up of one or more containers
System managed space and data managed space are two types of table...
The Datastage home directory location will always be specified in the...
Coordinator Agent provides service to DB2 agents.
Table can span across table space
Instance can have multiple databases. 
Iconv is used to convert string into internal storage format.
Which input link is represented in dotted line
In which of the following stages a job cannot be run?
If a primary key uses multiple columns to identify a record then it is...
Container is file, directory, raw device where data actually stored
A table space can span across in multiple containers
Smallest unit of hard disk that database will read or write is page
Database partition is known as 
Which unix command is used to start a DataStage job ?
Which client component is used to grant permission ?
Lock escalation reduces concurrency
Which utility is used to export data from database to an external OS...
Select true about locklist
Which client tool is used to schedule, run and validate the job
Exported file does not contain table structure details so it cannot be...
Database manager Configuration parameter file name is 
Which edition of DataStage can supports both Parallel and Server jobs
Log strategies are in DB2 is
Order of execution in DataStage
Auto Purge is used to 
How many Client tools are there in DataStage? 
How many input links are there in DataStage?
When we import a job, the job will be in which state?
Which client tool is used to create or move the projects?
Effects of locking improves concurrency and degrades performance
Select Client Components
Select Active stage component
Which passive stage component act as intermediate for quick look up
How many numbers of DataStage Server tools are there?
Which edition of DataStage supports complex transaction
Cache size can be changed in 
How many types of locking are available in DB2?
Select true facts about stream input links
Which command is used to convert an expression to output format?
Levels of Locking in Db2
Which client tool is used to view or edit repository data?
What is the default connection timed out time in DataStage?
Select true about reference input link
Select DDL commands 
Too many row level locks in a particular table can convert one table...
Match the Following
Which edition of DataStage is for mainframe system?
Database configuration parameter is 
Which client tool is used to see CPU utilization in DataStage?
How many stages are there in DataStage? 
Select the server component of DataStage
Not a DB2 license method
A container is not a
From where to import DS sources?
The No. of CPUs used in DB2 Workgroup Edition
Select the product line of DB2 version 9
Select components of passive stage 
Which client tool is used to import and export components?
Fast export is used to export all the data
Isolation levels in DB2 are
Select correct options about page cleaner
Default page size(in KB) in DB2?
Which of the below can  access data from bufferpool
The No. of CPUs used in DB2 Enterprise edition
Data format that supported by import utility
Data format that supported by export utility
File format supported by Load utility 
play-Mute sad happy unanswered_answer up-hover down-hover success oval cancel Check box square blue
Alert!