we provide Top Quality IBM C2090-730 dumps which are the best for clearing C2090-730 test, and to get certified by IBM DB2 9 Family Fundamentals. The C2090-730 Questions & Answers covers all the knowledge points of the real C2090-730 exam. Crack your IBM C2090-730 Exam with latest dumps, guaranteed!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-730 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-730 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-730-exam-dumps.html
Q1. Given the following requirements:
Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is added, has an EDLEVEL column that permits only the values 'C', 'H' and 'N', and permits inserts only when a corresponding value for the employee's department exists in the DEPARTMENT table.
Which of the following CREATE statements will successfully create this table?
A. CREATE TABLE emp (
empno SMALLINT NEXTVAL GENERATED ALWAYS AS IDENTITY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
workdept CHAR(3) NOT NULL,
edlevel CHAR(1),
PRIMARY KEY emp_pk (empno),
FOREIGN KEY emp_workdept_fk ON (workdept) REFERENCES department (deptno),
CHECK edlevel_ck VALUES (edlevel IN ('C','H','N')),
);
B. CREATE TABLE emp (
empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
workdept CHAR(3),
edlevel CHAR(1),
CONSTRAINT emp_pk PRIMARY KEY (empno),
CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department
(deptno),
CONSTRAINT edlevel_ck CHECK edlevel VALUES ('C','H','N')
);
C. CREATE TABLE emp (
empno SMALLINT NEXTVAL GENERATED BY DEFAULT AS IDENTITY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
workdept CHAR(3) NOT NULL,
edlevel CHAR(1) CHECK IN ('C','H','N')),
CONSTRAINT emp_pk PRIMARY KEY (empno),
CONSTRAINT emp_workdept_fk FOREIGN KEY department (deptno) REFERENCES
(workdept)
);
D. CREATE TABLE emp (
empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
workdept CHAR(3),
edlevel CHAR(1),
CONSTRAINT emp_pk PRIMARY KEY (empno),
CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department
(deptno),
CONSTRAINT edlevel_ck CHECK (edlevel IN ('C','H','N'))
);
Answer: D
Explanation:
Q2. Given the statement: CREATE TABLE tablea (col1 INTEGER NOT NULL, CONSTRAINT const1 CHECK (col1 in (100, 200, 300)) Which of the following can be inserted into TABLEA?
A. 0
B. NULL
C. 100
D. '100'
Answer: C
Explanation:
Q3. 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:
Q4. An application has acquired a Share lock on a row in a table and now wishes to update the row. Which of the following statements is true?
A. The application must release the row-level Share lock it holds and acquire an Update lock on the row
B. The application must release the row-level Share lock it holds and acquire an Update lock on the table
C. The row-level Share lock will automatically be converted to a row-level Update lock
D. The row-level Share lock will automatically be escalated to a table-level Update lock
Answer: C
Explanation:
Q5. Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?
A. An application process acquires at least a share lock on the current row of every cursor.
B. Any row that is read during a unit of work cannot be changed by other application processes until the unit of work is complete.
C. Any row changed by another application process can be read, even if the change has not been committed by that application process.
D. An application process that issues the same query more than once in a unit of work will not see additional rows caused by other application processes appending new information to the database.
Answer: A
Explanation:
Q6. 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:
Q7. Which of the following statements allows user USER1 to take the ability to create packages in a database named SAMPLE away from user USER2?
A. REVOKE CONNECT ON DATABASE FROM user2
B. REVOKE CREATETAB ON DATABASE FROM user2
C. REVOKE BIND ON DATABASE FROM user2
D. REVOKE BINDADD ON DATABASE FROM user2
Answer: D
Explanation:
Q8. Which of the following best describes the age of the data in an OLTP system?
A. Current
B. Projected
C. Historical D. Current and projected
Answer: A
Explanation:
Q9. A table called DEPARTMENT has the following columns:
DEPT_ID
DEPT_NAME
MANAGER
Which of the following statements will ONLY allow user USER1 to modify the DEPT_NAME column?
A. GRANT ALTER ON TABLE department TO user1
B. GRANT ALTER (dept_name) ON TABLE department TO user1
C. GRANT UPDATE ON TABLE department TO user1
D. GRANT UPDATE (dept_name) ON TABLE department TO user1
Answer: D
Explanation:
Q10. Which of the following database objects can be used to raise an error if a table is updated?
A. Package
B. Trigger
C. Stored Procedure
D. Informational Constraint
Answer: B
Explanation: