Download DB2 11 Fundamentals for z-OS.PracticeTest.C2090-320.2019-04-05.1e.29q.vcex

Download Dump

File Info

Exam DB2 11 Fundamentals for z/OS
Number C2090-320
File Name DB2 11 Fundamentals for z-OS.PracticeTest.C2090-320.2019-04-05.1e.29q.vcex
Size 350 Kb
Posted April 05, 2019
Downloads 7



How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
With discount: 20%





Demo Questions

Question 1
Which of the following locking scenarios requires the least amount of real storage in the IRLM address space? 

  • A: 10 row locks
  • B: 200 page locks
  • C: A single table space lock
  • D: 6 partition locks (given a table space with a total of 10 partitions)



Question 2
Which of the following is NOT TRUE?

  • A: An index can be created on XML columns
  • B: Length must be specified for an XML column
  • C: XML columns can be added to existing tables
  • D: Triggers can be created on tables with XML columns



Question 3
The DB2 subsystem DSN has been correctly configured to access a remote DB2 location MYREMOTE. Which of the following processes can be used on subsystem DSN to access MYUSER.EMP table at MYREMOTE location?

  • A: SELECT * FROM MYUSER.EMP;
  • B: CONNECT TO MYREMOTE; 
    SELECT * FROM MYUSER.EMP;
  • C: SELECT * FROM MYUSER.MYREMOTE.EMP;
  • D: CREATE ALIAS EMP_ALIAS FOR LOCATION.MYREMOTE.MYUSER.EMP; 
    SELECT * FROM MYUSER.EMP_ALIAS;



Question 4
Which of the following elements is affected by a ROLLBACK statement?

  • A: LOB table spaces
  • B: Changes in cursor positioning
  • C: Acquisition and release of locks
  • D: Caching of rolled back statements



Question 5
Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?

  • A: SQLCA
  • B: SQLDA
  • C: SQLCODE 
  • D: SQLSTATE



Question 6
Your current authorization ID is DBA. Only one of your secondary authorization IDs, DB2, has the privilege to create an index DB2.AAA on a table. The appropriate SQL statement starts with “CREATE INDEX AAA ON”. Which of the following statements must precede the CREATE statement so that you can create the index?

  • A: SET CURRENT SQLID = ‘DB2’;
  • B: SET CURRENT RULES = ‘DB2’;
  • C: No preceding statement is needed
  • D: SET CURRENT SCHEMA = ‘DB2’;



Question 7
The metadata for which of the following objects is NOT stored in the DB2 catalog table SYSIBM.SYSTABLES?

  • A: A view
  • B: A temporal table
  • C: A created global temporary table
  • D: A declared global temporary table



Question 8
In a unique referential constraint, which type of key does a foreign key reference?

  • A: Child key
  • B: Collation key
  • C: Parent key
  • D: Secondary key



Question 9
If a scrollable cursor is INSENSITIVE, which of the following applies?

  • A: The cursor is read only
  • B: WITH ROWSET POSITIONING is not allowed
  • C: The select-statement must not contain an SQL data change statement
  • D: The cursor has sensitivity to changes that are made to the database after the result table is materialized



Question 10
You want to reduce lock contention that results from uncommitted insert and delete operations by enabling transactions that read data to access only the currently committed data rather than waiting for the uncommitted changes to be resolved. How can you accomplish this?

  • A: Bind your application with ISOLATION(UR)
  • B: Bind your application with ISOLATION(CS)
  • C: Bind your application with CONCURRENTACCESSRESOLUTION (WAITFOROUTCOME)
  • D: Bind your application with CONCURRENTACCESSRESOLUTION (USECURRENTLYCOMMITTED) 









CONNECT US


ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset