DB2 UDB V7.1 Family Fundamentals Exam 513 question bank:
1. Given the following DB2DIAG.LOG entry:
"Crash
Recovery is needed."
Which of the following
is the most likely cause for this entry?
A. A
LOAD failed
B. A
restore failed
C. A
hardware problem
D. A roll forward is
required
Ans: Option c
2. Which of the following is required to IMPORT data into a table?
A.
SYSCTRL authority
B.
LOAD authority on the table
C.
ALTER privilege on the table
D.
IMPORT authority on the table
E. INSERT privilege on
the table
Ans: Option E
3. Which of the
following authorizations is NOT sufficient to back up a database?
A.
DBADM
B.
SYSADM
C.
SYSCTRL
D. SYSMAINT
Ans: Option A
4. Which of the following is required for
a database restore?
A.
Exclusive use of the database
B.
Exclusive use of the instance
C.
Exclusive use of the table being restored
D. Exclusive use of the
table space being restored
Ans: Option A
5. Which
of the following buffer pools is the catalog table space associated?
A.
IBMBPPATH1
B.
IBMCATALOGBP
C.
IBMDEFAULTBP
D.
IBMTEMPSPCBP
E. IBMUSERSPCBP
Ans: Option C
6. Which
of the following options will defer when DB2 must allocate additional pages to
an index in order to store inserted data?
A.
CLUSTER
B.
PCTFREE
C.
MINPCTUSED
D.
SPACIFICATION ONLY
Ans: Option B
7. Which
of the following CANNOT help to uniquely identify rows?
A.
Using an Identify column
B.
Creating a foreign key on the table
C.
Defining primary key columns as not null
D.
Creating a trigger to auto increment the primary key value for insert
statements
Ans: Option B
8. Which of the following is the default
output location for DB2 scripts created in the DB2
Script
Center and successfully executed in the DB2 Script Center?
A. DB2
Journal
B.
System console
C.
DB2 Command Window
D.
User specified file
E.
DB2 Command Line Processor
Ans: Option A
9. Which two of the following methods
sets up connectivity from a client to a remote server using TCPIP as the
protocol?
A.
ADD database in the Control Center
B.
Add instance in the Control Center
C.
Using the Client Configuration Assistant
D.
ATTACH to the remote system and catalog the database
E.
IMPORT access information into the database directories
Ans: Option D
10. Given
an application with the embedded static SQL statement.
INSERT
INTO admin.payroll (employee, salary) VALUES ("Tess King", 30000)
Which
of the following privileges must be held on table admin.payroll to successfully
bind the application?
A.
ALTER
B.
INSERT
C.
UPDATE
D.
BINDADD
E.
EXECUTE
Ans: Option B
11. Which
of the following actions will occur when issuing the command FORCE
APPLICATION
ALL?
A.
No new database connections are allowed
B.
Uncommitted units of work are committed
C.
Uncommitted units of work are rolled back
D.
Disconnect warning messages are sent to connected users
Ans: Option C
12. Which
two of the following authorities can issue a FORCE command?
A.
DBADM
B.
SYSADM
C.
SYSCTRL
D.
SYSUSER
E.
SYSMAINT
Ans: Option B, C
13. Which
of the following utilities allows for the creation of alternative catalog
tables that are
optimized
for ODBC?
A.
db2opt
B.
db2ocat
C.
db2odbc
D.
db2catlg
Ans: Option B
14. Which
of these methods will NOT enforce uniqueness of rows already in the table:
A.
Creating a primary key on the table.
B.
Defining a unique index on the table.
C.
Altering the table to add a unique constraint.
D.
Altering an existing column to add a unique constraint.
Ans: Option d
15. Which
of the following will NOT allow for loading data into a table?
A.
DBADM authority
B.
SYSADM authority
C.
UPDATE privilege
D.
LOAD authority with the INSERT and DELETE privileges
Ans: Option C
16. Which
of the following must occur in order to separate index data from table user
data?
A.
Use DMS table spaces
B.
Use SMS table spaces
C.
Create table space containers on different devices
D.
Ensure table space definition has multiple containers
Ans: Option A
17. Which
of the following is TRUE about the IMPORT utility?
A.
Views can be created
B.
Summary tables can be targets
C.
Data link columns can be imported
D.
System catalog tables can be targets
Ans: Option C
18. Given
the command:
BACKUP
DATABASE sample to path/dir
Which
of the following parameters determines how much memory will be used to backup
the
database sample?
A.
logbufsz
B.
backbufsz
C.
extentsize
D.
prefetchsize
Ans: Option B
19. Given
the following statement:
SELECT
id, deptname, manager
FROM
staff, org
WHERE
dept=deptnumb
ORDER
BY deptname
How
many sort operations occurred based on the Visual Explain output?
A. 0
B. 1
C. 2
D. 3
Ans: Option D
20. Which
of the following are functional groups (switches) that can be collected with
snapshot
monitoring?
A.
BUFFERPOOL, SORT, TABLESPACE, UOW
B.
BUFFERPOOL, SORT, DEADLOCKS, STATEMENTS
C.
BUFFERPOOL, SORT, STATEMENTS, TABLE, UOW
D.
BUFFERPOOL, SORT, CONNECTIONS, DEADLOCKS
E.
BUFFERPOOL, SORT, CONNECTIONS, TABLESPACE
Ans: Option A
21. Which
of the following is shown by the Messages Page on the Journal?
A.
All messages in the DB2 Diagnostic log
B.
All messages issued by the DB2 Governor
C.
All messages issued by the DB2 Audit Facility
D.
All messages issued through the DB2 administration tools
Ans: Option D
22. Nodes
that are down or in an unknown state are reported in the Alert Center as which
of
the
following?
A.
Alarms
B.
Alerts
C.
Warnings
D.
Informational Messages
Ans: Option A
23. Which
of the following allows containers to be added to an SMS tablespace?
A.
BACKUP DATABASE command
B.
ALTER TABLESPACE command
C.
RESTORE DATABASE command
D.
ALTER SMS TABLESPACE command
Ans: Option C
24. Which
of the following objects CANNOT be altered?
A.
index
B.
table
C.
nickname
D.
bufferpool
E.
table space
Ans: Option A
25. Which
of the following is required for the use of TCP/IP between a client and server?
A. A
named pipe is established between client and server.
B.
Both the client and server are on Unix operating systems.
C.
The registry variable DB2COMM includes TCPIP at the server.
D.
The registry variable DB2COMM includes TCPIP at the client.
Ans: Option C
26. Which
of the following DB2 commands updates information used by the optimizer when
choosing
an access path?
A.
REORG
B.
IMPORT
C.
REBIND
D.
RUNSTATS
Ans: Option D
27. A
DB2 server with DB2 Connect installed needs to have the userids and passwords
for the
DB2
clients going to D132 for OS/390 validated at the DB2 for OS/390 host. Which of
the
following
authentication levels provides this requirement while providing authentication
for
other
DB2 clients at the DB2 server?
A.
DCS
B.
DRDA
C.
HOST
D.
CLIENT
E.
SERVER
Ans: Option A
28. Which
of the following allows user "manager" (who is a regular user) to
control access to
schema
"city"?
A.
CREATE SCHEMA city GRANT TO manager
B.
CREATE SCHEMA city RESTRICT manager
C.
CREATE SCHEMA city AUTHORIZATION manager
D.
CREATE SCHEMA city, when logged on as user "manager"
Ans: Option C
29. Given
the following SQL statements:
1)
CONNECT TO mydb
2)
CONNECT RESET
3)
CREATE TABLESPACE ts8 PAGESIZE 8K MANAGED BY SYSTEM USING
('D:\file1')
BUFFERPOOL bp8
4)
CREATE BUFFERPOOL bp8 SIZE 1000 PAGESIZE 8K
5)
CREATE TABLE mytab (col1 CHAR(64)) IN ts8
In
order for the table to be created with an 8K page size, which of the following
indicates
the
order that the above statements must be executed?
A.
1,3,4,5,2
B.
1,4,3,5,2
C.
1,3,2,1,4,5
D.
1,4,2,1,3,5
Ans:
Option D
30. Which
of the following tasks is performed by the DB2 Query Patroller Tracker Utility?
A.
Accepts, analyzes, prioritizes, and schedules database requests and optionally
notifies
users
when their requests have been processed.
B.
Enables the user to monitor query status, view job details, cancel jobs, submit
new jobs,
drop
result tables, and resubmit completed jobs.
C.
Allows you to determine which tables and columns have been accessed most
frequently,
which
tables have returned the most result rows, and which jobs have been completed
within
a specific time period.
D.
Enables the system administrator to manage the DB2 Query Patroller system
parameters,
create
or delete profiles for DB2 Query Patroller users, manage nodes, result
destinations,
data
sources and job queues.
Ans: Option C
No comments:
Post a Comment