C2090-558 Free Practice Test

What functionality is exclusive to ontape (i.e. not present in onbar)?

1. A. Level 1 Backup of instance
2. B. Rename spaces during a restore
3. C. Applying a filter to the backup data
4. D. Back up the instance to standard out

Correct Answer: D

What are the three major steps in implementing Label-Based Access Control (LBAC) in an instance environment? (Choose three.)

1. A. Define a security policy with access rules.
2. B. Assign security labels to users and data elements
3. C. Create security label definitions using set, tree, and/or array components
4. D. Disable role separation since LBAC supersedes anything role separation might provide and it interferes with LBAC.
5. E. Create and install either general or user-specific sysdbopen() functions so that LBAC is active when users connect to the instance.

Correct Answer: ABC

How can you determine which databases are created in an instance?

1. A. use dbschema utility
2. B. inspect ONCONFIG file
3. C. List reserved pages with oncheck -pr
4. D. run SELECT name FROM sysmaster:sysdatabases

Correct Answer: D

Which utility would you use to print out the physical layout of the instance?

1. A. onstat
2. B. onmode
3. C. onspaces
4. D. dbschema

Correct Answer: D

Which two products can be used by client applications to connect to Informix instances? (Choose two.)

1. A. IBM Global Connect
2. B. IBM Informix Connect
3. C. IBM Informix JDBC Driver
4. D. IBM Informix Office Manager
5. E. IBM Informix Universal Driver Kit

Correct Answer: BC