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

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: 41 – (Topic 1)

Which of these commands will create a table containing a column that will be automatically populated with a numeric value starting from an initial value of 2301 and incremented as rows are inserted?

  1. CREATE TABLE customer (cust_num SERIAL(2301), ?;

  2. CREATE TABLE customer (cust_num SERIAL INIT 2301,?;

  3. CREATE TABLE customer (cust_num INT SET SERIAL 2301,?;

  4. CREATE TABLE customer (cust_num SERIAL,? SET SERIAL 2301;

Answer: A

Question No: 42 – (Topic 1)

What are two ways to create table t1 with row level locking? (Choose two.)

  1. Execute the command quot;create table t1 (c1 int) locking rowquot;.

  2. Execute the command quot;create table t1 (c1 int) lock level rowquot;.

  3. Execute the command quot;create table t1 (c1 int) lock mode rowquot;.

  4. Set DEF_TABLE_LOCKMODE to ROW in ONCONFIG before executing quot;create table t1(c1 int)quot;.

  5. Set the environment variable DEF_TABLE_LOCKMODE to ROW before executing quot;create table t1(c1 int)quot;.

Answer: C,D

Question No: 43 – (Topic 1)

Which utility can be used to relocate the physical log to a new dbspace?

  1. onlog

  2. ontape

  3. onspaces

  4. onparams

Answer: D

Question No: 44 – (Topic 1)

Which of the following methods will allow you to determine how much space is currently in use?

  1. Query the $ table

  2. Query the sysstats database

  3. Query the sysusers database

  4. Query the sysmaster database

Answer: D

Question No: 45 – (Topic 1)

In which two places may a function be used in a SELECT statement? (Choose two.)

  1. in a subquery

  2. in a HAVING clause

  3. in a GROUP BY clause

  4. in the ORDER BY clause

  5. in the select (or projection) list

Answer: A,E

Question No: 46 – (Topic 1)

Which table type is always nonlogging?

  1. RAW

  2. TEMP

  3. STATIC

  4. STANDARD

Answer: A

Question No: 47 – (Topic 1)

Which one of the following is most suitable for scheduling the periodic collection of data about an instance?

  1. Sensor

  2. Trigger

  3. Stored Procedure

  4. User Defined Routine

Answer: A

Question No: 48 – (Topic 1)

Which of the following is true about star schemas?

  1. A star schema is optimal for OLTP systems.

  2. A star schema is also known as a 3rd Normal Form schema.

  3. A star schema is associated with master-detail relationships between tables.

  4. A star schema is not necessarily a snowflake schema, but a snowflake schema is always a star schema.

Answer: D

Question No: 49 – (Topic 1)

Which one of the following will generate a typical Decision Support System (DSS) type of workload?

  1. Ordering a book from an online retailer

  2. Inquiring usage data for a particular mobile phone user

  3. Bank operation involving transfer of money between two accounts

  4. Generating of a report by a large global retail company to find top selling items by country

Answer: D

Question No: 50 – (Topic 1)

A progammer wants to unload a table to a file inside a stored procedure. What functionality listed below will help the programmer accomplish the task?

  1. dbload

  2. dbexport

  3. external table

  4. SQL unload statement

Answer: C

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