DB2 Quiz 3 | Englishfreetest.com

  • Do test 20 minutes
  • Number Questions: 10 questions
  • By: englishfreetest.com
Do test

Here's the exercise 'DB2 Quiz 3 | Englishfreetest.com' about Technical Quiz - Technical Tests.


Put your knowledge about all things technology to the test Because everything tech, from computers and the internet to software and big data, changes rapidly on a day-to-day basis, it’s now a must to stay up to date with the technology that dominates our modern day lives. Are you up to speed on what’s going on in the tech industry today? Take our quiz to find out. Test how much you know about technology

You can find more to the lesson and more exercises. Technical Quiz - Technical Tests in here.

Finally, click here to "Test" for start practice exercise .

  • Test content
    Question 1: Which table space is divided into segments of 4 to 64 pages in increments of 4 and each segment holds data for only one table?
    A. Simple Table space
    B. Segmented Table space
    C. Partitioned Table space
    D. None of these
    Question 2: How many primary keys can be declared on a table?
    A. No Limit
    B. Only 1
    C. 5
    D. 10
    Question 3: What does application plan contains?
    A. DBRM
    B. Package
    C. Both A & B
    D. None of these
    Question 4: When you will face SQLCODE -805?
    A. No Rows found satisfying the SQL statement or End of Cursor
    B. Object not defined in DB2
    C. Program has not been binded to the Plan
    D. Duplicate Key on INSERT or UPDATE
    Question 5: Suppose we added a new column by using ALTER statement, where the column will be added?
    A. Starting of the table
    B. End of the table
    C. Middle of the table
    D. None of these
    Question 6: If a transaction takes a Shared lock on some data, then other transactions can get what type of lock?
    A. Shared
    B. Update
    C. Exclusive
    D. Both A & B
    Question 7: Which component is used to processes SQL statements and selects the access paths?
    A. Buffer Manager
    B. Data Manager
    C. DB2 Optimizer
    D. None of these
    Question 8: What is the maximum size of a CHAR data type in DB2?
    A. 256 bytes
    B. 1032 bytes
    C. 254 bytes
    D. 1064 bytes
    Question 9: Which command is used to commit a transaction in CICS program?
    A. AUTO COMMIT
    B. SYNCPOINT
    C. ROLLBACK
    D. COMMIT
    Question 10: What is the maximum size of a VARCHAR data type in DB2?
    A. 256 bytes
    B. 1032 bytes
    C. 4046 bytes
    D. 1064 bytes