DB2 Quiz 4 | Englishfreetest.com

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

Here's the exercise 'DB2 Quiz 4 | 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: If a transaction takes a Update lock on some data, then other transactions can get what type of lock?
    A. Shared
    B. Update
    C. Exclusive
    D. Both A & B
    Question 2: Which columns are good for indexing?
    A. Primary Key Columns
    B. Foreign Key Columns
    C. Columns with unique values
    D. All of these
    Question 3: What is not a valid DB2 data type?
    A. Char
    B. Alphanumeric
    C. Varchar
    D. Integer
    Question 4: Which of the following can refer to both local as well as remote tables?
    A. Synonyms
    B. Alias
    C. Both A & B
    D. None of these
    Question 5: Which DB2 component is used for remote database server connection?
    A. Locking Services Component
    B. System Services Component
    C. Database Services Component
    D. Distributed Data Facility Component
    Question 6: Which component is responsible for execution of SQL statements?
    A. Locking Services Component
    B. System Services Component
    C. Database Services Component
    D. Stored Procedures Component
    Question 7: How many databases can a DB2 system manage?
    A. 1 database
    B. 65279 databases
    C. 10 databases
    D. Unlimited
    Question 8: Which table space houses only one table?
    A. Simple Table space
    B. Segmented Table space
    C. Partitioned Table space
    D. None of these
    Question 9: 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 10: Write a query to delete a table TAB from database.
    A. DELETE TABLE TAB
    B. DELETE TAB
    C. DROP TAB
    D. DROP TABLE TAB