Which of the following DB2 objects are publicly referenced names that require no special authority or privileg
Which of the following DB2 objects are publicly referenced names that require no special authority
or privilege to use them?
Which of the following describes the objects of a DB2 database and their relationships?
Which of the following describes the objects of a DB2 database and their relationships?
Which of the following database objects is considered executable using SQL?
Which of the following database objects is considered executable using SQL?
How many of these INSERT statements will be successful?
Given the following DDL and INSERT statements:
CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10;
CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION;
CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100;
INSERT INTO v1 VALUES(5);
INSERT INTO v2 VALUES(5);
INSERT INTO v3 VALUES(20);
INSERT INTO v3 VALUES(100);
How many of these INSERT statements will be successful?
what happens?
When a client using the SERVER_ENCRYPT authentication type connects to a server using the
SERVER authentication type, what happens?
Which DB2 object can be referenced by an INSERT statement to meet this requirement?
A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID
column values need to be incremented by 1000 for each new expense report added to the
EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet this
requirement?
What is the current content of the staffsalary table?
The following SQL statements were executed in sequence:
CREATE DISTINCT TYPE salary AS decimal(7,2) WITH COMPARISONS;
CREATE TABLE staffsalary(empid INT, empsalary salary);
INSERT INTO staffsalary VALUES (10, 50000), (20, 50000.00);
UPDATE staffsalary SET empsalary = 60000
WHERE salary(50000) = empsalary;
What is the current content of the staffsalary table?
Which of the following provides a logical grouping of database objects?
Which of the following provides a logical grouping of database objects?
Which of the following create index statements will meet this criteria and require the least amount of storage
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 the table is queried. Which of the following create index statements will
meet this criteria and require the least amount of storage for the index object?
Which of the following is a characteristic of a sequence?
Which of the following is a characteristic of a sequence?