Master the C2090-558 Informix 11.70 Fundamentals (C2090-558) content and be ready for exam day success quickly with this Examcollection C2090-558 download. We guarantee it!We make it a reality and give you real C2090-558 questions in our IBM C2090-558 braindumps.Latest 100% VALID IBM C2090-558 Exam Questions Dumps at below page. You can use our IBM C2090-558 braindumps and pass your exam.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-558 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-558 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-558-exam-dumps.html
Q11. Which two installation modes are available for Informix? (Choose two.)
A. Full
B. Typical
C. Custom
D. Compact
E. Complete
Answer: B,C
Q12. Enterprise Replication (ER) requires which data object to exist in all tables participating in replication?
A. a primary key
B. a unique index
C. a virtual column
D. a unique constraint
Answer: A
Q13. 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?
A. CREATE TABLE customer (cust_num SERIAL(2301), ?;
B. CREATE TABLE customer (cust_num SERIAL INIT 2301,?;
C. CREATE TABLE customer (cust_num INT SET SERIAL 2301,?;
D. CREATE TABLE customer (cust_num SERIAL,? SET SERIAL 2301;
Answer: A
Q14. Assuming the tables and columns mentioned below exist, which of the following SQL statements will return an error?
A. INSERT INTO orders
SELECT * FROM new_orders;
B. SELECT company, fname, lname, state FROM customer
WHERE state = (SELECT state, zipcode FROM customer WHERE fname = "John");
C. DELETE FROM stock
WHERE 0 = (SELECT count(*) FROM manufact WHERE manufact.manu_code =
stock.manu_code)
D. UPDATE customer SET (address, city, state, zip) =
(SELECT address, city, state, zip
FROM newaddr
WHERE newaddr.customer_num = customer.customer_num)
WHERE customer_num IN (SELECT customer_num FROM newaddr);
Answer: B
Q15. Which one of the following will generate a typical Decision Support System (DSS) type of workload?
A. Ordering a book from an online retailer
B. Inquiring usage data for a particular mobile phone user
C. Bank operation involving transfer of money between two accounts
D. Generating of a report by a large global retail company to find top selling items by country
Answer: D
Q16. Which of the following methods can be used to tranfer data in EXPRESS mode?
A. dbload
B. external tables
C. onload/onunload
D. dbexport/dbimport
Answer: B
Q17. You are about to create and load a table that will initially have a size of 50,000 KB. Once the table has been loaded, there will be very few additional inserts or updates to the table. When you create the table, which of the following extent size definitions would make the most effective use of disk space over time?
A. EXTENT SIZE 75000 NEXT SIZE 0
B. EXTENT SIZE 1000 NEXT SIZE 50000
C. EXTENT SIZE 50000 NEXT SIZE 1000
D. EXTENT SIZE 50000 NEXT SIZE 50000
Answer: C
Q18. Which utility can be used to relocate the physical log to a new dbspace?
A. onlog
B. ontape
C. onspaces
D. onparams
Answer: D
Q19. You received an error, "Chunk is not empty", while trying to remove a chunk. How do you verify which objects still occupy space in the chunk?
A. onspaces
B. onmonitor
C. oncheck -pe
D. SELECT * from SYSTABLES
Answer: C
Q20. Which two database objects can be created using fragmentation? (Choose two.)
A. view
B. table
C. index
D. trigger
E. synonym
Answer: B,C