1: | Consider the following instructions/commands/statements:
Login to your Linux server as user JDOE su db2inst1 (switch user to db2inst1) CONNECT TO sample USER foo USING bar SELECT * FROM t1 Which table will you select data from?
|
2: | Which of the following is not created when you create a database?
|
3: | Which of the following objects will ensure rows are assigned a unique value across multiple tables?
|
4: | Which of the following commands will delete all rows from the table t1 without logging?
|
5: | To ensure that a column can contain only the values T or F, which option should you choose?
|
6: | When deleting a row from a table that has a primary key defined, which of the following options on a foreign key clause will delete all rows with the same value in the foreign key table?
|
7: | Which two of the following can be referenced by a foreign key constraint?
|
8: | Given the table created as follows:
CREATE TABLE product ( productno INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 0 INCREMENT BY 5), description VARCHAR(50) ) And these statements: INSERT INTO product VALUES (DEFAULT,'banana') INSERT INTO product (description) VALUES ('apple') INSERT INTO product VALUES (300,'pear'), How many rows will be in the table?
|
9: | Consider the following statement.
CREATE TABLE wqwq (c1 DECIMAL)
What will the precision and scale be for column c1?
|
10: | Which of the following is not a supported type of trigger?
|
11: | Which of the following does not belong to a database?
|
12: | Consider the following statement.
CREATE TABLE foo (c1 INT NOT NULL PRIMARY KEY, c2 INT)
How many database objects are created?
|
13: | Consider the following db2nodes.cfg file.
0 mysrv1 0 1 mysrv1 1 2 mysrv2 0 3 mysrv2 1 How many servers are the partitions running on?
|
14: | Which of the following objects cannot be created in a large table space?
A. Data A. Index A. LONG VARCHAR A. LOB |
15: | To create the table space ts1 successfully in the database sample, place the following steps in the correct order.
1. CREATE TABLESPACE ts1 PAGESIZE 16K BUFFERPOOL bp1 2. CONNECT TO sample 3. CREATE BUFFERPOOL bp1 SIZE 100000 PAGESIZE 16K
|
16: | Which of the following objects' definitions can be altered by using the ALTER statement?
|
17: | A package contains which of the following? (Choose all that apply.)
|
18: | Tables with the same name can be created within the same database by creating them in which of the following?
|
19: | Which of the following can be used to obtain the next value of the sequence seq1? (Choose all that apply.)
|
20: | Which of the following statements is true?
|