Download of C2090-730 free practice questions materials and software for IBM certification for examinee, 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:
Q51. Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?
A. REVOKE SELECT FROM user2 ON TABLE org.tab1
B. REVOKE SELECT ON TABLE org.tab1 FROM user2
C. REVOKE READ ACCESS FROM user2 ON TABLE org.tab1
D. REVOKE READ ACCESS ON TABLE org.tab1 FROM user2
Answer: B
Explanation:
Q52. In a client-server environment, which two of the following can be used to verify passwords?
A. System Catalog
B. User ID/password file
C. Client Operating System
D. Communications layer
E. Application Server
Answer: C,E
Explanation:
Q53. Which of the following DB2 UDB isolation levels will only lock rows during read processing if another transaction tries to drop the table the rows are being read from?
A. Repeatable Read
B. Read Stability
C. Cursor Stability
D. Uncommitted Read
Answer: D
Explanation:
Abreast of the times C2090-730 download:
Q54. A user utilizing an alias to update a subset of columns in a table must have
UPDATE privileges on which of the following DB2 objects?
A. Table
B. Columns
C. Table and Alias
D. Columns and Alias
Answer: A
Explanation:
Q55. The following triggers were defined for a table named SALES in the order shown:
CREATE TRIGGER trigger_a NO CASCADE BEFORE UPDATE ON sales REFERENCING NEW AS new FOR EACH ROW SET new.commission = sale_amt * .05
WHERE invoice = n.invoice;
CREATE TRIGGER trigger_b AFTER INSERT ON sales REFERENCING NEW AS new FOR EACH ROW UPDATE sales SET bill_date = CURRENT DATE + 30 DAYS
WHERE invoice = n.invoice;
CREATE TRIGGER trigger_c NO CASCADE BEFORE DELETE ON sales FOR EACH ROW SIGNAL SQLSTATE '75005'
SET MESSAGE_TEXT = 'Deletes not allowed!'
Which of the following statements is NOT true?
A. Once a row has been added to the SALES table, it cannot be removed
B. Whenever a row is inserted into the SALES table, the value in the BILL_DATE column is automatically set to 30 days from today
C. Each time a row is inserted into the SALES table, trigger TRIGGER_A is fired first, followed by trigger TRIGGER_B
D. Whenever a row in the SALES table is updated, all three triggers are fired but nothing happens because none of the triggers have been coded to trap update operations
Answer: D
Explanation:
197. Which of the following CREATE TABLE statements will NOT be successful?
A. CREATE TABLE t1 (c1 XML NOT NULL UNIQUE, c2 INT)
B. CREATE TABLE t1 (c1 XML NOT NULL, c2 CHAR(20))
C. CREATE TABLE t1 (c1 XML CHECK (c1 IS VALIDATED), c2 INT)
D. CREATE TABLE t1 (c1 XML, c2 XML)
Answer: A
Explanation:
Q56. Application A wants to read a subset of rows from table TAB1 multiple times. Which of the following isolation levels should Application A use to prevent other users from making modifications and additions to table TAB1 that will affect the subset of rows read?
A. Repeatable Read
B. Read Stability
C. Cursor Stability
D. Uncommitted Read
Answer: A
Explanation:
Download C2090-730 torrent:
Q57. Which of the following CREATE TABLE statements will NOT be successful?
A. CREATE TABLE t1 (c1 XML NOT NULL UNIQUE, c2 INT)
B. CREATE TABLE t1 (c1 XML NOT NULL, c2 CHAR(20))
C. CREATE TABLE t1 (c1 XML CHECK (c1 IS VALIDATED), c2 INT)
D. CREATE TABLE t1 (c1 XML, c2 XML)
Answer: A
Explanation:
Q58. 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:
Q59. Which of the following is the major difference between relational data and XML data?
A. Relational data is self-describing; XML data is not
B. Relational data has inherent ordering; XML data does not
C. Relational data must be tabular; XML data does not have to be tabular
D. Relational data is comprised of entities; XML data is comprised of numbers, characters, and dates
Answer: C
Explanation:
Q60. Given the following tables:
CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West
How many rows would be returned using the following statement?
SELECT location FROM continents, region
A. 2
B. 7
C. 9
D. 14
Answer: D
Explanation: