Virtual of C2090-558 exam question materials and paper for IBM certification for IT specialist, Real Success Guaranteed with Updated C2090-558 pdf dumps vce Materials. 100% PASS Informix 11.70 Fundamentals (C2090-558) exam Today!
2021 May C2090-558 Study Guide Questions:
Q51. When installing Informix, which two installation methods can be used? (Choose two.)
A. quiet
B. native
C. staged
D. console
E. graphical
Answer: D,E
Q52. Which two storage objects exist in Informix? (Choose two.)
A. dbspace
B. flash space
C. smart rowspace
D. smart blobspace
E. encrypted space
Answer: A,D
Q53. Which two SQL commands can be used to invoke a stored procedure? (Choose two.)
A. RUN function
B. CALL function
C. CALL procedure
D. EXECUTE function
E. EXECUTE procedure
Answer: D,E
Up to the minute C2090-558 real exam:
Q54. Which two statements are true about the COMMIT WORK statement? (Choose two.)
A. The keyword WORK is optional.
B. A single COMMIT WORK can end several BEGIN WORK statements.
C. The COMMIT WORK statement releases all row locks but not table locks.
D. All of the successful modifications that the transaction makes are saved to disk when you issue a COMMIT WORK statement.
E. A new transaction automatically starts after each COMMIT WORK or ROLLBACK WORK statement in a nonlogged database.
Answer: A,D
Q55. Which two statements will update all rows in the customer table? (Choose two.)
A. update customer set fname = "xyz";
B. modify customer set fname = "xyz";
C. modify customer
set fname = "xyz" where 1 = 1;
D. update customer
set fname = "xyz" where 1 = 1;
E. update customer
set fname = "xyz" for all;
Answer: A,D
Q56. 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
Tested C2090-558 paper:
Q57. Which configuration parameters are used by ontape logical log backup?
A. LOGFILES, LOGSIZE, TAPEDEV
B. LTAPEBLK, TAPEDEV, TAPESIZE
C. LTAPESIZE, LTAPEDEV, LTAPEBLK
D. TAPEDEV, BAR_ACT_LOG, BACKUP_FILTER
Answer: C
Q58. Which two of the following are required for creating a dbspace? (Choose two.)
A. a mirror chunk
B. two or more chunks
C. a cooked file or raw device
D. a file owned by root or administrator
E. dbspace name containing only letters, digits, underscores, or $ characters.
Answer: C,E
Q59. Which of the following is true about the remote query SELECT * FROM ABC@LMN:XYZ?
A. SELECT from table ABC at database LMN on server XYZ
B. SELECT from table ABC at server LMN on database XYZ
C. SELECT from table LMN on database ABC on server XYZ
D. SELECT from table XYZ on database ABC at server LMN
Answer: D
Q60. Which of the following statement is true of System Monitoring Interface (SMI) tables?
A. SMI tables store database structures.
B. Contains tasks used by the database scheduler
C. SMI tables are also known as System Catalog tables
D. Contains tables that the database server maintains automatically
Answer: D