IBM IBM Certified System Administrator A2090-619 Questions & Answers

• Question 21:

  Which statement accurately describes the mapped user functionality in Informix?

  A. The DBSA can control the access to the database at the table level by creating different security labels for each user.

  B. The DBSA can create different roles for each user in order to verify whether the user who is attempting an operation has the necessary privileges.

  C. The DBSA can configure the server to allow database access by external users who do not have operating system accounts on the host computer.

  D. The DBSA can grant access to the database server to users of the host computer operating system by implementing different authentication mechanisms for each user.

  Correct Answer: C

• Question 22:

  Which parameter can automatically adjust other configuration parameters that are not present in the configuration file?

  A. AUTO_PERF

  B. AUTO_TUNE

  C. AUTO_CONFIG

  D. AUTO_ENABLE

  Correct Answer: B

• Question 23:

  Which is NOT a feature of onbar backups?

  A. The ability to parallelize backups.

  B. The ability to do a point-in-time restore.

  C. The ability to backup without a storage manager.

  D. The ability to do an external backup using a Storage Area Network.

  Correct Answer: C

• Question 24:

  Which one keyword in this query makes the AVG an OLAP window expression instead of the regular aggregate operator? SELECT AVG(SUM(dollars)) OVER() FROM sales;

  A. SUM

  B. OVER

  C. FROM

  D. AVG (SUM(dollars))

  Correct Answer: B

• Question 25:

  What data migration tool(s) should be used to load data from a non-Informix data source?

  A. dbimport

  B. onload and dbload

  C. dbload and High Performance Loader

  D. onload and High Performance Loader

  Correct Answer: C

• Question 26:

  Which two parameters are mandatory when running "ifxclone"? (Choose two.)

  A. Target server instance size.

  B. Target server instance name.

  C. Source server instance sqlhosts.

  D. Target server configuration parameters.

  E. Source server instance TCP/IP address.

  Correct Answer: BE

• Question 27:

  Which statement is FALSE about dbspace configurable page sizes?

  A. Dbspace page size can only be set for non-critical dbspaces.

  B. Possible page sizes are multiples of the default page size up to 16 kb.

  C. Configure page sizes as close to the backup / restore and network buffer size as possible for efficient data transfer across the wire.

  D. Dbspace page size should be configured to accommodate the greatest number of average row sizes with a minimum of remainder pages being used.

  Correct Answer: C

• Question 28:

  Which statement is true for starting Connection Manager?

  A. Only user root and informix.

  B. Any user of the DBSA group.

  C. Any user who is granted privileges to connect to the sysadmin database.

  D. Only a user of the DBSA group with privilege to connect to the sysadmin database.

  Correct Answer: D

• Question 29:

  Which is NOT a component of the IBM Mobile Database offering?

  A. IBM DB2

  B. IBM Informix

  C. IBM solidDB

  D. IBM InfoSphere Warehouse

  Correct Answer: D

• Question 30:

  Which Informix utility can be used to display contents of logical-log files, either from disk or from backup?

  A. onlog

  B. onclean

  C. ondblog

  D. onspaces

  Correct Answer: A