최신 IBM Certified Application Developer 000-610 무료샘플문제:

1. Which two statements are true about foreign key constraints? (Choose two.)

A) The number and data types of foreign key constraint columns must match the parent key.
B) The foreign key constraint columns must be defined as NOT NULL.
C) The columns of one foreign key constraint cannot be used in another foreign key constraint.
D) To define a foreign key constraint there must be an associated primary key or unique key in the same or different table.
E) The foreign key constraint columns must be supported by an index.

2. An SQL function named DEPT_INFO was created as follows:

What is the correct way to use this function in a query?

A) SELECT TABLE dept_id, dept_name FROM dept_info()
B) SELECT dept_id, dept_name FROM dept_info()
C) SELECT dept_info(dept_id, dept_name)
D) SELECT dept_id, dept_name FROM TABLE(dept_info()) AS results

3. Which DB2 object limits the user's ability to retrieve data from a table by defining a SQL statement in the object?

A) Trigger
B) Check constraint
C) Index
D) View

4. A new user named USER1 needs to retrieve information from a database named MYDB. What authority must be granted to user USER1?

A) DATAACCESS authority
B) SQLADM authority
C) ACCESSCTRL authority
D) DBCTRL authority

5. In a trusted context environment, if a switch request is made with an authorization ID that is not allowed on a trusted connection, what state is the connection placed in?

A) Waiting
B) Locked
C) Pending
D) Unconnected

질문과 대답: