Pinpoint of C2090-558 free exam questions materials and lab 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
Q61. Under which of the following conditions does the LAST COMMITTED option have an effect on the COMMITTED READ isolation level?
A. Row level lock
B. Page level locking
C. RAW or unlogged tables
D. Tables containing complex data types
Answer: A
Q62. Which of the following privileges can NOT be granted to a role?
A. Type-Level
B. Table-Level
C. Routine-Level
D. Database-Level
Answer: D
Q63. 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
Q64. hat are two ways to create table t1 with row level locking? (Choose two.)
A. Execute the command "create table t1 (c1 int) locking row".
B. Execute the command "create table t1 (c1 int) lock level row".
C. Execute the command "create table t1 (c1 int) lock mode row".
D. Set DEF_TABLE_LOCKMODE to ROW in ONCONFIG before executing "create table t1(c1 int)".
E. Set the environment variable DEF_TABLE_LOCKMODE to ROW before executing "create table t1(c1 int)".
Answer: C,D
Q65. Which database contains the system-monitoring interface (SMI) tables which provide information about the state of the database server?
A. sysutils
B. sysstate
C. sysmaster
D. sysmonitor
Answer: C
Q66. 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
Q67. Which Informix utility listed below will allow an administrator to run ad hoc SQL against the instance?
A. onsql
B. onadmin
C. dbaccess
D. dbschema
Answer: C
Q68. 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
Q69. Which utility would you use to print out the physical layout of the instance?
A. onstat
B. onmode
C. onspaces
D. dbschema
Answer: D
Q70. What is the default isolation level on a mode ANSI database?
A. Dirty Read
B. Cursor Stability
C. Committed Read
D. Repeatable Read
Answer: D