Our pass rate is high to 98.9% and the similarity percentage between our C2090-730 study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the IBM C2090-730 exam in just one try? I am currently studying for the IBM C2090-730 exam. Latest IBM C2090-730 Test exam practice questions and answers, Try IBM C2090-730 Brain Dumps First.
♥♥ 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
Q71. Which of the following is NOT true about schemas?
A. If a schema name is not specified, either by qualifying a database object name or by executing the SET CURRENT SCHEMA statement, the authorization ID of the current session user is used as the schema name by default
B. The value assigned to the CURRENT SCHEMA special register is persistent across database restarts
C. A schema enables the creation of multiple objects in a database without encountering namespace collisions
D. When most database objects are created, they are either implicitly or explicitly assigned to a schema
Answer: B
Explanation:
Q72. Which two of the following statements are true about the HAVING clause?
A. The HAVING clause is used in place of the WHERE clause.
B. The HAVING clause uses the same syntax as the WHERE clause.
C. The HAVING clause can only be used with the GROUP BY clause.
D. The HAVING clause accepts wildcards.
E. The HAVING clause uses the same syntax as the IN clause.
Answer: B,C
Explanation:
Q73. Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?
A. Define the column MAINID as NOT UPDATABLE.
B. Define the column MAINID as a PRIMARY KEY.
C. Define the column MAINID as a FOREIGN KEY.
D. Define an UPDATE trigger on table TABLEX.
Answer: D
Explanation:
Q74. Given the following statements:
CREATE TABLE t1 (c1 INTEGER, c2 CHAR(5));
CREATE TABLE t1audit (user VARCHAR(20), date DATE, action
VARCHAR(20));
CREATE TRIGGER trig1 AFTER INSERT ON t1
FOR EACH ROW
MODE DB2SQL
INSERT INTO t1audit VALUES (CURRENT USER, CURRENT DATE,
'Insert');
If user USER1 executes the following statements:
INSERT INTO t1 VALUES (1, 'abc');
INSERT INTO t1 (c1) VALUES (2);
UPDATE t1 SET c2 = 'ghi' WHERE c1 = 1;
How many new records will be written to the database?
A. 0
B. 2
C. 3
D. 4
Answer: D
Explanation:
Q75. Which of the following is the lowest cost DB2 product that can be legally installed on a Windows server that has 2 CPUs?
A. DB2 Everyplace
B. DB2 Express Edition
C. DB2 Workgroup Server Edition
D. DB2 Enterprise Server Edition
Answer: B
Explanation:
Q76. Which of the following modes, when used with the LOCK TABLE statement, will cause the DB2 Database Manager to acquire a table-level lock that prevents other concurrent transactions from accessing data stored in the table while the owning transaction is active?
A. SHARE MODE
B. ISOLATED MODE
C. EXCLUSIVE MODE
D. RESTRICT MODE
Answer: C
Explanation:
Q77. Application A is running under the Repeatable Read isolation level and holds an Update lock on table TAB1. Application B wants to query table TAB1 and cannot wait for Application A to release its lock. Which isolation level should Application B run under to achieve this objective?
A. Repeatable Read
B. Read Stability
C. Cursor Stability
D. Uncommitted Read
Answer: D
Explanation:
Q78. Given the following stored procedure:
CREATE PROCEDURE increase_salary ( IN p_workdept CHAR(6),
OUT p_sum DECIMAL(9,2) )
SET p_sum = (SELECT SUM(salary) FROM employee WHERE workdept=p_workdept);
How can this stored procedure be called from the Command Line Processor?
A. CALL increase_salary('A00')
B. VALUES increase_salary('A00')
C. CALL increase_salary('A00', ?)
D. VALUES increase_salary('A00', ?)
Answer: A
Explanation:
Q79. Given the following statements:
CREATE TABLE tab1 (col1 INT);
CREATE TABLE tab2 (col1 INT);
CREATE TRIGGER trig1 AFTER UPDATE ON tab1
REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3);
What is the result of the following query?
SELECT count(*) FROM tab2;
A. 3
B. 2
C. 1
D. 0
Answer: D
Explanation:
Q80. Given the following table: TAB1 COL1 COL2
A 10 B 20 C 30 A 10 D 40 C 30
Assuming the following results are desired:
TAB1
COL1 COL2
A 10 B 20 C 30 D 40
Which of the following statements will produce the desired results?
A. SELECT UNIQUE * FROM tab1
B. SELECT DISTINCT * FROM tab1
C. SELECT UNIQUE(*) FROM tab1
D. SELECT DISTINCT(*) FROM tab1
Answer: B
Explanation: