All About Precise C2090-320 Exam Question

NEW QUESTION 1
How can a stored procedure be invoked?

• A. Via an SQL SELECT statement
• B. Via a CALL statement using SPUFI
• C. Directly via a RUN PROGRAM command
• D. Via a CALL statement from within an application program

Answer: D

NEW QUESTION 2
Which statement is TRUE regarding ROLLBACK processing?

• A. It only reads active logs
• B. It always needs archive logs
• C. It can never be processed just from memory
• D. It uses output buffers, active and archive logs

Answer: D

NEW QUESTION 3
When the following SQL statement is executed, user smith will NOT be able to do which of the following? REVOKE USE OF STOGROUP stogr1 FROM smith;

• A. CREATE TRIGGER...;
• B. CREATE TABLE... IN dbl.ts1;
• C. CREATE DATABASE ... STOGROUP stogr1;
• D. CREATE TABLESPACE... USING STOGROUP stogr1;

Answer: C

NEW QUESTION 4
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 5
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 6
Which of the following can be defined on the basis of a query?

• A. An alias
• B. A base table
• C. An accelerator-only table
• D. A materialized query table

Answer: D

NEW QUESTION 7
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 8
Which type of index will cause DB2 to store the data in a given physical order?

• A. UNIQUE
• B. PRIMARY
• C. CLUSTER
• D. PARTITIONED

Answer: D

NEW QUESTION 9
Which of the following effectively and efficiently manages priorities of a mixed workload as a result of its tight integration with DB2 for z/OS?

• A. Data Facility Storage Management
• B. z/OS Parallel Sysplex Configuration
• C. Workload Manager
• D. z Systems Processor Resource

Answer: C

NEW QUESTION 10
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 11
You want to see all messages that were generated by one specific DB2 subsystem such as log switches and timeout messages. Which job log would show all of these?

• A. MSTR
• B. DBM1
• C. DIST
• D. IRLM

Answer: A

NEW QUESTION 12
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 13
When the following SQL statement is executed, the user SMITH is able to manage all objects in the DB2 subsystem except for which of the following?
GRANT DBADM ON SYSTEM TO smith;

• A. Tables
• B. Traces
• C. Sequences
• D. Security Objects

Answer: A

NEW QUESTION 14
The following warning message is issued when the last available active log data set is 5% full: DSNJ110E - LAST COPY n ACTIVE LOG DATA SET IS nnn PERCENT FULL
What will happen if you ignore this message?

• A. DB2 will shut down if it reaches the 100 % full condition
• B. DB2 will overwrite the oldest archive log without archiving
• C. DB2 will stop any activity that requires log writes if it reaches the 100 % full condition
• D. DB2 will automatically allocate more active log data sets as long as there are still less than 93 of them

Answer: A

NEW QUESTION 15
Why would an SQL statement receive an SQLCODE of +100? (Choose two)

• A. The result of a SELECT INTO statement was an empty table
• B. A rowset FETCH statement encountered one or more error conditions
• C. The statement references an object that is not defined in the DB2 subsystem
• D. An error occurred during the insertion of a row into an optional Explanation table
• E. A FETCH statement was executed when the cursor was positioned after the last row of the result table

Answer: AC

NEW QUESTION 16
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 17
Consider the following question: “What is the average salary by sex within education level?” An occasional uncommitted record can be tolerated in the average. Which of the following is the most appropriate isolation level for this?

• A. UR
• B. RR
• C. CS
• D. RS

Answer: A

NEW QUESTION 18
Consider the following scenario:
User1 creates table USER1.TABLE1 in DATABASE1 User1 grants ALL PRIVILEGES on TABLE1 to User2 User2 grants ALL PRIVILEGES on TABLE1 to User3 User1 revokes ALL PRIVILEGES on TABLE1 to User2 User3 has DBCTRL authority on DATABASE1
Is User3 able to retrieve rows from TABLE1?

• A. No
• B. Yes
• C. No, if the revoke used INCLUDING DEPENDENT PRIVILEGES
• D. Yes, if User3 was granted DBCTRL prior to the creation of table USER1.TABLE1

Answer: B

NEW QUESTION 19
Which of the following programming techniques can be used to check for any error codes after executing an SQL statement?

• A. Declaring a cursor
• B. Using the WHENEVER statement
• C. Using DCLGEN to produce declarations for tables
• D. Dynamically executing a statement with parameter markers

Answer: D

NEW QUESTION 20
Which of the following SELECT statements returns a different data value than the other SQL statements ?

• A. SELECT MONTH (CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;
• B. SELECT EXTRACT(MONTH FROM CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;
• C. SELECT LPAD(LTRIM(SUBSTR(CHAR(CURRENTTIMESTAMP(10))l6l2)t,0')l11l") FROM SYSIBM.SYSDUMMY1;
• D. SELECT TIMESTAMPDIFF(64. CHAR( CURRENT TIMESTAMP - TIMESTAMP('2021-01-01-00.00.00'))) FROM SYSIBM.SYSDUMMY1;

Answer: A

NEW QUESTION 21
DB2 native SQL procedures execute in which DB2 address space?

• A. IRLM
• B. DIST
• C. DBM1
• D. WLM stored procedure

Answer: D

NEW QUESTION 22
Which protocol provides applications the ability to connect to a server at another location and execute packages that have been previously bound at that server?

• A. CLI
• B. JDBC
• C. DRDA
• D. ODBC

Answer: D

NEW QUESTION 23
A view is considered read only if which of the following is TRUE?

• A. The first EROM clause identifies only one table
• B. The outer fullselect contains an ORDER BY clause
• C. The first SELECT clause specifies the DISTINCT option
• D. The fullselect includes a column of a base table that is defined as implicitly hidden

Answer: B

NEW QUESTION 24
......