[Free] 2017(Nov) EnsurePass Testinsides IBM C2090-558 Dumps with VCE and PDF 51-60

EnsurePass
2017 Nov IBM Official New Released C2090-558
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-558.html

Informix 11.70 Fundamentals

Question No: 51 – (Topic 1)

You want to use sqlhosts file /newlocation/newsqlhosts. Which of the following is true?

  1. sqlhosts file must be called sqlhosts

  2. set INFORMIXSQLHOSTS variable to /newlocation/sqlhosts

  3. set INFORMIXSQLHOSTS variable to /newlocation/newsqlhosts

  4. sqlhosts file must be defined under $INFORMIXDIR/etc/ directory

Answer: C

Question No: 52 – (Topic 1)

User A creates a User Defined Routine (UDR). Which privilege must be granted to other users before they can run user A#39;s UDR?

  1. DBA on the database

  2. EXECUTE on the procedure

  3. RESOURCE on the database

  4. SELECT on the tables used in the procedure

Answer: B

Question No: 53 – (Topic 1)

Click the Exhibit button.

Ensurepass 2017 PDF and VCE

The tables shown in the exhibit have been created for a class enrollment system where a course can be assigned to many classes. The class table joins to the course table on the course_num columns. Which two of the following SQL statements are required to establish a referential integrity relationship between these tables? (Choose two.)

  1. ALTER TABLE class ADD CONSTRAINT (PRIMARY KEY (class_id));

  2. ALTER TABLE class ADD CONSTRAINT (PRIMARY KEY (course_num));

  3. ALTER TABLE course ADD CONSTRAINT (PRIMARY KEY (course_num));

  4. ALTER TABLE class ADD CONSTRAINT (FOREIGN KEY (course_num) REFERENCES course);

  5. ALTER TABLE course ADD CONSTRAINT (FOREIGN KEY (course_num) REFERENCES class);

Answer: C,D

Question No: 54 – (Topic 1)

What Informix data type is suitable for storing video clips up to a size of 4 TB?

  1. BLOB

  2. BYTE

  3. CLOB

  4. COLLECTION

Answer: A

Question No: 55 – (Topic 1)

Which command could be used to display the definition of user-defined and complex data types?

  1. onstat -g smb

  2. oncheck -cc database_name

  3. oncheck -pB database_name

  4. dbschema -u all -d database_name

Answer: D

Question No: 56 – (Topic 1)

In which database does Informix store the information when a new task is created in OpenAdmin Tool#39;s Task Scheduler?

  1. sysutils

  2. sysusers

  3. sysadmin

  4. sysmaster

Answer: C

Question No: 57 – (Topic 1)

Which statement will change the column address1 to a null value?

  1. UPDATE customer

    SET address1 = null WHERE customer_num = 134;

  2. UPDATE customer SET address1 = #39; #39;,

    SET address2 = null WHERE customer_num = 134;

  3. UPDATE customer SET address1 = quot;quot;

    WHERE customer_num = 134;

  4. UPDATE customer SET address1 = #39;#39;,

SET address2 = null WHERE customer_num = 134;

Answer: A

Question No: 58 – (Topic 1)

Which of the following privileges can NOT be granted to a role?

  1. Type-Level

  2. Table-Level

  3. Routine-Level

  4. Database-Level

Answer: D

Question No: 59 – (Topic 1)

Which of the following statements can be used to prevent duplicate values in an indexed column?

  1. CREATE HASH INDEX

  2. CREATE UNIQUE INDEX

  3. CREATE DISTINCT TYPE

  4. CREATE CLUSTER INDEX

Answer: B

Question No: 60 – (Topic 1)

Under which of the following conditions does the LAST COMMITTED option have an effect on the COMMITTED READ isolation level?

  1. Row level lock

  2. Page level locking

  3. RAW or unlogged tables

  4. Tables containing complex data types

Answer: A

Topic 2, Volume B

100% Free Download!
Download Free Demo:C2090-558 Demo PDF
100% Pass Guaranteed!
Download 2017 EnsurePass C2090-558 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

Leave a Reply