Ensurepass.com : Ensure you pass the IT Exams
2017 Nov IBM Official New Released C2090-730
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-730.html

DB2 9 Family Fundamentals

Question No: 181

Given the following information:

Protocol: TCP/IP Port Number: 5000

Host Name: DB_SERVER Database Name: TEST_DB Database Server Platform: Linux

Which of the following will allow a client to access the database stored on the server?

  1. CATALOG DATABASE test_db AS test_db REMOTE TCPIP SERVER db_server PORT 5000 OSTYPE LINUX;

  2. CATALOG TCPIP NODE 5000 REMOTE SERVERdb_server OSTYPE LINUX; CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER;

  3. CATALOG TCPIP NODE db_server REMOTE db_server SERVER 5000 OSTYPE LINUX;

    CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER;

  4. CATALOG TCPIP NODE db_server REMOTE db_server PORT 5000 OSTYPE LINUX; CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER;

Answer: C

Question No: 182

Which of the following is used to create and debug user-defined functions?

  1. SQL Assist

  2. Control Center

  3. Command Editor

  4. Developer Workbench

Answer: D

Question No: 183

Which of the following is true about XML columns?

  1. XML columns are used to store XML documents as ahierarchical set of entities

  2. Only XQuery can be used to retrieve an XML document from an XML column

  3. XML columns must be altered to accommodate additional parent/child relationships if they are used in referential constraints

  4. In order to access anyportion of an XML document stored in an XML column, the entire document must be retrieved

Answer: A

Question No: 184

Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server?

  1. DB2 Express Edition

  2. DB2 Personal Edition

  3. DB2 Workgroup Server Edition

  4. DB2 Enterprise Server Edition

Answer: C

Question No: 185

Given the following table: TAB1

COL1 COL2

— — A 10

B 20

C 30

A 10

D 40

C 30

Assuming the following results aredesired: TAB1

COL1 COL2

— — A 10

B 20

C 30

D 40

Which of the following statements will produce the desired results?

  1. SELECT UNIQUE * FROM tab1

  2. SELECT DISTINCT * FROM tab1

  3. SELECTUNIQUE(*) FROM tab1

  4. SELECT DISTINCT(*) FROM tab1

Answer: B

Question No: 186

User USER1 has the privileges neededto invoke a stored procedure named GEN_RESUME. User USER2 needs to be able to call the procedure – user USER1 and all members of the group PUBLIC should no longer be allowed to call the procedure. Which of the following statement(s) can be used to accomplish this?

  1. GRANT EXECUTE ON ROUTINE gen_resume TO user2 EXCLUDE user1, PUBLIC

  2. GRANT EXECUTE ON PROCEDURE gen_resume TO user2;

    REVOKE EXECUTE ON PROCEDURE gen_resume FROM user1, PUBLIC;

  3. GRANT CALL ON ROUTINE gen_resume TO user2 EXCLUDE user1 PUBLIC

  4. GRANT CALL ON PROCEDURE gen_resume TO user2;

REVOKE CALL ON PROCEDURE gen_resume FROM user1, PUBLIC;

Answer: B

Question No: 187

Which of the following tools can be used to catalog a database?

  1. Visual Explain

  2. Alert Center

  3. Journal

  4. Configuration Assistant

Answer: A

Question No: 188

If the following statement isexecuted:

CREATE TABLE tab1 (col1 INTEGER NOT NULL, col2 INTEGER,

CONSTRAINT const1 FOREIGN KEY (col2) REFERENCES tab1(col1));

How many unique indexes are defined for table TAB1?

  1. 0

  2. 1

  3. 2

  4. 3

Answer: A Explanation:

250

When does a view get populated?

  1. When it is created

  2. When it is referenced in an INSERT statement

  3. The first time any executable SQL statement references it

  4. Any time an executable SQL statement references it

Answer:D

Question No: 189

Which of the following statements allows BOB to revoke access to theSAMPLE database from user TOM?

  1. REVOKE ACCESS ON DATABASE FROM USER bob

  2. REVOKE CONNECT ON DATABASE FROM USER tom

  3. REVOKE tom FROM ACCESS ON DATABASE BY USER bob

  4. REVOKE tom FROM CONNECT ON DATABASE BY USER bob

Answer: B

Question No: 190

Which of the following is NOT a characteristic of a unique index?

  1. Each column in a base table can only participate in one unique index, regardless of how the columns are grouped (the same column cannot beused in multiple unique indexes)

  2. In order for an index to be used to support a unique constraint, it must have been defined with the UNIQUE attribute

  3. A unique index cannot be created for a populated table if the key column specified contains more than one NULL value

  4. A unique index can only be created for a non-nullable column

Answer: D

100% Ensurepass Free Download!
Download Free Demo:C2090-730 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass C2090-730 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE