Actual of C2090-558 free practice test materials and guidance for IBM certification for consumer, 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:
Q31. Which statement is used to create a permanent nonlogged table in a logged database?
A. CREATE TABLE tab1 (col1 INTEGER, col2 INTEGER)
B. CREATE RAW TABLE tab1 (col1 INTEGER , col2 INTEGER)
C. CREATE STATIC TABLE tab1 (col1 INTEGER , col2 INTEGER)
D. CREATE NONLOGGING TABLE tab1 (col1 INTEGER , col2 INTEGER)
Answer: B
Q32. Which one of the following is a characteristic of a Decision Support System (DSS) or Data Warehousing environment?
A. frequent writes
B. frequent updates
C. uses query parallelization
D. typically uses memory resident tables
Answer: C
Q33. 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
Updated C2090-558 test preparation:
Q34. You have a database server environment where all databases use buffered logging. In which two conditions are the logical-log buffers in shared memory flushed to the logical log on disk? (Choose two.)
A. When the buffer is full.
B. When a checkpoint occurs.
C. When a user issues a begin work.
D. When a user commits the transaction.
E. When a user rolls back the transaction.
Answer: A,B
Q35. Which statement can be used to roll back SQL statements within a transaction?
A. END WORK
B. COMMIT WORK
C. ROLLBACK WORK
D. ROLLBACK WORK TO SAVEPOINT
Answer: D
Q36. Which two SQL API commands can be used to create a 10 MB dbspace? (Choose two.)
A. task ( )
B. admin ( )
C. oncmd ( )
D. ifxcreate ( )
E. oncreate ( )
Answer: A,B
Realistic C2090-558 secret:
Q37. How can you determine which databases are created in an instance?
A. use dbschema utility
B. inspect ONCONFIG file
C. List reserved pages with oncheck -pr
D. run SELECT name FROM sysmaster:sysdatabases
Answer: D
Q38. Which two column definitions can store whole numbers from -(2^63-1) to (2^63-1)? (Choose two.)
A. INT
B. INT8
C. BIGINT
D. DOUBLE
E. LARGEINT
Answer: B,C
Q39. In which database does Informix store the information when a new task is created in OpenAdmin Tool's Task Scheduler?
A. sysutils
B. sysusers
C. sysadmin
D. sysmaster
Answer: C
Q40. What is the minimum database-level privilage required for a user to create Stored Procedure Language routines?
A. DBA
B. Execute
C. Connect
D. Resource
Answer: D