Most frequently asked System Administration Multiple Choice Questions and Answers for Freshers
1. Which of the following administrative thinkers has defined administration as "the organization and direction of human and material resources to achieve desired ends" ?
2. Which one of the following statements is not correct in respect of New Public Management ?
3. 'Good Governance' and 'Participating Civil Society for Development' were stressed in World Bank Report of—
4. If the administrative authority within a department is vested in a single individual, then that system is known as ______.
5. Globalisation means _______.
6. By whom was the 'Managerial Grid' developed ?
7. Who among the following says that public administration includes the operations of only the executive branch of government ?
8. The concept of the 'zone of indifference' is associated with—
9. Who has analyzed the leadership in terms of 'circular response' ?
10. Simon proposed a new concept of administration based on the methodology of—
11. Who wrote the book 'Towards A New Public Administration : The Minnowbrook Perspective' ?
12. Who rejected the principles of administration as 'myths' and 'proverbs' ?
13. The classical theory of administration is also known as the—
14. How many principles of organization were propounded by Henry Fayol ?
15. Simon was positively influenced by ideas of—
16. Negative motivation is based on—
17. 'Job loading' means—
18. The theory of 'Prismatic Society' in Public Administration is based on—
19. Who among the following is an odd thinker ?
20. Which of the following is not included in 'hygiene' factors in the Herzberg's two-factor theory of motivation ?
21. What should a system administrator use to disable access to a custom application for a group of users?
22. Universal Containers needs to track the manufacturer and model for specific car companies. How can the system administrator ensure that the manufacturer selected influences the values available for the model?
23. Sales representatives at Universal Containers need assistance from product managers when selling certain products. Product managers do not have access to opportunities, but need to gain access when they are assisting with a specific deal. How can a system administrator accomplish this?
24. What should a system administrator consider before importing a set of records into Salesforce? There are two correct answers..
25. Which statement about custom summary formulas in reports is true? There are two correct answers..
26. Which of the following utilities provides a report of memory status for instances, databases, and agents?
27. Given the following notification log entry:In order to determine the name of the application which encountered the error, which of the following actions must be taken?
28. Given the table MYTAB:
29. Which of the following REORG table options will compress the data in a table using the existing compression dictionary?
30. Which of the following statements about SCHEMA objects is true?
31. An iseries server with domino and Websphere Commerce suite installed is performing well, except when the Domino or Websphere servers are starting. Which of the following is the most likely cause of the performance problem.
32. A system administrator needs to add 100 users to a V6R2 system without impacting response times, Which of the following would be the first step in determining the current performance of the system?
33. A batch subsystem is established to run jobs from multiple queues, An application submits two jobs to each queue. All jobs are in release status. Which of the following is the reason that only three jobs have started to run?
34. What command is used to save the IFS to taps?
35. A Manufacturing company has three remote sites and a total of six distributed AS/400 systems. The company would like to accomplish the followings.
36. Which of the following can have an impact on determining the interactive workload requirements of an iSeries?
37. On a system that does not have Performance Tools for iSeries 5722-PTI., how can performance data be collected for analysis on a different system that has Performance Tools installed.
38. Which of the following commands will save all objects in the IFS?
39. Which system performance command can send output to both the online serene and a database file simultaneously.
40. Using the example below, what is the cumulative PTF level of the system?
41. Job description FREDJOBD has public authority of USE. This job description specifies that jobs run under user profile FRED. Which has public authority EXCLUDE*. Use profile SUE is user class USER* with default special authorities and does not have specific authority to use profile FRED. User which security levels would user profile SUE be able to successfully submit a job using PREDJOBD with the intent to run the job under user profile FRED?
42. On an iSeries running V5R2, which fo the following authorities needs to be removed from an object to ensure that the object owner cannot delete it?
43. Which of the following disk drive considerations has the greatest impact on system performance?
44. Which of the following will enable an administrator to establish an ongoing analysis of the performance and utilization of an iSeries.
45. Users are reporting long response time delays in transactions that previously would run with sunscald response.The system administrator knows these transactions are RPG IV-SQL based programs. Which of the following would be the first set in determining the problems.
46. A system administrator wants to collect performance data for multiple iSeries servers in a network. When attempting to start performance collection using iSeries Navigator, collection services fail. Which of the following is the most likely cause of the problem.
47. Which of the following can be adjusted daily by a scheduled job to maximize interactive or bath throughput?
48. Which of the following would the most viable course of action?
49. Which of the following should be considered when preparing for a release upgrade?
50. An iSeries Administrator would like to monitor the performance of all four of the machines in the data center at one time. If a certain level of interactive CPU is reached, the administrator wants to receive an email. What needs to be done to satisfy the requirements.
51. A DBA wishes to audit all access to the non-audited table OWNER.EMPLOYEE. Assuming no audit traces are started, which of the following steps are needed to audit access to this table?
52. A company uses TRUSTED CONTEXT "ERP1" and ROLE "ERP_ROLE" as a security mechanism to limit security exposure for an application. All the DB2 objects databases, table spaces, tables, indexes, views, plans and packages. have been created by that ROLE. The ROLE "ERP_ROLE" has been assigned to User ID "DBA01" in order to perform DBA related tasks. When the user "DBA01" leaves the company, the authorization ID is removed. Which of the following statements are correct? Select two answers.
53. At which of the following times is the access control authorization routine DSNX@XAC. invoked?
54. If an object is created statically by a role within a trusted context and the ROLE AS OBJECT OWNER clause is specified, who becomes the object owner when executing the package?
55. A DBA needs to use the DSN command processor to delete DB2 packages that are no longer needed. Which of the following choices is correct for the DBA to use?
56. Which of the following tools is used to create subscription sets and add subscription-set members to subscription sets?
57. Given the following table definition:
58. Which of the following DB2 data types CANNOT be used to contain the date an employee was hired?
59. A table called EMPLOYEE has the following columns:
60. Which two of the following SQL data types should be used to store a small binary image?
61. Which of the following CLI/ODBC functions should be used to delete rows from a DB2 table?
62. Given the tables T1 and T2 with INTEGER columns:How many rows will be left in T1 after running this statement?
63. Given the following code:EXEC SQL EXECUTE IMMEDIATE :sqlstmtWhich of the following values must sqlstmt contain so that all rows are deleted from the STAFF table?
64. An ODBC/CLI application executes the following batch SQL:SQLExecDirect hStmt, "SELECT c1 FROM t1; SELECT c2 FROM t2;" SQL_NTS .;Which API is used to discard the first result set and make the second available for processing?
65. Given the table T1 with the following data:What is the final content of the host variable "hv"?
66. Which of the following is required to specify the output data during an EXPORT?
67. On which of the following event types can a WHERE clause be used to filter the data returned by the event monitor?
68. Given an application with the embedded static SQL statement:INSERT INTO admin.payroll employee, salary. VALUES "Becky Smith",80000.Which of the following privileges must a user hold to run the application?
69. Assuming a user has CREATETAB privileges, which of the following privileges will allow the user to create a table T2 with a foreign key that references table T1?
70. Which of the following statements is required to register a federated database source?
71. Which two of the following can be done to a buffer pool using the ALTER BUFFERPOOL statement?
72. A table is defined using DMS table spaces with its index, data, and long data separated into different table spaces. The table space containing the table data is restored from a backup image.Which of the table's other table spaces must also be restored in order to roll forward to a point in time prior to the end of the logs?
73. In a federated system, a userid is used for the CREATE SERVER definition at the DB2 data source.Which of the following privileges should it have?
74. Which of the following can enable multiple prefetchers for table spaces with a single container?
75. Given a single physical server with a single OS image utilizing 24 CPUs and configured with 12 database partitions, how many of the database partitions can act as coordinator partitions for remote applications?
76. When using AUTOCONFIGURE and a workload that is of type OLTP, what should be used for the workload_type parameter?
77. To determine the state of a table space and the location of all containers for that table space, which of the following commands would be used?
78. The following command is issued:LOAD FROM staff.ixf OF IXF REPLACE INTO staffWhat locks are help during the execution of this load?
79. Use the exhibit button to display the exhibit for this question.What is indicated by the output from the Health Monitor in the exhibit?
80. In a system set up for dual logging, to change the location of the second set of logs from c:logpath2 to d:seclogpath, which of the following commands should be used?
1. Which of the following administrative thinkers has defined administration as "the organization and direction of human and material resources to achieve desired ends" ?
2. Which one of the following statements is not correct in respect of New Public Management ?
3. 'Good Governance' and 'Participating Civil Society for Development' were stressed in World Bank Report of—
4. If the administrative authority within a department is vested in a single individual, then that system is known as ______.
5. Globalisation means _______.
6. By whom was the 'Managerial Grid' developed ?
7. Who among the following says that public administration includes the operations of only the executive branch of government ?
8. The concept of the 'zone of indifference' is associated with—
9. Who has analyzed the leadership in terms of 'circular response' ?
10. Simon proposed a new concept of administration based on the methodology of—
11. Who wrote the book 'Towards A New Public Administration : The Minnowbrook Perspective' ?
12. Who rejected the principles of administration as 'myths' and 'proverbs' ?
13. The classical theory of administration is also known as the—
14. How many principles of organization were propounded by Henry Fayol ?
15. Simon was positively influenced by ideas of—
16. Negative motivation is based on—
17. 'Job loading' means—
18. The theory of 'Prismatic Society' in Public Administration is based on—
19. Who among the following is an odd thinker ?
20. Which of the following is not included in 'hygiene' factors in the Herzberg's two-factor theory of motivation ?
21. What should a system administrator use to disable access to a custom application for a group of users?
22. Universal Containers needs to track the manufacturer and model for specific car companies. How can the system administrator ensure that the manufacturer selected influences the values available for the model?
23. Sales representatives at Universal Containers need assistance from product managers when selling certain products. Product managers do not have access to opportunities, but need to gain access when they are assisting with a specific deal. How can a system administrator accomplish this?
24. What should a system administrator consider before importing a set of records into Salesforce? There are two correct answers..
25. Which statement about custom summary formulas in reports is true? There are two correct answers..
26. Which of the following utilities provides a report of memory status for instances, databases, and agents?
27. Given the following notification log entry:In order to determine the name of the application which encountered the error, which of the following actions must be taken?
28. Given the table MYTAB:
29. Which of the following REORG table options will compress the data in a table using the existing compression dictionary?
30. Which of the following statements about SCHEMA objects is true?
31. An iseries server with domino and Websphere Commerce suite installed is performing well, except when the Domino or Websphere servers are starting. Which of the following is the most likely cause of the performance problem.
32. A system administrator needs to add 100 users to a V6R2 system without impacting response times, Which of the following would be the first step in determining the current performance of the system?
33. A batch subsystem is established to run jobs from multiple queues, An application submits two jobs to each queue. All jobs are in release status. Which of the following is the reason that only three jobs have started to run?
34. What command is used to save the IFS to taps?
35. A Manufacturing company has three remote sites and a total of six distributed AS/400 systems. The company would like to accomplish the followings.
36. Which of the following can have an impact on determining the interactive workload requirements of an iSeries?
37. On a system that does not have Performance Tools for iSeries 5722-PTI., how can performance data be collected for analysis on a different system that has Performance Tools installed.
38. Which of the following commands will save all objects in the IFS?
39. Which system performance command can send output to both the online serene and a database file simultaneously.
40. Using the example below, what is the cumulative PTF level of the system?
41. Job description FREDJOBD has public authority of USE. This job description specifies that jobs run under user profile FRED. Which has public authority EXCLUDE*. Use profile SUE is user class USER* with default special authorities and does not have specific authority to use profile FRED. User which security levels would user profile SUE be able to successfully submit a job using PREDJOBD with the intent to run the job under user profile FRED?
42. On an iSeries running V5R2, which fo the following authorities needs to be removed from an object to ensure that the object owner cannot delete it?
43. Which of the following disk drive considerations has the greatest impact on system performance?
44. Which of the following will enable an administrator to establish an ongoing analysis of the performance and utilization of an iSeries.
45. Users are reporting long response time delays in transactions that previously would run with sunscald response.The system administrator knows these transactions are RPG IV-SQL based programs. Which of the following would be the first set in determining the problems.
46. A system administrator wants to collect performance data for multiple iSeries servers in a network. When attempting to start performance collection using iSeries Navigator, collection services fail. Which of the following is the most likely cause of the problem.
47. Which of the following can be adjusted daily by a scheduled job to maximize interactive or bath throughput?
48. Which of the following would the most viable course of action?
49. Which of the following should be considered when preparing for a release upgrade?
50. An iSeries Administrator would like to monitor the performance of all four of the machines in the data center at one time. If a certain level of interactive CPU is reached, the administrator wants to receive an email. What needs to be done to satisfy the requirements.
51. A DBA wishes to audit all access to the non-audited table OWNER.EMPLOYEE. Assuming no audit traces are started, which of the following steps are needed to audit access to this table?
52. A company uses TRUSTED CONTEXT "ERP1" and ROLE "ERP_ROLE" as a security mechanism to limit security exposure for an application. All the DB2 objects databases, table spaces, tables, indexes, views, plans and packages. have been created by that ROLE. The ROLE "ERP_ROLE" has been assigned to User ID "DBA01" in order to perform DBA related tasks. When the user "DBA01" leaves the company, the authorization ID is removed. Which of the following statements are correct? Select two answers.
53. At which of the following times is the access control authorization routine DSNX@XAC. invoked?
54. If an object is created statically by a role within a trusted context and the ROLE AS OBJECT OWNER clause is specified, who becomes the object owner when executing the package?
55. A DBA needs to use the DSN command processor to delete DB2 packages that are no longer needed. Which of the following choices is correct for the DBA to use?
56. Which of the following tools is used to create subscription sets and add subscription-set members to subscription sets?
57. Given the following table definition:
58. Which of the following DB2 data types CANNOT be used to contain the date an employee was hired?
59. A table called EMPLOYEE has the following columns:
60. Which two of the following SQL data types should be used to store a small binary image?
61. Which of the following CLI/ODBC functions should be used to delete rows from a DB2 table?
62. Given the tables T1 and T2 with INTEGER columns:How many rows will be left in T1 after running this statement?
63. Given the following code:EXEC SQL EXECUTE IMMEDIATE :sqlstmtWhich of the following values must sqlstmt contain so that all rows are deleted from the STAFF table?
64. An ODBC/CLI application executes the following batch SQL:SQLExecDirect hStmt, "SELECT c1 FROM t1; SELECT c2 FROM t2;" SQL_NTS .;Which API is used to discard the first result set and make the second available for processing?
65. Given the table T1 with the following data:What is the final content of the host variable "hv"?
66. Which of the following is required to specify the output data during an EXPORT?
67. On which of the following event types can a WHERE clause be used to filter the data returned by the event monitor?
68. Given an application with the embedded static SQL statement:INSERT INTO admin.payroll employee, salary. VALUES "Becky Smith",80000.Which of the following privileges must a user hold to run the application?
69. Assuming a user has CREATETAB privileges, which of the following privileges will allow the user to create a table T2 with a foreign key that references table T1?
70. Which of the following statements is required to register a federated database source?
71. Which two of the following can be done to a buffer pool using the ALTER BUFFERPOOL statement?
72. A table is defined using DMS table spaces with its index, data, and long data separated into different table spaces. The table space containing the table data is restored from a backup image.Which of the table's other table spaces must also be restored in order to roll forward to a point in time prior to the end of the logs?
73. In a federated system, a userid is used for the CREATE SERVER definition at the DB2 data source.Which of the following privileges should it have?
74. Which of the following can enable multiple prefetchers for table spaces with a single container?
75. Given a single physical server with a single OS image utilizing 24 CPUs and configured with 12 database partitions, how many of the database partitions can act as coordinator partitions for remote applications?
76. When using AUTOCONFIGURE and a workload that is of type OLTP, what should be used for the workload_type parameter?
77. To determine the state of a table space and the location of all containers for that table space, which of the following commands would be used?
78. The following command is issued:LOAD FROM staff.ixf OF IXF REPLACE INTO staffWhat locks are help during the execution of this load?
79. Use the exhibit button to display the exhibit for this question.What is indicated by the output from the Health Monitor in the exhibit?
80. In a system set up for dual logging, to change the location of the second set of logs from c:logpath2 to d:seclogpath, which of the following commands should be used?
