IBM C2090-558 Online Practice Questions and Exam Preparation

IBM C2090-558 Online Questions & Answers

• Question 111:

  Assuming the tables and columns mentioned below exist, which of the following SQL statements will return an error?

  A. INSERT INTO orders SELECT * FROM new_orders;
  B. SELECT company, fname, lname, state FROM customer WHERE state = (SELECT state, zipcode FROM customer WHERE fname = "John");
  C. DELETE FROM stock WHERE 0 = (SELECT count(*) FROM manufact WHERE manufact.manu_code = stock.manu_code)
  D. UPDATE customer SET (address, city, state, zip) = (SELECT address, city, state, zip FROM newaddr WHERE newaddr.customer_num = customer.customer_num) WHERE customer_num IN (SELECT customer_num FROM newaddr);
  B. SELECT company, fname, lname, state FROM customer WHERE state = (SELECT state, zipcode FROM customer WHERE fname = "John");

• Question 112:

  Under which of the following conditions does the LAST COMMITTED option have an effect on the COMMITTED READ isolation level?

  A. Row level lock
  B. Page level locking
  C. RAW or unlogged tables
  D. Tables containing complex data types
  A. Row level lock

• Question 113:

  What functionality is exclusive to onbar (i.e. not present in ontape)?

  A. Restore of a single dbspace
  B. Level 1 archive of the instance
  C. Parallel restore of the instance
  D. Change logging modes of a database
  C. Parallel restore of the instance

• Question 114:

  Which of the following methods will allow you to determine how much space is currently in use?

  A. Query the $ table
  B. Query the sysstats database
  C. Query the sysusers database
  D. Query the sysmaster database
  D. Query the sysmaster database

• Question 115:

  Which statement can be used to roll back SQL statements within a transaction?

  A. END WORK
  B. COMMIT WORK
  C. ROLLBACK WORK
  D. ROLLBACK WORK TO SAVEPOINT
  D. ROLLBACK WORK TO SAVEPOINT

• Question 116:

  Which of the following can be used to move the physical log?

  A. onlog
  B. ondblog
  C. onspaces
  D. onparams
  D. onparams

• Question 117:

  Which of the following can be used in a SELECT statement to set one or more qualifying conditions to a group of records after they are formed?

  A. HAVING
  B. WHERE
  C. GROUP BY
  D. ORDER BY
  A. HAVING

• Question 118:

  In which database does Informix store the information when a new task is created in OpenAdmin Tool's Task Scheduler?

  A. sysutils
  B. sysusers
  C. sysadmin
  D. sysmaster
  C. sysadmin

• Question 119:

  What are the three major steps in implementing Label-Based Access Control (LBAC) in an instance environment? (Choose three.)

  A. Define a security policy with access rules.
  B. Assign security labels to users and data elements
  C. Create security label definitions using set, tree, and/or array components
  D. Disable role separation since LBAC supersedes anything role separation might provide and it interferes with LBAC.
  E. Create and install either general or user-specific sysdbopen() functions so that LBAC is active when users connect to the instance.
  A. Define a security policy with access rules.
  B. Assign security labels to users and data elements
  C. Create security label definitions using set, tree, and/or array components

• Question 120:

  Which of the following is true of system catalogs?

  A. one system catalog per chunk
  B. one system catalog per instance
  C. one system catalog per database
  D. one system catalog per installation
  C. one system catalog per database