File Info
| Exam | DB2 11.1 Fundamentals for LUW |
| Number | C2090-616 |
| File Name | IBM.C2090-616.CertKey.2019-01-06.37q.tqb |
| Size | 146 KB |
| Posted | Jan 06, 2019 |
| Download | IBM.C2090-616.CertKey.2019-01-06.37q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
A user executes the following statements:
СREATE TABLE t1 (c1 INT, c2 INT);
CREATE ALIAS a1 FOR t1;
What will be the result if the user executes the following statement?
DROP ALIAS a1;
- The alias A1 will be dropped
- The table T1 will be dropped
- Both T1 and A1 will be dropped
- Nothing, the statement will result in an error
Correct answer: A
Question 2
Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?
- NOT NULL
- Foreign key
- Primary key
- Informational constraint
Correct answer: C
Explanation:
Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-0401melnyk/index.html Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-0401melnyk/index.html
Question 3
Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?
- A ROLLBACK command executed just after the COMMIT command cancels that COMMIT
- Save points defined during transaction T1 are released only if there is a RELEASE SAVEPOINT command executed after the COMMIT command
- It finishes the current T1 unit of work and a new one is initiated, however it is possible to ROLLBACK to the latest SAVEPOINT before COMMIT
- It finishes the current T1 unit of work and a new one is initiated. All changes made by UPDATE and DELETE commands during unit of work T1 are committed
Correct answer: D
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/db2z_sql_commit.html Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/db2z_sql_commit.html
