IBM C2090-619 Online Practice Questions and Exam Preparation

IBM C2090-619 Online Questions & Answers

• Question 121:

  Which of the following is NOT possible during a non-root Informix Server installation?

  A. Role Separation
  B. Create users and groups
  C. Create a database server instance
  D. Secure the Informix installation directory
  B. Create users and groups

• Question 122:

  What is the purpose of the GRANT ADMIN privilege?

  A. Grants the admin privilege to create role separation.
  B. Grants the admin privilege to perform DBSA functions.
  C. Grants the admin privilege to use the Open Admin Tool.
  D. Grants the admin privilege to run SQL administration API commands.
  D. Grants the admin privilege to run SQL administration API commands.

• Question 123:

  Which OpenAdmin Tool feature is used to analyze the state of the Informix database server and can alert the DBA through email?

  A. SQL Toolbox
  B. Health Advisor
  C. Server Administration
  D. Performance Analysis
  B. Health Advisor

• Question 124:

  Which statement about Storage Provisioning is true?

  A. Only raw devices can be extended.
  B. Only cooked devices can be extended.
  C. Only unmirrored spaces can be extended.
  D. Mirrored and unmirrored spaces can be extended.
  C. Only unmirrored spaces can be extended.

• Question 125:

  After executing the following commands: onmode -j -U karin,dave onmode -j -U karin,sarah onmode -j -U sarah which user(s) have access to the instance?

  A. sarah
  B. karin and dave
  C. karin and sarah
  D. karin, dave and sarah
  A. sarah

• Question 126:

  Which option is available through ifx_grid_connect()?

  A. Rename a replicated database.
  B. Enable use of TimeSeries columns in tables.
  C. Enable automatic creation of templates in a grid.
  D. Defer propagation of DDL statements to other servers in the grid.
  D. Defer propagation of DDL statements to other servers in the grid.

• Question 127:

  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))
  B. OVER

• Question 128:

  "informix_stores" is an established primary server with a SDS server. What is the effect of running the following command? EXECUTE FUNCTION sysadmin:admin("ha sds clear", "informix_stores");

  A. Shuts down the primary server and converts the secondary server to be the primary.
  B. Clears the log position of the SDS servers and restarts replication.
  C. Converts the shared disk secondary server to a standard server and shuts down the primary server.
  D. Stops replication to the shared disk secondary servers and converts the primary server to a standard server.
  D. Stops replication to the shared disk secondary servers and converts the primary server to a standard server.

• Question 129:

  Which is NOT a valid option to improve service for connection requests under TCP/IP protocol?

  A. Adding sm_listen threads.
  B. Adding listener threads for additional ports.
  C. Dynamically increase the number of listener threads using onmode -P commands.
  D. Adding an additional network-interface card to service Informix connection requests.
  A. Adding sm_listen threads.

• Question 130:

  Which type of device does Primary Storage Manager support?

  A. File
  B. Tape
  C. Directory
  D. Named pipe
  A. File