Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home IBM C2090-616

IBM C2090-616 Exam Practice Questions (P. 2)

  • Full Access (63 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #6
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;
  1. A
    The alias A1 will be dropped
  2. B
    The table T1 will be dropped
  3. C
    Both T1 and A1 will be dropped
  4. D
    Nothing, the statement will result in an error

Correct Answer:
A

Question #7
Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?
  1. A
    NOT NULL
  2. B
    Foreign key
  3. C
    Primary key
  4. D
    Informational constraint

Correct Answer:
C
Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-0401melnyk/index.html

Question #8
Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?
  1. A
    A ROLLBACK command executed just after the COMMIT command cancels that COMMIT
  2. B
    Save points defined during transaction T1 are released only if there is a RELEASE SAVEPOINT command executed after the COMMIT command
  3. C
    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
  4. D
    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
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/db2z_sql_commit.html

Question #9
Which of the following statements about stored procedures is TRUE?
  1. A
    Stored procedures can be written in SQL PL, but not in the PL/SQL dialect
  2. B
    The CREATE SOURCED PROCEDURE statement defines a procedure that is based on another procedure in a federated database
  3. C
    There are three types of stored procedures which can be deployed: SQL procedures, external procedures, and sourced procedures
  4. D
    Two identically-named procedures within a schema are permitted to have exactly the same number of parameters, but the parameters must have different data types assigned

Correct Answer:
B
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0023603.html

Question #10
Which edition of DB2 LUW has been discontinued in v11.1?
  1. A
    DB2 Developer Edition
  2. B
    DB2 Express Server Edition
  3. C
    DB2 Enterprise Server Edition
  4. D
    DB2 Connect Enterprise Server Edition

Correct Answer:
B
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.licensing.doc/doc/r0053238.html

Previous Questions Next Questions

All Pages