Realistic C2090-558 Prep 2021

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

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

NEW QUESTION 3
Which Informix utility listed below will allow an administrator to run ad hoc SQL against the instance?

• A. onsql
• B. onadmin
• C. dbaccess
• D. dbschema

Answer: C

NEW QUESTION 4
You want to use sqlhosts file /newlocation/newsqlhosts. Which of the following is true?

• A. sqlhosts file must be called sqlhosts
• B. set INFORMIXSQLHOSTS variable to /newlocation/sqlhosts
• C. set INFORMIXSQLHOSTS variable to /newlocation/newsqlhosts
• D. sqlhosts file must be defined under $INFORMIXDIR/etc/ directory

Answer: C

NEW QUESTION 5
Which two statements will delete all rows from table_name? (Choose two.)

• A. DROP FROM table_name ;
• B. DELETE FROM table_name ;
• C. DELETE * FROM table_name ;
• D. TRUNCATE TABLE table_name ;
• E. DELETE ALL FROM table_name ;

Answer: BD

NEW QUESTION 6
When encountering an assertion failure or performance issue, which Informix utility, when run by the DBA, collects and bundles the basic diagnostic data?

• A. ontape
• B. onmode
• C. ifxcollect
• D. onparams

Answer: C

NEW QUESTION 7
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 8
Which search condition is allowed in a check constraint?

• A. It can contain aggregates.
• B. It can contain subqueries.
• C. It can contain host variables.
• D. It can contain a range of values.

Answer: D

NEW QUESTION 9
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 10
There are two open sessions (session A and session B) that are updating the same tables. Session B is trying to read all rows in the table and is continuously receiving the error "-143 ISAM error: deadlock detected". Which action in session B would allow it to read all of the rows?

• A. commit work;
• B. set isolation to dirty read;
• C. set lock mode to not wait;
• D. set lock mode to nolocking;

Answer: B

NEW QUESTION 11
Which authentication functionality allows you to implement different authentication mechanisms for different applications?

• A. Single Sign-On
• B. Secure Socket Layer
• C. Pluggable Authentication Modules
• D. Lightweight Directory Access Protocol

Answer: C

NEW QUESTION 12
Which two statements will update all rows in the customer table? (Choose two.)

• A. update customer set fname = "xyz";
• B. modify customer set fname = "xyz";
• C. modify customerset fname = "xyz" where 1 = 1;
• D. update customerset fname = "xyz" where 1 = 1;
• E. update customerset fname = "xyz" for all;

Answer: AD

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

NEW QUESTION 14
Which document describes new Informix features?

• A. oncofig.std file
• B. Release Notes
• C. Machine Notes
• D. Quick Start Guide

Answer: B

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

NEW QUESTION 16
Which of the following statements is true about referential integrity?

• A. Primary and foreign key values must be integers.
• B. You must explicitly define constraint names for primary and foreign key columns.
• C. A row in a table cannot be deleted if it contains a foreign key value that exists as aprimary key value in the referenced table.
• D. A row in a table cannot be deleted if it contains a primary key value that is referenced by a foreign key value in another table.

Answer: D

NEW QUESTION 17
Which two storage objects exist in Informix? (Choose two.)

• A. dbspace
• B. flash space
• C. smart rowspace
• D. smart blobspace
• E. encrypted space

Answer: AD

NEW QUESTION 18
Which of the following statement is correct about Shared Disk (SD) secondary servers?

• A. SD secondary servers support automatic index repair
• B. SD secondary servers use paging files to track pages between checkpoints
• C. SD secondary servers require an HDR secondary server to be present in order to function
• D. SD secondary servers can become a High-Availability Data Replication (HDR) secondary server

Answer: B

NEW QUESTION 19
Which of these commands will create a table containing a column that will be automatically populated with a numeric value starting from an initial value of 2301 and incremented as
rows are inserted?

• A. CREATE TABLE customer (cust_num SERIAL(2301), ?;
• B. CREATE TABLE customer (cust_num SERIAL INIT 2301,?;
• C. CREATE TABLE customer (cust_num INT SET SERIAL 2301,?;
• D. CREATE TABLE customer (cust_num SERIAL,? SET SERIAL 2301;

Answer: A

NEW QUESTION 20
Which two of the following are required for creating a dbspace? (Choose two.)

• A. a mirror chunk
• B. two or more chunks
• C. a cooked file or raw device
• D. a file owned by root or administrator
• E. dbspace name containing only letters, digits, underscores, or $ characters.

Answer: CE

NEW QUESTION 21
......