UDB V7.1 Family Fundamenta
Questions, Answers, Braindumps (000-512)
to all, Thanks to www.examcheets.com for helping me
in such a manner. I purchased their study material
and got through the exam.
The user USER1 is executing the statement
CREATE TABLE app1.table1 (col1 INT, col2 INT)
Which of the following privileges is required by USER1
for the statement to be successful?
A. CREATEIN for the database
B. CREATEIN for the schema app1
C. CREATEIN for the schema user1
D. CREATEIN for the table table1
When granted to user1, which of the following will
allow user1 to ONLY access table data?
A. DBADM authority
B. SYSADM authority
C. SELECT privilege on the table
D. SELECT privilege WITH GRANT OPTION on the table
A user creates the table TABLE1. Which of the following
statements would explicitly give USER1 the ability
to read rows from the table?
A. GRANT VIEW TO user1 ON TABLE table1
B. GRANT READ TO user1 ON TABLE table1
C. GRANT SELECT ON TABLE table1 TO user1
D. GRANT ACCESS ON TABLE table1 TO user1
The DB2 Administration Server (DAS) is required for
which of the following?
A. For the administrator user id to install or remove
B. For the remote clients to use the Control Center
against the instance
C. For checking authorities in the database manager
configuration for SYSADM
D. For maintaining authorities added and removed by
the SQL GRANT and REVOKE commands respectively
Which of the following authorities should be given
to the DB2 Administration Server (DAS) Instance owner
at the administered instance?
Which of the following CANNOT be used to restrict
specific values from being inserted into a column
in a particular table?
C. check constraint
D. referential constraint
Which of the following describes when indexes can
be explicitly referenced by name within an SQL statement?
A. When dropping the index
B. When updating the index
C. When selecting on the index
D. When inserting using the index
Given the statement:
CREATE TABLE t1
c1INTEGER NOT NULL,
FOREIGN KEY(c2) REFERENCES t2
How many non-unique indexes are defined for table
Which of the following Control Center options shows
the dependencies between a specific view and its tables?
A. Show SQL
B. Show Related
C. Sample Contents
D. Customized Columns
Which of the following Control Center features can
be used to update information for the optimizer to
choose the best path to data?
A. Show Related
B. Generate DDL
C. Run Statistics
D. Reorganize Table