DB2 Quiz 5 | Englishfreetest.com

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

Here's the exercise 'DB2 Quiz 5 | 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: When you will face SQLCODE -818?
    A. Multiple rows selected by Single SELECT
    B. Deadlock or timeout
    C. Authorization Failure
    D. Timestamp Mismatch
    Question 2: The final result of a DB2 BIND is
    A. Load module
    B. DB2 catalog
    C. Data base request module
    D. DB2 (application) Plan
    Question 3: What does a positive value of SQL code mean?
    A. Warning
    B. Error
    C. Successful execution
    D. No rows found
    Question 4: How many clustering index we can have for a single table?
    A. 15
    B. 10
    C. 1
    D. No Limit
    Question 5: Which of the following allow you to perform administrative tasks against database objects?
    A. Control Center
    B. Journal
    C. Task Center
    D. Health Center
    Question 6: An INSERT statement:
    A. May contain a subquery
    B. Must contain a VALUES list
    C. Must contain a column list
    D. May create multiple table rows
    Question 7: How can the locks be classified?
    A. Size
    B. Duration
    C. Mode
    D. All of these
    Question 8: Which of the following DB2 objects allows multiple users to access data in a table with each only being able to access certain portions of the data?
    A. Views
    B. Aliases
    C. Indexes
    D. Mirrored tables
    Question 9: Which of the following DB2 tools allows a user to set DB2 registry parameters?
    A. Task Center
    B. Visual Explain
    C. Configuration Assistant
    D. Satellite Administration Center
    Question 10: In DB2, DATA is physically stored in
    A. VSAM ESDS
    B. VSAM KSDS
    C. VSAM LDS
    D. TABLES