Question 1

0 out of 1 points

Which of the following is true about the FLWOR expression?

Answer
Selected
Answer:
Correct
Answer:

WHERE is used to reorder items of the iteration

"FOR is used to iterate through a sequence, bind
variable to items"

Question 2
0 out of 1 points

Which of the following commands are NOT classified under

Transaction Control Languages?
Answer
Selected Answer:

SAVEPOINT
Correct Answer:

GRANT

Question 3
0 out of 1 points

Assuming that the PORDER column contains the following XML data:
100-100-01
Sled, Metal
1
100-201-01
Heater, Large
2
What will be the new value of the PORDER column after executing the
following statement?
UPDATE purchaseorder SET porder =
xmlquery('transform
copy $po := $order
modify do insert
document {
100-103-01

Snow Shovel, Super Deluxe 26 inch

4
}
into $po/PurchaseOrder
return $po'
passing PURCHASEORDER.PORDER as ""order"")
WHERE poid=5012;"
Answer
Selected Answer:

"
100-100-01
Sled, Metal
1
100-201-01
Heater, Large
2
"
Correct Answer:

"
100-100-01
Sled, Metal
1
100-201-01
Heater, Large
2
100-103-01
Snow Shovel, Super Deluxe 26 inch
4
"

Question 4
1 out of 1 points

Which of the following statement is used to change a database table?

Answer
Selected Answer:

ALTER TABLE
Correct Answer:

ALTER TABLE

Question 5
0 out of 1 points

Which of the following is NOT an IBM Data Server Driver

Answer
Selected Answer:

IBM Data Server Driver for ODBC and CLI

Correct Answer:

IBM Data Server Driver for MDBC

Question 6
0 out of 1 points

Which of the following is the lowest cost DB2 product that can be
legally installed on a Unix server that has 2 CPUs?
Answer
Selected Answer:

DB2 Express Edition

Correct Answer:

DB2 Workgroup Server Edition

Question 7
0 out of 1 points

Which of the following is NOT true when the following statement is

executed?
RESTORE DATABASE SAMPLE TABLESPACE (MYTBSP) FROM /tbspbkp
Answer
Selected
Answer:

Correct
Answer:

The /tbspbkp is the path where the restore resource will

be coming from
The statement performs an online restore

Question 8
0 out of 1 points

Which of the following is NOT true about an index?

Answer

Selected Answer:

It is based always on one or more columns of a table

Correct Answer:

It provides compression of the rows of a table

Question 9
0 out of 1 points

Which of the following differentiates the Isolation Level Currently

Committed from Cursor Stability?
Answer
Selected
Answer:

Correct
Answer:

In Cursor Stability Reader blocks Reader while in Currently

Committed Reader does NOT block Reader
In Cursor Stability Writer blocks Reader while in Currently
Committed Writer does NOT block Reader

Question 10
0 out of 1 points

This specifies the order of operations for accessing data necessary to

resolve a SQL or XQuery statement
Answer
Selected Answer:

DB2 SQL Access

Correct Answer:

DB2 Access Plan

Question 11
1 out of 1 points

Which of the following is NOT a log file state?

Answer
Selected Answer:

Inactive
Correct Answer:

Inactive

Question 12
0 out of 1 points

Which of the following is true about DB2 import utility?

Answer
Selected
Answer:

DB2 import utility does not perform constraint validation

Correct
Answer:

DB2 load utility writes data in the database using normal

insert operations

Question 13
0 out of 1 points

"Given the following table definition:

SALES
--------------------------------------------INVOICE_NO CHAR(20) NOT NULL
SALES_DATE DATE
SALES_PERSON CHAR(20)
REGION CHAR(20)
SALES INTEGER
If the following SELECT statement is executed, which of the following
describes the order of the rows
in the result data set produced?
SELECT * FROM sales"
Answer
Selected
Answer:

Correct
Answer:

The rows are ordered based on when they were inserted

into the table.
The rows are not sorted in any particular order.

Question 14
0 out of 1 points

Which of the following is NOT true about components of the Relational

Data Model?
Answer
Selected
Answer:

Correct
Answer:

The Domain is the data type that defines a possible set of

values that a data set can be.
The Column is a set of attribute values that span across
attributes.

Question 15
0 out of 1 points

"Two applications have created a deadlock cycle in the locking

subsystem. If lock timeout is set to 30 and both applications were
started at the same time, what action will the deadlock detector take

when it ""wakes up"" and discovers the deadlock?"

Answer
Selected
Answer:

Correct
Answer:

It will rollback the current transactions of both

applications
It will randomly pick an application and rollback its
current transaction

Question 16
0 out of 1 points

Which one of the following is a valid XPATH expression to retrieve an

text value within an XML document?
Answer
Selected Answer:

/dept
Correct Answer:

/dept/employee/text()

Question 17
0 out of 1 points

Given the following table:

TAB1 RESULT
COL1 COL2 COL1 COL2
----- ----- ----- ----A 10 A 10
B 20 B 20
C 30 C 30
A 10 D 40
D 40
C 30
Which of the following statements will produce the desired results?
Answer
Selected Answer:

SELECT UNIQUE(*) FROM tab1

Correct Answer:

SELECT DISTINCT * FROM tab1

Question 18
1 out of 1 points

"Given the following two tables:

NAMES POINTS
------------------------ ------------------------

NAME NUMBER NAME POINTS

------------- ------- ------------- ------Wayne Gretzky 99 Wayne Gretzky 244
Jaromir Jagr 68 Bobby Orr 129
Bobby Orr 4 Brett Hull 121
Bobby Hull 23 Mario Lemieux 189
Mario Lemieux 66 Joe Sakic 94
How many rows would be returned using the following statement?
SELECT name FROM names, points"
Answer
Selected Answer:

25
Correct Answer:

25

Question 19
0 out of 1 points

Which of the following is NOT a component of a relational data model?

Answer
Selected Answer:

attribute
Correct Answer:

column

Question 20
1 out of 1 points

Which command can be used to determine the minimum PIT?

Answer
Selected Answer:

GET SNAPSHOT FOR TABLESPACES ON mydb

Correct Answer:

GET SNAPSHOT FOR TABLESPACES ON mydb

Question 21
0 out of 1 points

Which of the following is NOT an instance-level authority?

Answer
Selected Answer:

SYSADM
Correct Answer:

SYSDB

Question 22

0 out of 1 points

"If table TAB1 is created using the following statement:

CREATE TABLE tab1 (col1 INTEGER NOT NULL,
col2 CHAR(5),
CONSTRAINT cst1 CHECK (col1 in (1, 2, 3)))
Which of the following statements will successfully insert a record into
table TAB1?"
Answer
Selected Answer:

"INSERT INTO tab1 VALUES (0, 'abc')"

Correct Answer:

"INSERT INTO tab1 VALUES (ABS(2), 'abc')"

Question 23
1 out of 1 points

Application A is running under the Repeatable Read isolation level and

holds an Update lock on table TAB1. Application B wants to query
table TAB1 and cannot wait for Application A to release its lock. Which
isolation level should Application B run under to achieve this
objective?
Answer
Selected Answer:

Uncommitted Read
Correct Answer:

Uncommitted Read

Question 24
0 out of 1 points

Which of the following is NOT true about DB2 table space?

Answer
Selected
Answer:

"All tables, indexes, and other data are stored in a table

space"

Correct Answer:

Cannot be associated to a specific buffer pool

Question 25
0 out of 1 points

"After the following SQL statement is executed:

GRANT ALL PRIVILEGES ON TABLE employee TO USER user1
Assuming user USER1 has no other authorities or privileges, which of
the following actions is user

USER1 allowed to perform?"

Answer
Selected Answer:

Drop an index on the EMPLOYEE table

Correct Answer:

Alter the table definition

Question 26
1 out of 1 points

Which of the following is NOT true about infinite logging?

Answer
Selected
Answer:

Correct
Answer:

Archived logs does not hinder performance for rollback

and crash recovery
Archived logs does not hinder performance for rollback
and crash recovery

Question 27
1 out of 1 points

Which database object has a CREATEIN privilege?

Answer
Selected Answer:

schema
Correct Answer:

schema

Question 28
0 out of 1 points

Which of the following is NOT true about domains and data types?
Answer
Selected
Answer:
Correct
Answer:

Data types in columns are required

A domain is the set of some possible values for the
specific attribute

Question 29
0 out of 1 points

Which of the following is NOT a characteristic of normalization?

Answer

Selected Answer:

It is used to remove anomalies

Correct Answer:

It is used to remove uncommon rows

Question 30
0 out of 1 points

Which of the following is NOT true about data models?

Answer
Selected Answer:

Intended for the software developer

Correct Answer:

Independent of specific implementations and

protocols

Question 31
0 out of 1 points

Which of the following is NOT automatically created by DB2?

Answer
Selected Answer:

Configuration Information
Correct Answer:

User Temporary Table Spaces

Question 32
0 out of 1 points

Which of the following is NOT a way to grant privileges?

Answer
Selected Answer:

Indirect
Correct Answer:

Defined

Question 33
0 out of 1 points

"A stored procedure has been created with the following statement:
CREATE PROCEDURE proc1 (IN var1 VARCHAR(10), OUT rc INTEGER)
SPECIFIC myproc LANGUAGE SQL...
What is the correct way to invoke this procedure from the command
line processor (CLP)?"
Answer

Selected Answer:

"CALL proc1 (SALES, ?)"

Correct Answer:

"CALL proc1 ('SALES', ?)"

Question 34
0 out of 1 points

Which of the following is NOT a characteristic of a system-defined

routine?
Answer
Selected Answer:

Immediately ready-to-use
Correct Answer:

Created by the user

Question 35
0 out of 1 points

Which of the following statements is syntactically incorrect?

Answer
Selected Answer:

CONNECT TO mydb
Correct Answer:

DROP mydb

Question 36
0 out of 1 points

Which of the following is TRUE about committed data?

Answer
Selected Answer:

changes cannot be committed automatically

Correct Answer:

data is consistent with the database

Question 37
0 out of 1 points

Which of the following is NOT provided by a database?

Answer
Selected Answer:

Security
Correct Answer:

Creation of forms

Question 38
0 out of 1 points

Given the following UPDATE statement:

UPDATE employees SET workdept =
(SELECT deptno FROM department WHERE deptno = 'A01')
WHERE workdept IS NULL
Which of the following describes the result if this statement is
executed?
Answer
Selected
Answer:

Correct
Answer:

The statement will fail because an UPDATE statement

cannot contain a subquery.
The statement will only succeed if the data retrieved by
the subquery does not contain multiple records.

Question 39
0 out of 1 points

Which of the following events will NOT cause a trigger to be

activated?
Answer
Selected Answer:

A delete operation
Correct Answer:

A select operation

Question 40
0 out of 1 points

Which of the following is TRUE about SQL?

Answer
Selected
Answer:

Correct
Answer:

DML is used to control access to database and database

objects
DDL is used to define properties of data objects

Question 41
0 out of 1 points

Which of the following is a well-formed XML document?

Answer
Selected Answer:

John
Correct Answer:

John

Question 42
0 out of 1 points

Which of the following is NOT true about XML Indexes?

Answer
Selected
Answer:

Correct
Answer:

The XML region index captures how an XML document is

divided up internally into regions
User-defined indexes are the ones created by users to
improve storage space

Question 43
0 out of 1 points

Which of the following XML function creates a temporary SQL table

using XML data?
Answer
Selected Answer:

XMLSEQUENCE
Correct Answer:

XMLTABLE

Question 44
0 out of 1 points

Which of the following is true about isolation levels?

Answer
Selected Answer:

Read Stability is the default isolation level

Correct Answer:

Repeatable Read has no phantom reads

Question 45
0 out of 1 points

Which of the following is TRUE about static SQL?

Answer
Selected
Answer:

Correct
Answer:

It is suited for scenarios when application requires user to

be prompted for key parts of an SQL
statement
Its syntax is fully known at precompile time

Question 46
1 out of 1 points

Which of the following command demonstrates the creation of a

schema?
Answer
Selected
Answer:

Correct
Answer:

db2 CREATE SCHEMA myschema AUTHORIZATION

db2inst1
db2 CREATE SCHEMA myschema AUTHORIZATION
db2inst1

Question 47
0 out of 1 points

"Consider the following scenario: You are currently connected to a

database called MYDB as the
user MYUSER. When creating a table within this database, you use the
command:
CREATE TABLE MYTABLE (DEPT CHAR(3) NOT NULL)
Under which schema is the table MYTABLE created?"
Answer
Selected Answer:

DB2INST1
Correct Answer:

MYUSER

Question 48
0 out of 1 points

"How many transactions are there in the following SQL statements?

CONNECT TO DB employees
INSERT INTO employee VALUES (100, 'JOHN')
INSERT INTO employee VALUES (200, 'MANDY')
COMMIT

UPDATE employee SET empID=201 where name='MANDY'

COMMIT
DELETE FROM employee WHERE name='MANDY'
UPDATE employee SET empID=101 where name='JOHN'
ROLLBACK"
Answer
Selected Answer:

1
Correct Answer:

Question 49
0 out of 1 points

DB2 Access Plan provides the following objects/parameters except

Answer
Selected Answer:

Operators
Correct Answer:

Shortcut

Question 50
0 out of 1 points

Which of the following statements allows user USER1 to take the

ability to create packages in a database named SAMPLE away from
user USER2?
Answer
Selected
Answer:

REVOKE CREATETAB ON DATABASE FROM user2

Correct Answer:

REVOKE BINDADD ON DATABASE FROM user2

Question 51
0 out of 1 points

"While attempting to connect to a database stored on a Windows

server from a Linux client, the following message was displayed:
SQL1013N The database alias name or database name ""TEST_DB""
could not be found.
Which of the following actions can be used to help determine why this
message was displayed?"
Answer
Selected
Answer:

Execute the LIST DATABASE DIRECTORY command on the

server; look for an entry for the TEST_DB database

Correct
Answer:

Execute the LIST DATABASE DIRECTORY command on the

client; look for an entry for the TEST_DB database

Question 52
0 out of 1 points

Which of the following backup process refers to backing up all

database data changes since the last full backup?
Answer
Selected Answer:

full backup
Correct Answer:

incremental cumulative backup

Question 53
1 out of 1 points

Application A wants to read a subset of rows from table TAB1 multiple

times. Which of the following
Answer
Selected
Answer:

Correct
Answer:

isolation levels should Application A use to prevent other

users from making modifications and additions to table TAB1
that will affect the subset of rows read?
isolation levels should Application A use to prevent other
users from making modifications and additions to table TAB1
that will affect the subset of rows read?

Question 54
0 out of 1 points

Which of the following is NOT true about automatic storage table

space?
Answer
Selected
Answer:

Correct
Answer:

It is an extension of the existing System Manage (SMS) and

Database Manage (DMS) table space types
There is no automatic storage

Question 55
0 out of 1 points

Which of the following is true about XML columns?

Answer
Selected
Answer:

Correct
Answer:

"In order to access any portion of an XML document stored

in an XML column, the entire document
must be retrieved"
XML columns are used to store XML documents as a
hierarchical set of entities

Question 56
0 out of 1 points

Which of the following cannot be used to develop DB2 database

applications?
Answer
Selected Answer:

Java
Correct Answer:

XML

Question 57
0 out of 1 points

All of the following are programming languages that can be used to

develop user-defined routines except
Answer
Selected Answer:

C
Correct Answer:

SQL

Question 58
1 out of 1 points

Which of the following describes a Trusted Context?

Answer
Selected
Answer:

Correct
Answer:

Provides ability to switch the current user ID on the

connection to a different user ID
Provides ability to switch the current user ID on the
connection to a different user ID

Question 59
0 out of 1 points

Which of the following is NOT a correct way of using a user-defined

function called CONVERT that converts temperature from C to F?
Answer
Selected
Answer:

Correct
Answer:

delete from weather where tempA =

MYFUNC.CONVERT(tempB)
call MYFUNC.CONVERT(tempA)

Question 60
1 out of 1 points

Which of the following commands allow you to list of existing

databases?
Answer
Selected Answer:

db2 list db directory

Correct Answer:

db2 list db directory

Question 61
1 out of 1 points

"User USER1 is the owner of TABLE1. Assuming user USER1 only holds
privileges for TABLE1,
which of the following is the best way to remove all privileges user
USER1 holds?"
Answer
Selected Answer:

REVOKE CONTROL ON table1 FROM user1;

REVOKE ALL PRIVILEGES ON table1 FROM user1;
Correct Answer:

REVOKE CONTROL ON table1 FROM user1;

REVOKE ALL PRIVILEGES ON table1 FROM user1;

Question 62
1 out of 1 points

Consider the following scenario:

Sunday: full backup
Monday: delta incremental
Tuesday: delta incremental
Wednesday: delta incremental
Thursday: system crashed
Which of the following options contains the correct restore order so

that the database can be restored

to the last stable moment before the crash?
Answer
Selected
Answer:

Correct
Answer:

"Restore the full backup from Sunday, the incremental

delta backup from Monday, the incremental
delta backup from Tuesday, the incremental delta from
Wednesday, then roll forward the database
using the transaction log files."
"Restore the full backup from Sunday, the incremental
delta backup from Monday, the incremental
delta backup from Tuesday, the incremental delta from
Wednesday, then roll forward the database
using the transaction log files."

Question 63
1 out of 1 points

Which of the following packages have the smallest footprint but is still
suitable for executing JDBC applications?
Answer
Selected Answer:

IBM Data Server Driver for JDBC and SQLJ

Correct Answer:

IBM Data Server Driver for JDBC and SQLJ

Question 64
0 out of 1 points

"If circular logging is used, the following types of backup are allowed:"
Answer
Selected Answer:

Online incremental backup

Correct Answer:

Offline full backup

Question 65
1 out of 1 points

On which of the following database objects may the SELECT privilege

be controlled?
Answer
Selected Answer:

View

Correct Answer:

View

Question 66
1 out of 1 points

Which of the following is an incorrect syntax involving the CONNECT

command?
Answer
Selected
Answer:

connect to sample USER db2inst1 PASSWORD

secret123

Correct Answer:

connect to sample USER db2inst1 PASSWORD

secret123

Question 67
0 out of 1 points

Which of the following is NOT related to automatic database backup?

Answer
Selected Answer:

configure automatic maintenance wizard

Correct Answer:

back_zip

Question 68
0 out of 1 points

"Which concurrency issue is demonstrated below Application A

executes a query that reads a set of rows based on some search
criterion. Application B inserts new data that would satisfy application
A's query. Application A executes its query again, within the same unit
of work, and some additional phantom values are returned."
Answer
Selected Answer:

Non-repeatable Read
Correct Answer:

Phantom Read

Question 69
0 out of 1 points

Which of the following is NOT true about views?

Answer
Selected

Answer:

"
When changes are made to data through a view, the data
is changed in underlying table itself"

Correct
Answer:

Cannot be read-only

Question 70
1 out of 1 points

"Assuming the employee table in the employees database is initially

empty. How many rows will
be in the employee table after executing the following commands:
CONNECT TO DB employees
INSERT INTO employee VALUES (100, 'JOHN')
INSERT INTO employee VALUES (200, 'MANDY')
COMMIT
DELETE FROM employee WHERE name='MANDY'
UPDATE employee SET empID=101 where name='JOHN'
COMMIT
ROLLBACK"
Answer
Selected Answer:

1
Correct Answer:

Question 71
0 out of 1 points

Which of the following isolation levels lets you see data that has been
updated by other
Answer
Selected Answer:

Read Stability
Correct Answer:

Repeatable Read

Question 72
0 out of 1 points

Below is a set of commands that configures a table space for

automatic storage management.
Which of the following commands is/are syntactically incorrect?
line 1: CREATE DATABASE mydb AUTOMATIC YES
line 2: CONNECT TO DATABASE mydb

line 3: CREATE TABLESPACE tbsp1 MANAGED BY STORAGE

Answer
Selected Answer:

line 1
Correct Answer:

all lines

Question 73
0 out of 1 points

Which of the following does NOT refer to a column?

Answer
Selected
Answer:

Correct
Answer:

"contains specific information such as name, extension,

and position"
also known as tuple

Question 74
1 out of 1 points

Which of the following is NOT true about transaction?

Answer
Selected Answer:

COMMIT statement is NOT needed in a manual-commit

Correct Answer:

COMMIT statement is NOT needed in a manual-commit

Question 75
1 out of 1 points

Which of the following is NOT a characteristic of a relational model?

Answer
Selected Answer:

focuses on providing better data dependence

Correct Answer:

focuses on providing better data dependence

Question 76
1 out of 1 points

"Given the following table definition:

SALES
--------------------------------------INVOICE_NO CHAR(20) NOT NULL
SALES_DATE DATE

SALES_PERSON VARCHAR(25)
REGION CHAR(20)
SALES_AMT DECIMAL(9,2)
Which of the following queries will return SALES information, sorted by
SALES_PERSON, from A to Z, and SALES_DATE, from earliest to most
recent?"
Answer
Selected
Answer:

Correct
Answer:

"SELECT invoice_no, sales_person, sales_date, sales_amt

FROM sales ORDER BY sales_person DESC, sales_date"
"SELECT invoice_no, sales_person, sales_date, sales_amt
FROM sales ORDER BY sales_person DESC, sales_date"

Question 77
0 out of 1 points

"Given the following table

PURCHASEORDER
-------------------------------------POID STATUS CUSTID
5000 Ok 1111
5001 Pending 2222
5002 Pending 3333
What will be the result of the following query
select XMLELEMENT (NAME ""PurchaseOrder"",
XMLNAMESPACES (DEFAULT 'http://posample.org'),
XMLATTRIBUTE (NAME ""status"", STATUS),
XMLELEMENT (NAME ""poid"", POID),
XMLELEMENT (NAME ""custid"", CUSTID))
from PURCHASEORDER where POID = 5001"
Answer
Selected Answer:

"
pending
5001
2222
"
Correct Answer:

"
5001
2222
"

Question 78
0 out of 1 points

Which of the following is the correct syntax for using the

XMLTRANSFORM SQL/XML function?
Answer
Selected
Answer:

Correct
Answer:

"SELECT FROM XSLTRANSFORM (XMLDOC USING XSLT)

FROM
XMLDATA, XMLTRANS WHERE ID = 1 and XSLID = 2 ;"
"SELECT XSLTRANSFORM (XMLDOC USING XSLT) FROM
XMLDATA, XMLTRANS WHERE ID = 1 and XSLID = 2"

Question 79
1 out of 1 points

Which of the following DOES NOT REFER TO a foreign key?

Answer
Selected Answer:

Is required
Correct Answer:

Is required

Question 80
0 out of 1 points

"Given the options below, which of the following statements can

modify the structure of a table?"
Answer
Selected Answer:

UPDATE
Correct Answer:

ALTER

Question 81
1 out of 1 points

What does the following command do?

db2 get dbm cfg | grep SYSADM_GROUP
Answer
Selected
Answer:

Correct

It displays the Linux group that is considered as a DB2

System Administrator Group

Answer:

It displays the Linux group that is considered as a DB2

System Administrator Group

Question 82
0 out of 1 points

Given the following table definition:

SALES
-------------------------SALES_DATE DATE
SALES_PERSON CHAR(20)
REGION CHAR(20)
SALES INTEGER
Which of the following SQL statements will remove all rows that had a
SALES_DATE in the year 1995?
Answer
Selected
Answer:

DROP FROM sales WHERE YEAR(sales_date) = 1995

Correct Answer:

DELETE FROM sales WHERE YEAR(sales_date) = 1995

Question 83
0 out of 1 points

Which of the following is NOT a benefit of stored procedures?

Answer
Selected Answer:

Reduces network traffic

Correct Answer:

Ensures Consistency of Data

Question 84
0 out of 1 points

Which of the following is a valid wildcard character in a LIKE clause of

a SELECT statement?
Answer
Selected Answer:

/
Correct Answer:

Question 85
0 out of 1 points

Which of the following is NOT true about well-formed XML documents?

Answer
Selected
Answer:

Each element begins with a start tag and ends with an

end tag

Correct Answer:

Attribute values must not be enclosed in double quotes

Question 86
0 out of 1 points

Which of the following will allow user USER1 to change the comment
associated with a table named TABLE1?
Answer
Selected Answer:

GRANT CONTROL ON TABLE table1 TO user1

Correct Answer:

GRANT ALTER ON TABLE table1 TO user1

Question 87
0 out of 1 points

A table named DEPARTMENT has the following columns:

Answer
Selected
Answer:

DEPT_ID
DEPT_NAME
MANAGER
AVG_SALARY
Which of the following is the best way to prevent most
users from viewing AVG_SALARY data?
Correct
Answer:

Encrypt the table's data

Question 88
0 out of 1 points

Which of the following is NOT a database object?

Answer
Selected Answer:

schema
Correct Answer:

row

Question 89

1 out of 1 points

Which of the following commands deletes the database TEST?

Answer
Selected Answer:

drop database TEST

Correct Answer:

drop database TEST

Question 90
0 out of 1 points

Which of the following is true about Dynamic SQL?

Answer
Selected
Answer:

It is precompiled and binded in dynamic databases

Correct Answer:

It is compiled and executed by an application at runtime.

Question 91
0 out of 1 points

"A sequence was created with the DDL statement shown

below:CREATE SEQUENCE my_seq START WITH 10 INCREMENT BY 10
CACHE 10User USER1 successfully executes the following statements
in the order shown:VALUES NEXT VALUE FOR my_seq INTO
:hvar;VALUES NEXT VALUE FOR my_seq INTO :hvar;
User USER2 successfully executes the following statements in the
order shown:
ALTER SEQUENCE my_seq RESTART WITH 10 INCREMENT BY 2 CACHE
5;
VALUES NEXT VALUE FOR my_seq INTO :hvar;
After users USER1 and USER2 are finished, user USER3 executes the
following query:
SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1
What value will be returned by the query?"
Answer
Selected Answer:

5
Correct Answer:

20

Question 92
0 out of 1 points

Which of the following is an example of embedded SQL?

Answer
Selected Answer:

EMBED SQL BEGIN DECLARE SECTION

Correct Answer:

EXEC SQL BEGIN DECLARE SECTION

Question 93
0 out of 1 points

Which of the following is NOT provided by a database?

Answer
Selected
Answer:

Correct
Answer:

"Multiple users with simultaneous ability to insert,

update, and delete data"
Provides data analysis

Question 94
1 out of 1 points

Which two of the following privileges is required in order to use a

package?
Answer
Selected Answers:

CONNECT
EXECUTE
Correct Answers:

CONNECT
EXECUTE

Question 95
0 out of 1 points

Which of the following is not supported by pureXML?

Answer
Selected
Answer:

pureXML supported for UNICODE or non-UNICODE

databases

Correct
Answer:

pureXML compression

Question 96
0 out of 1 points

Which of the following is NOT an accurate statement about views?

Answer
Selected
Answer:

Correct
Answer:

Views can be used to store queries that multiple

applications execute on a regular basis in a database
Views are publicly referenced names and no special
authority or privilege is needed to use them.

Question 97
1 out of 1 points

Which of the following command/syntax changes a database setting?

Answer
Selected Answer:

db2 update db cfg using logprimary 10

Correct Answer:

db2 update db cfg using logprimary 10

Question 98
0 out of 1 points

Which of the following is NOT a characteristic of IBM Data Server

Runtime Client?
Answer
Selected Answer:

It includes runtime libraries

Correct Answer:

It is shipped with GUI tools

Question 99
0 out of 1 points

Which of the following model is generally used as a basis for relational

databases?
Answer
Selected Answer:

Hierarchical Data Model

Correct Answer:

Relational Data Model

Question 100
0 out of 1 points

Which of the following is NOT true about database management

systems (DBMS)?
Answer
Selected Answer:

It provides an interface of access to the databases

Correct Answer:

It provides non-repudiation

Question 101
0 out of 1 points

Which of the following describes the disadvantage of executing a set

of DML statements outside a
transaction?
Answer
Selected
Answer:

Correct
Answer:

The DBMS stores the transaction operations so that the

client applications can rerun the transaction
more easily.
"The DBMS cannot guarantee that all changes performed
by the set of DML are stored, nor that in
case of an error; the changes are undone, leaving the
database in a inconsistent state."

Question 102
0 out of 1 points

Which of the following is the lowest cost DB2 product that can be
legally installed on a Unix server
that has 2 CPUs and has geodetic data management?
Answer
Selected Answer:

DB2 Workgroup Server Edition

Correct Answer:

DB2 Enterprise Server Edition

Question 103
1 out of 1 points

Which of the following is NOT true about schemas?

Answer
Selected
Answer:

Correct
Answer:

"If a schema name is not specified, either by qualifying a

database object name or by executing the
SET CURRENT SCHEMA statement, the currently connected
database is used as the schema name
by default"
"If a schema name is not specified, either by qualifying a
database object name or by executing the
SET CURRENT SCHEMA statement, the currently connected
database is used as the schema name
by default"

Question 104
0 out of 1 points

Which of the following is NOT true about circular logging?

Answer
Selected
Answer:

Correct
Answer:

Secondary log files allocated when next primary log file is

not available due to active transactions
"Only online, incremental backups of the database are
allowed"

Question 105
0 out of 1 points

Which of the following is NOT true about embedded SQL?

Answer
Selected
Answer:

Correct
Answer:

Embedded SQL statements are embedded within a host

language application
Embedded SQL statements are built and executed by an
application at run-time

Question 106
0 out of 1 points

Which of the following is true about relational and hierarchical (XML)

models?
Answer

Selected
Answer:

Correct
Answer:

Relational model does not use NULL for unknown state and
in XML model NULLs are used for unknown values
Relational data is structured and XML data is semistructured

Question 107
0 out of 1 points

Which of the following is NOT a type of node that an XML can have?
Answer
Selected Answer:

element
Correct Answer:

tag

Question 108
0 out of 1 points

"In Java, in order to create and execute a query, what type of object
must be used?"
Answer
Selected Answer:

Connection
Correct Answer:

PreparedStatement

Question 109
0 out of 1 points

Which of the following is NOT an add-on feature/functionality of the

DB2 Enterprise Edition?
Answer
Selected Answer:

geodetic extender
Correct Answer:

column compression

Question 110
1 out of 1 points

Which of the following packages have the smallest footprint but is still
suitable for executing JDBC applications?
Answer

Selected Answer:

IBM Data Server Driver for JDBC and SQLJ

Correct Answer:

IBM Data Server Driver for JDBC and SQLJ

Question 111
0 out of 1 points

A user wishing to invoke an SQL stored procedure that queries a table

must have which of the following privileges?
Answer
Selected
Answer:

Correct
Answer:

CALL privilege on the procedure; REFERENCES privilege

on the table
EXECUTE privilege on the procedure; SELECT privilege on
the table

Question 112
1 out of 1 points

Given the following two tables:

TAB1 TAB2
---------------------- ------------------COL_1 COL_2 COL_A COL_B
----- ----- ----- ----A 10 A 21
B 12 C 23
C 14 D 25
Assuming the following results are desired:
COL_1 COL_2 COL_A COL_B
A 10 A 21
C 14 C 23
- - D 25
Answer
Selected
Answer:

Correct
Answer:

SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON col_1 =

col_a
SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON col_1 =
col_a

Question 113
0 out of 1 points

"Assuming that the PORDER column contains the following XML data:
100-100-01
Sled, Metal
1
100-201-01
Heater, Large
2
What will be the new value of the PORDER column after executing the
following statement?
UPDATE purchaseorder SET porder =
xmlquery('transform
copy $po := $order
modify do delete
$po/PurchaseOrder/item[partid = ''100-201-01'']
return $po'
passing porder as ""order"")
WHERE poid=5012;"
Answer
Selected Answer:

B.

Correct Answer:

"D.
100-100-01
Sled, Metal
1
"

Question 114
0 out of 1 points

Which of the following is NOT true about a buffer pool?

Answer
Selected
Answer:

All table space associates a specific buffer pool of the

same page size

Correct
Answer:

Area of the harddisk used to cache table and index data

Question 115
0 out of 1 points

Which of the following is NOT true about SQL/XML?

Answer
Selected
Answer:

Correct
Answer:

It provides support for using XML in the context of a

relational database system
It is the same as XQuery

Question 116
0 out of 1 points

Which of the following describes authentication?

Answer
Selected Answer:

logging the activities of a user

Correct Answer:

determining that you are who you say you are

Question 117
0 out of 1 points

Which of the following is NOT true about foreign keys?

Answer
Selected
Answer:

Correct
Answer:

A foreign key must match a value on the associated

primary key or be null
A foreign key is required in database tables

Question 118
0 out of 1 points

"Given the following tables:

YEAR_2006
EMPID NAME
--------------------------------1 Jagger, Mick
2 Richards, Keith
3 Wood, Ronnie

4 Watts, Charlie
5 Jones, Darryl
6 Leavell, Chuck
YEAR_1962
EMPID NAME
------------------------------1 Jagger, Mick
2 Richards, Keith
3 Jones, Brian
4 Wyman, Bill
5 Chapman, Tony
6 Stewart, Ian
If the following SQL statement is executed, how many rows will be
returned?
SELECT name FROM year_2006
UNION ALL
SELECT name FROM year_1962"
Answer
Selected Answer:

6
Correct Answer:

12

Question 119
1 out of 1 points

What is the purpose of the TRACKMOD database configuration

parameter?
Answer
Selected
Answer:

Correct
Answer:

When turned on it tells the database to keep track of table

spaces that have been modified
When turned on it tells the database to keep track of table
spaces that have been modified

Question 120
1 out of 1 points

Which of the following is true when compression is applied in

database backup?
Answer
Selected
Answer:

CPU costs typically increase and Media I/O time typically

decrease

Correct
Answer:

CPU costs typically increase and Media I/O time typically

decrease

Question 121
1 out of 1 points

Which of the following allows you to add records in a table?

Answer
Selected Answer:

INSERT
Correct Answer:

INSERT

Question 122
0 out of 1 points

Which of the following are required to use a remote database?

Answer
Selected Answer:

catalog the database only

Correct Answer:

catalog the remote system (node) and database

Question 123
0 out of 1 points

Isolation levels can be specified in all of the following except:

Answer
Selected Answer:

Connection
Correct Answer:

WHERE clause

Question 124
1 out of 1 points

"Given the following table:

CURRENT_EMPLOYEES
----------------------------EMPID INTEGER NOT NULL
NAME CHAR(20)
SALARY DECIMAL(10,2)
PAST_EMPLOYEES
----------------------------EMPID INTEGER NOT NULL

NAME CHAR(20)
SALARY DECIMAL(10,2)
Assuming both tables contain data, which of the following statements
will NOT successfully add data to
table CURRENT_EMPLOYEES?"
Answer
Selected
Answer:

Correct
Answer:

"INSERT INTO current_employees (name, salary) VALUES

(SELECT name,
salary FROM past_employees WHERE empid = 20)"
"INSERT INTO current_employees (name, salary) VALUES
(SELECT name,
salary FROM past_employees WHERE empid = 20)"

Question 125
0 out of 1 points

Which of the following is NOT an XML characteristic?

Answer
Selected Answer:

XML describes itself

Correct Answer:

XML is dependent of the platform or vendor

Question 126
0 out of 1 points

The following scenario describes which concurrency issue?

1) Application A reads a row before processing other requests
2) Application B modifies or deletes the row and commits the change
3) A attempts to read the original row again
4) A sees the modified row or discovers that the original row has been
deleted
Answer
Selected Answer:

Lost Update
Correct Answer:

Non-repeatable Read

Question 127
1 out of 1 points

Which of the following is NOT true about primary keys?

Answer

Selected
Answer:

Correct
Answer:

Relations in a relational model are not required to have a

Primary Key
Relations in a relational model are not required to have a
Primary Key

Question 128
0 out of 1 points

"If the following SQL statements are executed:

CREATE TABLE make (makeid SMALLINT NOT NULL PRIMARY KEY,
make VARCHAR(25));
CREATE TABLE model (modelid SMALLINT,
model VARCHAR(25),
makeid SMALLINT,
CONSTRAINT const1 FOREIGN KEY (makeid)
REFERENCES make(makeid) ON DELETE CASCADE);
And each table created is populated as follows:
MAKE MODEL
MAKEID MAKE MODELID MODEL MAKEID
------ --------- ------- ------- -------1 Ford 1 Mustang 1
2 Chevrolet 2 Escort 1
3 Toyota 3 Malibu 2
4 Camry 3
If the following SQL statement is executed:
DELETE FROM make WHERE makeid = 1
What is the total number of rows that will be deleted?"
Answer
Selected Answer:

1
Correct Answer:

Question 129
0 out of 1 points

"To check the current authentication type in a database server, which

of the following command
should be issued?"
Answer
Selected Answer:

UPDATE DATABASE CONFIGURATION

Correct Answer:

GET DATABASE MANAGER CONFIGURATION

Question 130
0 out of 1 points

Which of the following statements is TRUE about transactions?

Answer
Selected
Answer:

Correct
Answer:

A COMMIT can be executed right after a ROLLBACK

statement in order to revert the effects of the
ROLLBACK.
Transactions guarantee atomicity of a group of operations.