Certified of C2090-558 exam guide materials and item pool for IBM certification for IT examinee, Real Success Guaranteed with Updated C2090-558 pdf dumps vce Materials. 100% PASS Informix 11.70 Fundamentals (C2090-558) exam Today!
♥♥ 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 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
Q12. Given the following: CREATE TABLE customer (customer_num INT, company CHAR(25)); Which of the following SQL statements will return an error?
A. INSERT INTO customer VALUES (453);
B. INSERT INTO customer VALUES (453, '"ABC Company");
C. INSERT INTO customer (company) VALUES ("ABC Company");
D. INSERT INTO customer (customer_num, company) VALUES (453, "ABC Company");
Answer: A
Q13. Business rules require that every time a row in table A is updated in your OLTP database, a row in table B must also be updated. How can you guarantee this rule will be maintained correctly and consistently when there are multiple applications and developers?
A. Use a trigger.
B. Create a foreign key.
C. Use a nightly batch process.
D. Define a task in the sysadmin database.
Answer: A
Q14. Click the Exhibit button.
An administrator created a table using the SQL statement shown in the exhibit to perform a load
operation every day at 11:00 AM. What is the best way to optimize a backup strategy to recover the client table in case of a failure?
A. a level-1 backup at 6:00 AM everyday
B. a level-0 backup soon after the load operation
C. a level-1 backup on Sunday and continuous log backup
D. a level-2 backup at 6:00 AM every day and continuous log backup
Answer: B
Q15. What are the three major steps in implementing Label-Based Access Control (LBAC) in an instance environment? (Choose three.)
A. Define a security policy with access rules.
B. Assign security labels to users and data elements
C. Create security label definitions using set, tree, and/or array components
D. Disable role separation since LBAC supersedes anything role separation might provide and it interferes with LBAC.
E. Create and install either general or user-specific sysdbopen() functions so that LBAC is active when users connect to the instance.
Answer: A,B,C
Q16. What is the only isolation level available on an unlogged database?
A. Dirty Read
B. Cursor Stability
C. Committed Read
D. Repeatable Read
Answer: A
Q17. Which two tasks can be accomplished using the OpenAdmin Tool (OAT)? (Choose two.)
A. Manage Virtual Processors (VP).
B. Automate the update statistics process.
C. Perform installation of an Informix server.
D. Run the High Performance Loader (HPL) GUI tool.
E. Remove an instance's orphaned shared memory segment.
Answer: A,B
Q18. In which way is a Remote Standalone (RS) secondary server different from a High-Availability Data Replication (HDR) secondary server?
A. RS secondary servers do not support DRAUTO.
B. RS secondary servers support replication at the column level
C. You can have more than one RS secondary server in a cluster.
D. RS secondary servers can be directly upgraded to a primary server.
Answer: C
Q19. Which document provides details on preparing an operating system to run Informix?
A. Machine Notes
B. System User's Guide
C. Operating System Guide
D. Informix Migration Guide
Answer: A
Q20. 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