Verified of C2090-730 braindumps materials and testing software for IBM certification for customers, Real Success Guaranteed with Updated C2090-730 pdf dumps vce Materials. 100% PASS DB2 9 Family Fundamentals exam Today!
2021 May C2090-730 Study Guide Questions:
Q1. An index named EMPID_X exists for a table named EMPLOYEE. Which of the following will allow user USER1 to drop the EMPID_X index?
A. GRANT DROP ON INDEX empid_x TO user1
B. GRANT DELETE ON INDEX empid_x TO user1
C. GRANT INDEX ON TABLE employee TO user1
D. GRANT CONTROL ON INDEX empid_x TO user1
Answer: D
Explanation:
Q2. Which of the following DB2 objects can be referenced by an INSERT statement to generate values for a column?
A. Sequence
B. Identity column
C. Trigger
D. Table function
Answer: A
Explanation:
Q3. Given the following table definition: EMPLOYEES
EMPID INTEGER
NAME CHAR(20)
SALARY DECIMAL(10,2)
If the following SQL statement is executed:
CREATE UNIQUE INDEX empid_ui ON employees (empid)
Which two of the following statements are true?
A. Multiple null values are allowed in the EMPID column of the EMPLOYEES table.
B. No null values are allowed in the EMPID column of the EMPLOYEES table.
C. One (and only one) null value is allowed in the EMPID column of the EMPLOYEES table.
D. No other unique indexes can be created on the EMPLOYEES table.
E. Every value found in the EMPID column of the EMPLOYEES table will be different.
Answer: C,E
Explanation:
Regenerate C2090-730 exam price:
Q4. Which of the following is a valid DB2 data type?
A. NUMBER
B. INTERVAL
C. BYTE
D. NUM
Answer: D
Explanation:
Q5. When defining a referential constraint between the parent table T2 and the dependent table T1, which of the following is true?
A. The list of column names in the FOREIGN KEY clause can be a subset of the list of columnnames in the primary key of T2 or a UNIQUE constraint that exists on T2.
B. The list of column names in the FOREIGN KEY clause can be a subset of the list of columnnames in the primary key of T1 or a UNIQUE constraint that exists on T1.
C. The list of column names in the FOREIGN KEY clause must be identical to the list of columnnames in the primary key of T2 or a UNIQUE constraint that exists on T2.
D. The list of column names in the FOREIGN KEY clause must be identical to the list of columnnames in the primary key of T1 or a UNIQUE constraint that exists on T1.
Answer: C
Explanation:
Q6. Which of the following is a characteristic of a schema?
A. Foreign key references cannot cross schema boundaries.
B. A DB2 user must be created before a schema with the same name can be created.
C. If no schema is specified when an object is created, the default schema PUBLIC is used.
D. A schema enables the creation of multiple objects in a database without encountering namespace collisions.
Answer: D
Explanation:
Verified C2090-730 faq:
Q7. A table named DEPARTMENT has the following columns:
DEPT_ID
DEPT_NAME
MANAGER
AVG_SALARY
Which of the following is the best way to prevent most users from viewing AVG_SALARY data?
A. Encrypt the table's data
B. Create a view that does not contain the AVG_SALARY column
C. Revoke SELECT access for the AVG_SALARY column from users who should not see AVG_SALARY data
D. Store AVG_SALARY data in a separate table and grant SELECT privilege for that table to the appropriate users
Answer: B
Explanation:
43. Which authority or privilege is granted by the DB2 Database Manager configuration file?
A. CONNECT
B. CONTROL
C. SYSMAINT
D. EXECUTE
Answer: C
Explanation:
Q8. To which of the following resources can a lock be applied?
A. Row
B. Alias
C. Bitmap
D. Column
Answer: A
Explanation:
Q9. If the following statement is executed:
CREATE TABLE tab1 (col1 INTEGER NOT NULL,
col2 INTEGER,
CONSTRAINT const1 FOREIGN KEY (col2)
REFERENCES tab1(col1));
How many unique indexes are defined for table TAB1?
A. 0
B. 1
C. 2
D. 3
Answer: A
Explanation:
Q10. Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?
A. Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.
B. Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).
C. Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.
D. Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.
Answer: C
Explanation: