IBM IBM Certified Database Associate C2090-730 Questions & Answers

• Question 221:

  If a view named V1 is created in such a way that it references every column in a table named EMPLOYEE except a column named SALARY, which of the following is NOT an accurate statement?

  A. View V1 can be used in the same context as the EMPLOYEE table for all data retrieval operations that do

  not acquire SALARY information

  B. View V1 can be used as a data source for other views

  C. View V1 does not have to reside in the same schema as the EMPLOYEE table

  D. All data, except SALARY data that is stored in the EMPLOYEE table is copied to the physical location associated with view V1

  Correct Answer: D

• Question 222:

  An alias can be an alternate name for which two of the following DB2 objects?

  A. Sequence

  B. Trigger

  C. View

  D. Schema

  E. Table

  Correct Answer: CE

• Question 223:

  If the following SQL statements are executed in the order shown:

  CREATE TABLE orders (order_num INTEGER NOT NULL, buyer_name VARCHAR(35), amount NUMERIC(5,2));

  CREATE UNIQUE INDEX idx_orderno ON orders (order_num);

  Which of the following describes the resulting behavior?

  A. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows should be displayed in order of increasing ORDER_NUM values

  B. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows will be displayed in no particular order

  C. Duplicate ORDER_NUM values are allowed; no other index can be created for the ORDERS table that reference the ORDER_NUM column

  D. Every ORDER_NUM value entered must be unique; no other index can be created for the ORDERS table that reference the ORDER_NUM column

  Correct Answer: A

• Question 224:

  Which of the following tools can NOT be used to catalog a database?

  A. Control Center

  B. SQL Assist

  C. Configuration Assistant

  D. Command Line Processor

  Correct Answer: B

• Question 225:

  In which of the following scenarios would a stored procedure be beneficial?

  A. An application running on a remote client needs to be able to convert degrees Celsius to degrees Fahrenheit and vice versa

  B. An application running on a remote client needs to collect three input values, perform a calculation using the values provided, and store the input data, along with the results of the calculation in two different base tables

  C. An application running on a remote client needs to track every modification made to a table that contains sensitive data

  D. An application running on a remote client needs to ensure that every new employee that joins the company is assigned a unique, sequential employee number

  Correct Answer: B

• Question 226:

  Which of the following are NOT stored in the system catalog tables?

  A. SQL statements used to create views

  B. SQL statements used to create triggers

  C. SQL statements used to create constraints

  D. Table names

  Correct Answer: A

• Question 227:

  Which of the following statements will catalog the database MYDB on the node MYNODE and assign it the alias MYNEWDB?

  A. CATALOG DATABASEmynewdb AT NODE mynode

  B. CATALOG DATABASEmynewdb AS mydb AT NODE mynode

  C. CATALOG DATABASEmydb AT NODE mynode

  D. CATALOG DATABASEmydb AS mynewdb AT NODE mynode

  Correct Answer: D

• Question 228:

  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;

  Correct Answer: C

• Question 229:

  What does the following statement do?

  A. Gives USER1 the ability to change the comment associated with a sequence named GEN_EMPID, along with the ability to give this CONTROL authority for the sequence to other users and groups.

  B. Gives USER1 the ability to change the values returned by the PREVIOUS_VALUE and NEXT_VALUE expressions associated with a sequence named GEN_EMPID, along with the ability to give CONTROL authority for the sequence to other users and groups.

  C. Gives USER1 the ability to change the comment associated with a sequence named GEN_EMPID, along with the ability to give this authority to other users and groups.

  D. Gives USER1 the ability to change the values returned by the PREVIOUS_VALUE and NEXT_VALUE expressions associated with a sequence named GEN_EMPID, along with the ability to give this authority to other users and groups.

  Correct Answer: C

• Question 230:

  A user invoking a user-defined function requires which DB2 privilege?

  A. CALL

  B. USAGE

  C. EXECUTE

  D. REFERENCES

  Correct Answer: C