| 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? JDOE.t1 db2inst1.t1 foo.t1 bar.t1
|
| 2: | Which of the following is not created when you create a database? IBMDEFAULTBP IBMDEFAULTSPACE IBMDEFAULTGROUP SYSCATSPACE IBMTEMPGROUP
|
| 3: | Which of the following objects will ensure rows are assigned a unique value across multiple tables? Identity column Unique index Sequence Row ID
|
| 4: | Which of the following commands will delete all rows from the table t1 without logging? Truncate table Delete * from t1 no log Alter table t1 activate not logged initially with truncate Alter table t1 activate not logged initially with empty table
|
| 5: | To ensure that a column can contain only the values T or F, which option should you choose? Create a unique index on the column. Create a check constraint on the column. Specify the column as NOT NULL. Create a view on the table.
|
| 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? Restrict Cascade Drop Set NULL
|
| 7: | Which two of the following can be referenced by a foreign key constraint? Unique index Unique constraint Check constraint Primary key Identity column
|
| 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? 0 1 2 3
|
| 9: | Consider the following statement. CREATE TABLE wqwq (c1 DECIMAL)
What will the precision and scale be for column c1? Precision = 15, scale = 0 Precision = 15, scale =15 Precision = 5, scale = 0 Precision = 5, scale = 10
|
| 10: | Which of the following is not a supported type of trigger? INBETWEEN AFTER INSTEAD OF BEFORE
|
| 11: | Which of the following does not belong to a database? Schema Logs Registry variables System catalogs
|
| 12: | Consider the following statement. CREATE TABLE foo (c1 INT NOT NULL PRIMARY KEY, c2 INT)
How many database objects are created? 1 2 3 4
|
| 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? 1 2 3 4
|
| 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
1, 2, 3 3, 2, 1 2, 1, 3 2, 3, 1
|
| 16: | Which of the following objects' definitions can be altered by using the ALTER statement? Table View Index Schema
|
| 17: | A package contains which of the following? (Choose all that apply.) Executable SQL statements The access path that the DB2 optimizer chooses to retrieve the data A collection of stored procedures and functions A list of bind files
|
| 18: | Tables with the same name can be created within the same database by creating them in which of the following? Different partitions Different partition groups Different table spaces Different schemas
|
| 19: | Which of the following can be used to obtain the next value of the sequence seq1? (Choose all that apply.) seq1.nextValue NEXTVAL FOR seq1 NEXT VALUE FOR seq1 seq1.next
|
| 20: | Which of the following statements is true? A user temporary table space is created with the create temporary table statement. The creation of a user temporary table space will fail if no system temporary table space is available. A user temporary table is created in TEMPSPACE1. A user temporary table space is needed so that declared global temporary tables can be declared.
|
