Vivid C2090-558 Study Guides 2021

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

NEW QUESTION 3
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 4
Which one of the following is most suitable for scheduling the periodic collection of data
about an instance?

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

Answer: A

NEW QUESTION 5
Which phase of Fast Recovery rolls forward (restores) all transactions since the last checkpoint and rolls back any uncommitted transactions?

• A. Logical Recovery
• B. Physical Recovery
• C. Dbspace Recovery
• D. Transactional Recovery

Answer: A

NEW QUESTION 6
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 7
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 8
Which isolation level is appropriate if you do not want your query to place any locks?

• A. Dirty Read
• B. Cursor Stability
• C. Committed Read
• D. Repeatable Read

Answer: A

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

NEW QUESTION 11
When you execute an INSERT statement, the database server will insert a NULL value into any column that meets which two conditions? (Choose two.)

• A. Columns that are used in indexes.
• B. Columns that are used in constraints.
• C. You provide no value for a specific column.
• D. Where a zero is specified in the VALUES clause of a serial column.
• E. Where you specify the NULL keyword in the VALUES clause for a specific column.

Answer: CE

NEW QUESTION 12
What Informix data type is suitable for storing video clips up to a size of 4 TB?

• A. BLOB
• B. BYTE
• C. CLOB
• D. COLLECTION

Answer: A

NEW QUESTION 13
Which table type is always nonlogging?

• A. RAW
• B. TEMP
• C. STATIC
• D. STANDARD

Answer: A

NEW QUESTION 14
What are two system level databases? (Choose two.)

• A. sysperf
• B. sysadmin
• C. sysmaster
• D. sysmonitor
• E. sysscheduler

Answer: BC

NEW QUESTION 15
Which two installation modes are available for Informix? (Choose two.)

• A. Full
• B. Typical
• C. Custom
• D. Compact
• E. Complete

Answer: BC

NEW QUESTION 16
What is the only isolation level available on an unlogged database?

• A. Dirty Read
• B. Cursor Stability
• C. Committed Read
• D. Repeatable Read

Answer: A

NEW QUESTION 17
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 18
What is true about poll threads?

• A. poll threads always run on a CPU vp
• B. poll threads always run on a NET vp
• C. poll threads always run on an ADM vp
• D. poll threads can be configured on a CPU or NET vp

Answer: D

NEW QUESTION 19
Click the Exhibit button.

In the exhibit, which statement is true regarding the update statement of Client 2 if both of the clients are connected to the same logged database?

• A. Client 2 will update col2 of the rows having col1=20.
• B. Client 2 will return successfully without updating any rows.
• C. Client 2 will keep waiting for client 1 to finish its transaction.
• D. Client 2 will get an error that the "record is locked" or the "table is locked".

Answer: D

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