IBM IBM Certified System Administrator A2090-619 Questions & Answers

• Question 71:

  Which command line utility does NOT have the equivalent functionality using the SQL Administration API?

  A. oninit

  B. onmode

  C. onspaces

  D. onparams

  Correct Answer: A

• Question 72:

  The following message is received: Lock table overflow - user id user32, session id 54. What action should be taken to prevent this problem in the future?

  A. Run onclean utility to clear the lock table.

  B. Increase the LOCKS configuration parameter.

  C. Turn on the AUTO_TUNE configuration parameter.

  D. Change the DEF_TABLE_LOCKMODE configuration parameter from page to row.

  Correct Answer: B

• Question 73:

  Which approach is always valid when migrating data across differing hardware and operating system architectures?

  A. dbexport source system then dbimport into target.

  B. ontape backup from source then restore backup onto target.

  C. onunload the source to tape and onload the tape to the target.

  D. Set up HDR primary and secondary between source and target.

  Correct Answer: A

• Question 74:

  In an organization, all employees are authenticated via domain wide Kerberos single sign- on. The DBSA wants to provide access to the database server for an employee without requesting the Operating System (OS) administrator to create a OS level user account. Which Informix feature does the DBSA need to leverage?

  A. Mapped users

  B. Role based users

  C. Table level access for users

  D. Label based access for users

  Correct Answer: A

• Question 75:

  Which statement is true regarding default roles?

  A. The DBSA can define a default role to assign only to the PUBLIC group for a particular database.

  B. The privileges associated with a default role takes precedence over the privileges granted to an individual user.

  C. The DBSA can define a default role to assign to individual users or to the PUBLIC group for a particular database.

  D. When a user connects to a database, it is necessary to use the SET ROLE DEFAULT statement in order to gain the default role privileges.

  Correct Answer: C

• Question 76:

  What kinds of Table Level Restores can be done by the archecker utility?

  A. Only logical restore.

  B. Only physical restore.

  C. Only point in time restore.

  D. Physical, logical, and point in time restores.

  Correct Answer: D

• Question 77:

  Given the following:

  

  How many locks will be used on tab1 to run the query?

  A. 0

  B. 1

  C. 2

  D. Depends on the number of index pages accessed

  Correct Answer: A

• Question 78:

  Which object can be compressed?

  A. dictionary table

  B. temporary table

  C. attached b-tree index

  D. detached b-tree index

  Correct Answer: D

• Question 79:

  Which HDR configuration parameter provides three synchronization modes to control when transaction commits are returned to client applications?

  A. DELAY_APPLY

  B. HDR_TXN_SCOPE

  C. LOG_INDEX_BUILDS

  D. FAILOVER_TX_TIMEOUT

  Correct Answer: B

• Question 80:

  Which objects can be compressed?

  A. CLOBs

  B. smart BLOBs

  C. partition BLOBs

  D. blobspace BLOBs

  Correct Answer: C