Want to know Pass4sure C2090-558 Exam practice test features? Want to lear more about IBM Informix 11.70 Fundamentals (C2090-558) certification experience? Study Breathing IBM C2090-558 answers to Up to the immediate present C2090-558 questions at Pass4sure. Gat a success with an absolute guarantee to pass IBM C2090-558 (Informix 11.70 Fundamentals (C2090-558)) test on your first attempt.
Online IBM C2090-558 free dumps demo Below:
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
......
Thanks for reading the newest C2090-558 exam dumps! We recommend you to try the PREMIUM DumpSolutions C2090-558 dumps in VCE and PDF here: https://www.dumpsolutions.com/C2090-558-dumps/ (120 Q&As Dumps)