IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 231:

  A database named TEST_DB resides on a z/OS system and listens on port 446. The TCP/IP address for this system is 192. 168.10.20 and the TCP/IP host name is MYHOST. Which of the following commands is required to make this database accessible to a Linux client?

  A. CATALOG TCPIP NODEzos_srvr REMOTE myhost SERVER 192. 168.10.20; CATALOG DATABASE zos_db AS test_db AT NODE zos_srvr; CATALOG DCS DATABASE zos_db AS test_db;
  B. CATALOG TCPIP NODEzos_srvr REMOTE myhost SERVER 192. 168.10.20; CATALOG DCS DATABASE zos_db AS test_db AT NODE zos_srvr;
  C. CATALOG TCPIP NODEzos_srvr REMOTE myhost SERVER 446; CATALOG DCS DATABASE zos_db AS test_db AT NODE zos_srvr;
  D. CATALOG TCPIP NODEzos_srvr REMOTE myhost SERVER 446; CATALOG DATABASE zos_db AS test_db AT NODE zos_srvr; CATALOG DCS DATABASE zos_db AS test_db;
  C. CATALOG TCPIP NODEzos_srvr REMOTE myhost SERVER 446; CATALOG DCS DATABASE zos_db AS test_db AT NODE zos_srvr;

• Question 232:

  For which of the following is a data warehouse optimized?

  A. Backup and recovery
  B. Transactions
  C. Security
  D. Queries
  D. Queries

• Question 233:

  User USER1 is the owner of TABLE1. Assuming user USER1 only holds privileges for TABLE1,

  A. REVOKE CONTROL ON table1 FROM user1
  B. REVOKE ALL PRIVILEGES ON table1 FROM user1
  C. REVOKE CONTROL ON table1 FROM user1; REVOKE ALL PRIVILEGES ON table1 FROM user1;
  D. REVOKE CONTROL, ALL PRIVILEGES ON table1 FROM user1
  C. REVOKE CONTROL ON table1 FROM user1; REVOKE ALL PRIVILEGES ON table1 FROM user1;

• Question 234:

  Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?

  A. The cursor is only protected from updates and deletes by concurrent applications.
  B. The row is only protected from positioned updates and deletes that reference another cursor of the same application.
  C. The cursor is protected from positioned updates and deletes that reference another cursor of a different application.
  D. The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application.
  A. The cursor is only protected from updates and deletes by concurrent applications.

• Question 235:

  Which of the following is a NOT a valid reason for defining a view on a table?

  A. Restrict users' access to a subset of table data
  B. Ensure that rows inserted remain within the scope of a definition
  C. Produce an action as a result of a change to a table
  D. Provide users with an alternate view of table data
  C. Produce an action as a result of a change to a table

• Question 236:

  57 Given table T1 has column I1 containing the following data: I1

  If the following sequence of SQL statements is applied within a single unit of work:

  UPDATE t1 SET i1 = 3 WHERE i1 = 2; S

  AVEPOINT s1 ON ROLLBACK RETAIN CURSORS;

  UPDATE t1 SET i1 = 5 WHERE i1 = 3;

  SAVEPOINT s2 ON ROLLBACK RETAIN CURSORS;

  INSERT INTO t1 (i1) VALUES (6);

  ROLLBACK TO SAVEPOINT s1;

  UPDATE t1 SET i1 = 2 WHERE i1 = 4;

  COMMIT;

  What is the expected sequence of values returned from?

  SELECT i1 FROM t1 ORDER BY i1

  A. 1, 2, 3, 3
  B. 1, 2, 2, 4
  C. 1, 2, 3, 3, 6
  D. 1, 2, 2, 5, 6
  A. 1, 2, 3, 3

• Question 237:

  Given the following statements:

  CREATE TABLE tab1 (c1 INTEGER, c2 CHAR(5));

  CREATE VIEW view1 AS SELECT c1, c2 FROM tab1 WHERE c1 < 100; CREATE VIEW view2 AS SELECT c1, c2 FROM view1

  WITH CASCADED CHECK OPTION;

  Which of the following INSERT statements will fail to execute?

  A. INSERT INTO view2VALUES(50, 'abc')
  B. INSERT INTO view1 VALUES (100, 'abc')
  C. INSERT INTO view2VALUES(150, 'abc')
  D. INSERT INTO view1VALUES(100, 'abc')
  C. INSERT INTO view2VALUES(150, 'abc')

• Question 238:

  While attempting to connect to a database stored on an iSeries server from a Windows client, the following message was displayed:

  SQL1013N The database alias name or database name "TEST_DB" could not be found.

  Which of the following actions can be used to help determine why this message was displayed?

  A. Execute the LIST REMOTE DATABASES command on the server; look for an entry for the TEST_DB database
  B. Execute the LIST DCS DIRECTORY command on the server; look for an entry for the TEST_DB database
  C. Execute the LIST REMOTE DATABASES command on the client; look for an entry for the TEST_DB database
  D. Execute the LIST DCS DIRECTORY command on the client; look for an entry for the TEST_DB database
  D. Execute the LIST DCS DIRECTORY command on the client; look for an entry for the TEST_DB database

• Question 239:

  Given the following CREATE TABLE statement:

  CREATE TABLE EMPLOYEE

  (EMPNO CHAR(3) NOT NULL,

  FIRSTNAME CHAR(20) NOT NULL,

  MIDINIT CHAR(1),

  LASTNAME CHAR(20) NOT NULL,

  SALARY DECIMAL(10, 2))

  Which of the following will retrieve the rows that have a missing value in the MIDINIT column?

  A. SELECT * FROM employee WHEREmidinit = ' '
  B. SELECT * FROM employee WHEREmidinit = NULL
  C. SELECT * FROM employee WHEREmidinit = " "
  D. SELECT * FROM employee WHEREmidinit IS NULL
  D. SELECT * FROM employee WHEREmidinit IS NULL

• Question 240:

  A user wishing to invoke an SQL stored procedure that queries a table must have which of the following privileges?

  A. CALL privilege on the procedure; SELECT privilege on the table
  B. CALL privilege on the procedure; REFERENCES privilege on the table
  C. EXECUTE privilege on the procedure; SELECT privilege on the table
  D. EXECUTE privilege on the procedure; REFERENCES privilege on the table
  C. EXECUTE privilege on the procedure; SELECT privilege on the table