DB2 9 Family Fundamentals
Question No: 171
If a unique constraint is defined on column COL1 of table TAB1, what are the characteristics of COL1?
COL1 will accept NULL values and can be referenced in another table#39;s foreign keyspecification.
COL1 will not accept NULL values and cannot be referenced in another tables foreign key specification.
COL1 will not accept NULL values and can be referenced in another tables foreign key specification.
COL1 will accept NULL valuesand cannot be referenced in another tables foreign key specification.
Question No: 172
Which of the following DB2 tools allows a user to set DB2 registry parameters?
Satellite Administration Center
Question No: 173
A view is created with the following statement: CREATE VIEW v1
AS SELECT col1, col2, col3, col4 FROM t1
WHERE col4 gt;1000 WITH CHECK OPTION
What is the effect of the CHECK OPTION clause?
Any row inserted or updated through view V1 must meet the condition that col4 gt; 1000.
From now on, any row inserted or updated in table T1 must meet the condition that col4
gt; 1000, but existing rows in the table are not checked.
At view creation, DB2 will check the data in table T1, and if in any row doesn#39;t meet the condition col4 gt; 1000, the view creation will be rejected.
Any row inserted or updated through view V1 mustmeet the condition that col4 gt; 1000 and no row in table T1 can be updated such that col4 lt;= 1000, but new rows in the table can be inserted with col4 lt;= 1000.
Question No: 174
Given the following CREATE TABLE statement: CREATE TABLE table2 LIKEtable1
Which two of the following will NOT occur when the statement is executed?
TABLE2 will have the same column names and column data types as TABLE1
TABLE2 will have the same column defaults as TABLE1
TABLE2 will have the same nullability characteristics as TABLE1
TABLE2 will have the same indexes as TABLE1.
TABLE2 will have the same referential constraints as TABLE1
Question No: 175
Which of the following is an accurate statementabout packages?
Packages provide a logical grouping of database objects.
Packages contain control structures that are considered the bound form for SQL statements
Packages describe the objects in a DB2 database and their relationship to each other
Packages may be used during query optimization to improve the performance for a subset of SELECT queries
Question No: 176
Which of the following aretypes of routine objects?
Package and function
Function and userexit
Procedure and package
Function and procedure
Question No: 177
After the following SQL statement is executed:
GRANT ALL PRIVILEGES ON TABLE employee TO USER user1
Assuming user USER1 has no other authorities or privileges, which of the following actions is user USER1 allowed to perform?
Drop an index on the EMPLOYEE table
Grant all privileges on the EMPLOYEE table to other users
Alter the table definition
Drop the EMPLOYEE table
Question No: 178
Whichof the following causes a lock that is being held by an application using the Cursor Stability isolation level to be released?
The cursor is moved to another row
The row the cursor is on is deleted by the application
The row the cursor is on isdeleted by another application
The row the cursor is on needs to be updated by another application
Question No: 179
A stored procedure has been created with the followingstatement:
CREATE PROCEDURE proc1 (IN var1 VARCHAR(10), OUT rc INTEGER) SPECIFIC myproc LANGUAGE SQL …
What is the correct way to invoke this procedure from the command line processor (CLP)?
CALL proc1 (#39;SALES#39;, ?)
CALL myproc (#39;SALES#39;, ?)
CALLproc1 (SALES, ?)
RUN proc1 (SALES, ?)
Question No: 180
57 Given table T1 has column I1 containing the following data: I1
If the following sequence of SQL statements is applied within a single unit of work: UPDATE t1 SET i1 = 3 WHERE i1 = 2; S
AVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE t1 SET i1 = 5 WHERE i1 = 3;
SAVEPOINT s2 ON ROLLBACK RETAIN CURSORS; INSERT INTO t1 (i1) VALUES (6);
ROLLBACK TOSAVEPOINT s1; UPDATE t1 SET i1 = 2 WHERE i1 = 4; COMMIT;
What is the expected sequence of values returned from? SELECT i1 FROM t1 ORDER BY i1
A. 1, 2, 3, 3
B. 1, 2, 2, 4
C. 1, 2, 3, 3, 6
D. 1, 2, 2, 5, 6
100% Free Download!
–Download Free Demo:C2090-730 Demo PDF
100% Pass Guaranteed!
–Download 2017 EnsurePass C2090-730 Full Exam PDF and VCE
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|