单选题Given the following table definition: STOCK: item VARCHAR(30) status CHAR(1) quantity INT price DEC(7,2) If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero, which of the following statements would be used...
Saturday, July 15, 2023
单选题Given the following DDL for the PARTS table:CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever...
Monday, November 27, 2023
单选题Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?()A The cursor is only protected from updates and deletes by concurrent applications.B The row is only protected from positioned updates and delet...
Wednesday, March 6, 2024
单选题Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?()A Define a UNIQUE constraint on the columns NEXT_STEPNO...
Saturday, July 29, 2023
单选题Which of the following is a characteristic of a schema?()A Foreign key references cannot cross schema boundaries.B A DB2 user must be created before a schema with the same name can be created.C If no schema is specified when an object is created, the d...
Saturday, April 13, 2024
单选题If a unique constraint is defined on column COL1 of table TAB1, what are the characteristics of COL1?()A COL1 will accept NULL values and can be referenced in another table's foreign key specification.B COL1 will not accept NULL values and cannot be re...
单选题Which of the following DB2 products are required on an iSeries or System i server to enable an application running on that server to retrieve data from a DB2 database on a Linux server?()A DB2 for i5/OSB DB2 Runtime ClientC DB2 Connect Enterprise Editi...
Monday, January 22, 2024
单选题Application A holds an Update lock on a single row and application B is trying to read that row. If both applications are using isolation level UR, which of the following will occur?()A Application B will read the row.B Applications A and B will cause ...
单选题Which of the following tools can be used to schedule a backup operation that is to be run every Sunday evening?()A JournalB Task CenterC Activity MonitorD Command Line Processor...
Sunday, February 26, 2023
单选题Which kind of non-sourced UDF can be created so that it only returns a single value?()A RowB TableC ScalarD Column...
单选题An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming ...
Saturday, September 2, 2023
单选题Which of the following strings can be inserted into an XML column using XMLPARSE?()A employee/B ?xml version='1.0' encoding='UTF-8' ?C !DOCTYPE hello SYSTEM 'hello_world.dtd'D x xmlns:ibmcert='http://www.ibm.com/certify'...
Wednesday, January 3, 2024
单选题Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?()A An application process acquires at least a share lock on the current row of every cursor.B Any row that is read during a unit of work cannot be changed by other applic...
单选题How does DB2 protect the integrity of indexes when data is updated?()A Locks are acquired on the data.B Locks are acquired on index keys.C Locks are acquired on index pages.D Locks are acquired on index pointers....
单选题Which of the following is a characteristic of a sequence?()A A sequence will never generate duplicate valuesB The MAXVALUE of a sequence can be equal to the MINVALUEC It is not possible to create a sequence that generates a constant since the INCREMENT...
Saturday, March 30, 2024
单选题Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?()A REVOKE ADD, DELETE FROM USER tom ON TABLE tab1B REVOKE ADD, DELETE ON TABLE tab1 FROM USER tomC REVOKE INSERT, DELETE FROM USER tom ON TABLE t...
单选题Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?()A UniqueB CheckC ReferentialD Informational...
单选题Which of the following is a typical data warehouse query?()A What is this customers address?B Does this customer have any unpaid bills?C What is the balance in this customers account?D What are the total sales for each of the last 6 months?...
单选题A table was created using the following DDL: CREATE TABLE employee (id SMALLINT NOT NULL, name VARCHAR(9), dept SMALLINT CHECK (dept BETWEEN 10 AND 100), job CHAR(10) CHECK (job IN ('Sales','Mgr','Clerk')), hiredate DATE, salary DECIMAL(7,2), comm DECI...
Tuesday, March 19, 2024
单选题Given the following requirements:Create a table named TESTTAB, which has an identity column named ACTIVITYNO. Define the identity column to generate the values for the column by default. Start the values at 10 and increment by 10. Make the identity col...