IBM C2090-558 Bundle 2021

NEW QUESTION 1
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

NEW QUESTION 2
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

NEW QUESTION 3
Click the Exhibit button.

An administrator created a table using the SQL statement shown in the exhibit to perform a load operation every day at 11:00 AM. What is the best way to optimize a backup strategy to recover the client table in case of a failure?

• A. a level-1 backup at 6:00 AM everyday
• B. a level-0 backup soon after the load operation
• C. a level-1 backup on Sunday and continuous log backup
• D. a level-2 backup at 6:00 AM every day and continuous log backup

Answer: B

NEW QUESTION 4
Which one of the following is most suitable for scheduling administrative functions that need to be performed periodically?

• A. Task
• B. Trigger
• C. Stored Procedure
• D. User Defined Routine

Answer: A

NEW QUESTION 5
Given the query shown below:

What will happen?

• A. All rows will be retrieved in which item_desc contains the characters 'pencil'.
• B. All rows will be retrieved in which item_desc does not contain the characters 'pencil'.
• C. All rows will be retrieved in which item_desc contains the letters 'p', 'e', 'n', 'c', 'i' and 'l' in any order.
• D. All rows will be retrieved in which item_desc contains the letters "P', 'E', 'N, C', I' and 'L' in any order.

Answer: A

NEW QUESTION 6
Which two tasks can be accomplished using the OpenAdmin Tool (OAT)? (Choose two.)

• A. Manage Virtual Processors (VP).
• B. Automate the update statistics process.
• C. Perform installation of an Informix server.
• D. Run the High Performance Loader (HPL) GUI tool.
• E. Remove an instance's orphaned shared memory segment.

Answer: AB

NEW QUESTION 7
What is the lowest level of granularity supported by Enterprise Replication?

• A. column
• B. instance
• C. database
• D. fragment

Answer: A

NEW QUESTION 8
A DBA wants to know which commands have been executed through the SQL Admin API. What is the correct action?

• A. Use the built-in tasks in the sysadmin database.
• B. Query the ph_run table in the sysadmin database.
• C. Query the ph_task table in the sysadmin database.
• D. Query the command_history table in the sysadmin database.

Answer: D

NEW QUESTION 9
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

NEW QUESTION 10
Which of the following utilities can be used for quick installation of pre-configured IBM Informix instances to many computers?

• A. Ontape utility
• B. Snapshot utility
• C. Archecker utility
• D. Deployment utility

Answer: D

NEW QUESTION 11
Which two operations are performed with the onspaces command? (Choose two.)

• A. Add space to the server.
• B. Compress server space.
• C. Encrypt the server space.
• D. Remove space from the server.
• E. Restrict access to the server space.

Answer: AD

NEW QUESTION 12
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

NEW QUESTION 13
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

NEW QUESTION 14
Which Informix data movement utilities listed below can be used to move database from a computer running Windows operating system to an Apple computer?

• A. ontape
• B. onunload and onload
• C. ifxsend and ifxreceive
• D. dbexport and dbimport

Answer: D

NEW QUESTION 15
Which document provides details on preparing an operating system to run Informix?

• A. Machine Notes
• B. System User's Guide
• C. Operating System Guide
• D. Informix Migration Guide

Answer: A

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

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

Answer: ABC

NEW QUESTION 17
In what way is Enterprise Replication (ER) replication different from High-Availability Cluster (HAC) replication?

• A. All data types are replicated.
• B. The data to be replicated is defined at an instance level of granularity.
• C. The data to be replicated can be defined at a column level of granularity.
• D. The data to be replicated can not include simple blobs stored in simple blobspaces.

Answer: C

NEW QUESTION 18
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

NEW QUESTION 19
Click the Exhibit button.

In the exhibit, which ALTER TABLE statement is used to add the foreign key constraint where customer_num column in the orders table is a foreign key that references the customer_num column in the customer table?

• A. ALTER TABLE customer ADD CONSTRAINT (FOREIGN KEY (order_num) REFERENCES order );
• B. ALTER TABLE orders ADD CONSTRAINT (FOREIGN KEY (order_num)REFERENCES customer );
• C. ALTER TABLE customer ADD CONSTRAINT (FOREIGN KEY (customer_num) REFERENCES order );
• D. ALTER TABLE orders ADD CONSTRAINT (FOREIGN KEY (customer_num) REFERENCES customer );

Answer: D

NEW QUESTION 20
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

NEW QUESTION 21
Which command can be executed against a view?

• A. DEFRAGMENT
• B. CREATE INDEX
• C. CREATE SYNONYM
• D. UPDATE STATISTICS

Answer: C

NEW QUESTION 22
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

NEW QUESTION 23
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

NEW QUESTION 24
Enterprise Replication (ER) requires which data object to exist in all tables participating in replication?

• A. a primary key
• B. a unique index
• C. a virtual column
• D. a unique constraint

Answer: A

NEW QUESTION 25
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

NEW QUESTION 26
......