[Free] 2017(Jan) EnsurePass Passguide IBM C2090-730 Dumps with VCE and PDF 201-210

Ensurepass.com : Ensure you pass the IT Exams
2017 Jan IBM Official New Released C2090-730
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-730.html

DB2 9 Family Fundamentals

Question No: 201

A transaction using the Read Stability isolation level scans the same table multiple times before it terminates. Which ofthe following can occur within this transaction#39;s processing?

  1. Uncommitted changes made by other transactions can be seen from one scan to the next.

  2. Rows removed by other transactions that appeared in one scan will no longer appear in subsequent scans.

  3. Rows added by other transactions that did not appear in one scan can be seen in subsequent scans.

  4. Rows that have been updated can be changed by other transactions from one scan to the next.

Answer: C

Question No: 202

Which of the following is NOT an accurate statement about views?

  1. Views are publicly referenced names and no specialauthority or privilege is needed to use them.

  2. Views can be used to restrict access to columns in a base table that contain sensitive data

  3. Views can be used to store queries that multiple applications execute on a regular basis in a database

  4. Viewssupport INSTEAD OF triggers

Answer: A

Question No: 203

Which of the following is NOT an attribute of Declared Global Temporary Tables (DGTTs)?

  1. Each application that defines a DGTT has its own instance of the DGTT

  2. Two different applications cannot create DGTTs that have thesame name

  3. DGTTs can only be used by the application that creates them, and only for the life of the

    application

  4. Data stored in a DGTT can exist across transaction boundaries

Answer: B

Question No: 204

In which of the following scenarios would a stored procedure be beneficial?

  1. An application running on a remote client needs to be able to convert degrees Celsius to degrees Fahrenheit and vice versa

  2. An application running on a remote client needs to collect three input values, perform a calculation using the values provided, and store the input data, along with the results of the calculation in two different base tables

  3. An application running on a remote client needs to trackevery modification made to a table that contains sensitive data

  4. An application running on a remote client needs to ensure that every new employee that joins the company is assigned a unique, sequential employee number

Answer: B

Question No: 205

Given the following DDL for the PARTS table:

CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));

All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?

  1. CREATE UNIQUE INDEX idx_partno ON parts(part_no)

  2. CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)

  3. CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)

  4. CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)

Answer: A

Question No: 206

Which of the following actions will NOT cause a trigger to be fired?

  1. INSERT

  2. DELETE

  3. ALTER

  4. UPDATE

Answer: C

Question No: 207

Which of the following actions will NOT cause a trigger to be fired?

  1. INSERT

  2. DELETE

  3. ALTER

  4. UPDATE

Answer: C

Question No: 208

When a client using the SERVER_ENCRYPT authentication type connects to a server using the SERVER authentication type, what happens?

  1. An error will occur.

  2. Data passed between the client and the server is encrypted.

  3. User IDs and passwords are passed to the server unencrypted.

  4. User IDs and passwords are encrypted before they are passed to the server.

Answer: A

Question No: 209

Which of the following is NOT a characteristic of a declared temporary table?

  1. Declared temporary tables are not persistent and can only beused by the application that creates them

  2. It is possible for many applications to create declared temporary tables that have the same name

  3. Declared temporary tables are created by executing a CREATE TABLE statement with the DECLARED GLOBAL TEMPORARYclause specified

  4. Once the application that created a global temporary table is terminated, any records in the table are deleted and the table is automatically destroyed Data Concurrency

Answer: C

Question No: 210

If the following SQL statements are executed:

CREATE TABLE tab1 (id SMALLINT NOT NULL PRIMARY KEY, name VARCHAR(25));

CREATE TABLE tab2(empid SMALLINT,

weekno SMALLINT, payamt DECIMAL(6,2),

CONSTRAINT const1 FOREIGN KEY (empid) REFERENCES taba(id) ON UPDATE NO ACTION);

Which of the following statements is true?

  1. Only values that exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2

  2. The updating of values in the ID column of table TAB1 is not allowed

  3. Only values that do not already exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2

  4. When values that exist in the ID column of table TAB1 are updated, corresponding values in the EMPID column of table TAB2 are updated as well

Answer: A

100% Ensurepass Free Download!
Download Free Demo:C2090-730 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass C2090-730 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE