DB2 (5/4)

Can we add column to add table after defining it?

• yes      

• No    

• Only for table with primary key      

• none

Failure to use null indicator variable when referencing a nullable column will give the following SQLCODE

• +150

• –100

• +276

• -305

Object-based Logical Model that is most widely used

• relationship-entity model

• record-entity logical model

• relationship-entity model

• entity-relationship model

Choose the correct syntax to display names with character 'y'

• __y%

• %y%

• y__%

• %y__

What are the different types of table spaces in DB2?

• Simple table spaces

• segmented table spaces

• Hash table spaces

• partitioned

What is a DB2 buffer pool?

• A collection of related SQL statements that are stored in the database

• A virtual storage area where SQL statements are stored

• A section of memory where data is temporarily stored during I/O operations

• A data structure used to store the records in a table

Which utility is used to load data into a DB2 table?

• UNLOAD

• LOAD

• EXPORT

• IMPORT

What is a DB2 lock?

• A data structure used to store the records in a table

• A mechanism that ensures that only one user at a time can access a particular record in a table

• A virtual storage area where SQL statements are stored

• A section of memory where data is temporarily stored during I/O operation

Absence of data value is represented as___ in a relational system.

• null

• not null

• zero

• space

Which SQL JOIN would be appropriate to use if you want to return all rows from both tables and the matching rows from the tables that are joined?

• RIGHT JOIN

• INNER JOIN

• LEFT JOIN

• FULL OUTER JOIN