Printable of C2090-558 sample question materials and torrent 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 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
Q51. Which command would you execute to restore an instance without using or restoring the logical logs?
A. onbar -w
B. onbar -e
C. onbar -r -p
D. onbar -r -nolog
Answer: C
Q52. A progammer wants to unload a table to a file inside a stored procedure. What functionality listed below will help the programmer accomplish the task?
A. dbload
B. dbexport
C. external table
D. SQL unload statement
Answer: C
Q53. Which statement will change the column address1 to a null value?
A. UPDATE customer
SET address1 = null WHERE customer_num = 134;
B. UPDATE customer
SET address1 = ' ',
SET address2 = null WHERE customer_num = 134;
C. UPDATE customer
SET address1 = ""
WHERE customer_num = 134;
D. UPDATE customer
SET address1 = '',
SET address2 = null WHERE customer_num = 134;
Answer: A
Q54. What is the lowest level of granularity supported by Enterprise Replication?
A. column
B. instance
C. database
D. fragment
Answer: A
Q55. 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
Q56. What is the purpose of DB_LOCALE?
A. It enables operating system independent data storage.
B. It enables Informix client connectivity by specifying where the instance is located.
C. It defines conventions for a particular language, collation, or code set within a database.
D. It defines conventions for a particular language, collation, or code set for a client application.
Answer: C
Q57. Which of the following modes is NOT supported by Informix?
A. On-Line
B. Quiescent
C. Replication
D. Administration
Answer: C
Q58. Which configuration parameter allows you to reduce the dependency on local OS user accounts and to enable a DBSA to grant database server access to specific users without the OS user accounts?
A. USERMAPPING
B. IFX_EXTEND_ROLE
C. SECURITY_LOCALCONNECTION
D. ADMIN_USER_MODE_WITH_DBSA
Answer: A
Q59. Which of the following statements can be used to prevent duplicate values in an indexed column?
A. CREATE HASH INDEX
B. CREATE UNIQUE INDEX
C. CREATE DISTINCT TYPE
D. CREATE CLUSTER INDEX
Answer: B
Q60. User A creates a User Defined Routine (UDR). Which privilege must be granted to other users before they can run user A's UDR?
A. DBA on the database
B. EXECUTE on the procedure
C. RESOURCE on the database
D. SELECT on the tables used in the procedure
Answer: B