Actual of C2090-558 free question materials and braindumps for IBM certification for customers, 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:
Q21. 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
Q22. When storing string "ABCD" in a column, which of the following data types will result in a string stored with 2 padded spaces?
A. VARCHAR (6)
B. VARCHAR (4,2)
C. VARCHAR (8,6)
D. VARCHAR (6,8)
Answer: C
Q23. Which command could be used to display the definition of user-defined and complex data types?
A. onstat -g smb
B. oncheck -cc database_name
C. oncheck -pB database_name
D. dbschema -u all -d database_name
Answer: D
Up to the minute C2090-558 test question:
Q24. Which keyword is used to determine whether a comparison is true for every value returned from a subquery?
A. ALL
B. ANY
C. EACH
D. EVERY
Answer: A
Q25. Which statement is true when using onload/onunload?
A. The output will be in text format.
B. The source and target operating system can be different.
C. The target schema can be modified with additional columns.
D. The source and target database Informix versions must be identical.
Answer: D
Q26. Which command would you execute to restore to a specific moment-in-time?
A. onbar -t timestamp
B. onbar -r -log lognum
C. onbar -r -t timestamp
D. onbar -r -l timestamp
Answer: C
Actual C2090-558 pdf:
Q27. Which of the following environment variables allow an application to specify formatting of locale- sensitive data such as of date and currency values?
A. DB_LOCALE
B. GLS_LOCALE
C. CLIENT_LOCALE
D. SERVER_LOCALE
Answer: C
Q28. What functionality is exclusive to onbar (i.e. not present in ontape)?
A. Restore of a single dbspace
B. Level 1 archive of the instance
C. Parallel restore of the instance
D. Change logging modes of a database
Answer: C
Q29. 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
Q30. Which of the following is required for a cold restore?
A. A restore that includes the rootdbs
B. A restore that includes temp dbspaces
C. A restore that includes only non-critical dbspaces.
D. A restore that includes multiple level to be restored.
Answer: A