Proper study guides for Abreast of the times IBM DB2 11 Fundamentals for z/OS certified begins with IBM C2090-320 preparation products which designed to deliver the Free C2090-320 questions by making you pass the C2090-320 test at your first time. Try the free C2090-320 demo right now.
IBM C2090-320 Free Dumps Questions Online, Read and Test Now.
NEW QUESTION 1
Given the following table:
Which of the following INSERT statements will be successful?
- A. INSERT INTO EMPSAMP (empno.name, salary, deptno, level,hiretyp
- B. hiredate) VALUES(2,'Mary Smith', 35000.00, 11, 'Associate'. 'existing705-06-2021');
- C. INSERT INTO EMPSAMP ('Mary Smith', 35000.00. 11, 'Associate', 'existing705-06-2021');
- D. INSERT INTO EMPSAMP VALUES(2,'Mary Smith', 35000.00, 11, 'Associate'. 'existing'05-06-2021');
- E. INSERT INTO EMPSAMP (name, salary, deptno, level) VALUES('Mary Smith', 35000.00, 11, 'Associate'):
Answer: B
NEW QUESTION 2
Which of the following can activate a trigger?
- A. A row is inserted
- B. A table or view is created
- C. A check constraint is defined
- D. A referential constraint is violated
Answer: D
NEW QUESTION 3
Using the SQL statement DECLARE GLOBAL TEMPORARY TABLE (DGTT) which of the following is TRUE?
- A. A DGTT is only stored in memory
- B. The qualifier for a DGTT is SESSION
- C. The DGTT can be specified in a referential constraint
- D. All privileges associated with the DGTT are stored in the DB2 catalog
Answer: B
NEW QUESTION 4
When you add an XML column to a table by using an ALTER TABLE statement, which of the following are TRUE? (Choose two)
- A. DB2 implicitly creates an XML table space
- B. DB2 implicitly creates an AUX table to store the XML data
- C. If this is the first XML column you created for the table, DB2 implicitly creates a unique index on the XML column
- D. If this is the first XML column you created for the table, DB2 implicitly creates a ROWID column on the base table
- E. If this is the first XML column you created for the table, DB2 implicitly creates a BIGINT node ID column on the base table
Answer: DE
NEW QUESTION 5
Which type of lock is obtained when using a 'WITH UR1 clause on an SQL SELECT statement in a data-sharing environment?
- A. U-lock
- B. S-lock
- C. P-lock
- D. No lock is obtained
Answer: B
NEW QUESTION 6
Which of the following coupling facility structures are used by DB2 in a data sharing environment?
- A. List structure, DB2 logs, and group buffer pools
- B. Work file database, list structure, and virtual buffer pools
- C. Lock structure, shared communications area, and group buffer pools
- D. Lock structure, shared communications area, and bootstrap data sets
Answer: C
NEW QUESTION 7
In which address space would a native SQL stored procedure run?
- A. WLM
- B. DIST
- C. DBM1
- D. The address space of the calling program
Answer: C
NEW QUESTION 8
User1 creates table user1 .customers in a partitioned-by-growth (PBG) table space DB1.TS1
Which of the following operations CANNOT be performed by user1 with implicit owner privileges on the table?
- A. Run the LOAD utility to load data
- B. Create a VIEW on the customers table
- C. Run the REORG utility to reorganize the data
- D. Issue an SQL LOCK TABLE statement against the customers table
Answer: A
NEW QUESTION 9
Given the following INDEX definition, which attributes apply to this index? (Choose two.)
- A. The index is partitioned
- B. The index data sets are user-managed
- C. The index data sets are DB2-managed
- D. The index is unique and in ascending order
- E. The maximum total size of the index is 1 GB
Answer: AB
NEW QUESTION 10
Which of the following is NOT a valid lock size in DB2?
- A. Table
- B. Partition
- C. Database
- D. Table space
Answer: C
NEW QUESTION 11
Which statement is TRUE regarding catalog table SYSIBM.SYSROUTINES?
- A. Contains scheduled tasks for the administrative scheduler
- B. Contains information about UDFs, BIFs and stored procedures
- C. Contains information about bound packages
- D. Contains information about UDFs and stored procedures
Answer: D
NEW QUESTION 12
Which of the following is NOT a valid trigger?
- A. MERGE
- B. INSERT
- C. UPDATE
- D. DELETE
Answer: A
NEW QUESTION 13
Given the following table and index definitions, what type of index will be created?
- A. Non-partitioned index
- B. Non-partitioned secondary index
- C. Data-partitioned secondary index
- D. Data-partitioned partitioning index
Answer: C
NEW QUESTION 14
Given the following CREATE TABLE statement, and a unique index on column EMPID, which set of SQL statements is valid?
- A. Option A
- B. Option B
- C. Option C
- D. Option D
Answer: D
NEW QUESTION 15
Which command displays the DB2 catalog level and migration mode?
- A. DSNC DISPLAY
- B. MODIFY irlmproc,STATUS
- C. DISPLAY GROUP DETAIL
- D. DISPLAY DATABASE (DSNDB06)
Answer: B
NEW QUESTION 16
Which of the following is a characteristic of a stand-alone utility?
- A. It can only be executed using JCL
- B. It can only be executed by a user with SYSADM
- C. It can only be executed if no other utilities are running
- D. It can only be executed in a non-data sharing environment
Answer: A
NEW QUESTION 17
Given the following:
ALTER TABLE POLICY_INFO_AET ENABLE ARCHIVE USE POLICY_INFO_ARC: SET SYSIBMADM.MOVE_TO_ARCHIVE = T; ***
Which of the following occurs automatically when rows are deleted from POLICY_INFO_AET?
- A. The deleted rows are moved from POLICY_INFO_AET table to PaOLICY_INFO_ARC table
- B. The logically deleted rows are removed from POLICY_INFO_ARC table during the REORG
- C. The deleted rows are removed from both POLICY_INFO_AET and POLICY_INFO_ARC tables
- D. The deleted rows are moved from POLICY_INFO_AET table to POLICY_INFO_ARC table during theREORG
Answer: D
NEW QUESTION 18
Which of the following CREATE TABLE or associated CREATE INDEX options are valid when defining a table with the PARTITION BY RANGE clause? (Choose two)
- A. MAXPARTITIONS
- B. ENDING AT clause on a CREATE INDEX statement for the table
- C. MEMBER CLUSTER
- D. ENDING AT clause on the CREATE TABLE statement
- E. A LOB column specified as a column of the partitioning key
Answer: B
NEW QUESTION 19
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)
Answer: D
NEW QUESTION 20
Given the following CREATE VIEW statement and sample data; your login id is “ROGER”. What will be the result for this query?
- A. 6
- B. 5
- C. 4
- D. 2
Answer: C
NEW QUESTION 21
......
P.S. Easily pass C2090-320 Exam with 124 Q&As Downloadfreepdf.net Dumps & pdf Version, Welcome to Download the Newest Downloadfreepdf.net C2090-320 Dumps: https://www.downloadfreepdf.net/C2090-320-pdf-download.html (124 New Questions)