[Free] 2018(Jan) Dumps4cert Braindumps IBM C2090-610 Dumps with VCE and PDF 41-50

By | February 2, 2018

Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan IBM Official New Released C2090-610
100% Free Download! 100% Pass Guaranteed!
http://www.Dumps4cert.com/C2090-610.html

DB2 10.1 Fundamentals

Question No: 41 – (Topic 1)

Which product is used to customize execution environments for the purpose of controlling system resources so that one department or service class does not overwhelm the system?

  1. pureScale

  2. Workload manager

  3. Datapartitioning feature

  4. Self-tuning memory manager

Answer: B

Question No: 42 – (Topic 1)

Which two operations are allowed in the body of an SQL scalar user-defined function? (Choose two.)

  1. CALL statements.

  2. External file access.

  3. Use of a scratch pad.

  4. COMMIT statements.

  5. SQL control statements.

Answer: A,E

Question No: 43 – (Topic 1)

Which two statements are true about foreign key constraints? (Choose two.)

  1. The foreign key constraint columns must be supported by an index.

  2. The foreign key constraint columns must be defined as NOT NULL.

  3. The number and data types of foreign key constraint columns must match the parent key.

  4. The columns of one foreign key constraint cannot be used in another foreign key constraint.

  5. Todefine a foreign key constraint there must be an associated primary key or unique key in the same or different table.

Answer: C,E

Question No: 44 – (Topic 1)

Application APP_A is performing updates to table TAB1 using the cursor stability (CS) isolation level. If application APP_B wants to retrieve all rows from table TAB1 without waiting for application APP_A to finish making updates, what isolation level must applicationAPP_B use?

  1. Read Stability (RS)

  2. Repeatable Read (RR)

  3. Uncommitted Read (UR)

  4. Cursor Stability (CS)

Answer: C

Question No: 45 – (Topic 1)

What is the primary function of an Online Transaction Processing (OLTP) workload?

  1. To combine data from multiple sources.

  2. To discover hidden relationships in data.

  3. To analyze large amounts of data to find patterns.

  4. To make changes to a small number of records within a single transaction.

Answer: D

Question No: 46 – (Topic 1)

Which SQL statement will allow user USER1 to create a view on a table named EMPLOYEE?

  1. GRANT CREATETAB ON DATABASE TO user1

  2. GRANT SELECT ON TABLE employee TO user1

  3. GRANT CREATEVIEW ON DATABASE TO user1

  4. GRANT REFERENCES ON TABLEemployee TO user1

Answer: B

Question No: 47 – (Topic 1)

In a trusted context environment, if a switch request is made with an authorization ID that is not allowed on a trusted connection, what state is the connectionplaced in?

  1. Locked

  2. Waiting

  3. Pending

  4. Unconnected

Answer: D

Question No: 48 – (Topic 1)

Which action needs to be performed in order to complete the definition of an application- period temporaltable?

  1. A transaction-start-id column must be defined for the table.

  2. A history table must be defined and associated with the base table.

  3. A BUSINESS_TIME period must be specified in a CREATE or ALTER of the table.

  4. A unique index must be createdthat prevents overlapping of the BUSINESS_TIME period of the table.

Answer: C

Question No: 49 – (Topic 1)

When an index is created for a table, where is the metadata for that index stored?

  1. In the table definition.

  2. In the system catalog.

  3. In the schema that the index resides in.

  4. In the metadata of the table the index was created for.

Answer: B

Question No: 50 – (Topic 1)

Which is NOT a valid reason for creating an index?

  1. To allow queries to run more efficiently.

  2. To enforce constraints such as uniqueness on index keys.

  3. To order the columns of a table in ascending or descending sequence according to values in a row.

  4. To order the rows of a table in ascending or descending sequence according to the values in a column.

Answer: C

100% Dumps4cert Free Download!
Download Free Demo:C2090-610 Demo PDF
100% Dumps4cert Free Guaranteed!
C2090-610 Dumps

Dumps4cert 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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.