Renew C2090-558 Preparation Exams 2021

NEW QUESTION 1
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 2
Which of the following methods can be used to tranfer data in EXPRESS mode?

• A. dbload
• B. external tables
• C. onload/onunload
• D. dbexport/dbimport

Answer: B

NEW QUESTION 3
Which of the following is true about the remote query SELECT * FROM ABC@LMN:XYZ?

• A. SELECT from table ABC at database LMN on server XYZ
• B. SELECT from table ABC at server LMN on database XYZ
• C. SELECT from table LMN on database ABC on server XYZ
• D. SELECT from table XYZ on database ABC at server LMN

Answer: D

NEW QUESTION 4
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 5
Which two column definitions can store whole numbers from -(2^63-1) to (2^63-1)? (Choose two.)

• A. INT
• B. INT8
• C. BIGINT
• D. DOUBLE
• E. LARGEINT

Answer: BC

NEW QUESTION 6
What is the default isolation level on a database with unbuffered logging?

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

Answer: C

NEW QUESTION 7
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 8
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 9
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 10
What does the dbschema -ss option explicitly show besides lock mode, fragmentation strategy, and dbspace name?

• A. pagesize
• B. extent size
• C. creation date
• D. partition partnum

Answer: B

NEW QUESTION 11
Which of the following is required for a cold restore?

• A. A restore that includes the rootdbs
• B. A restore that includes temp dbspaces
• C. A restore that includes only non-critical dbspaces.
• D. A restore that includes multiple level to be restored.

Answer: A

NEW QUESTION 12
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 13
Why would you want to create a table with a lock mode row as opposed to a lock mode page?

• A. to reduce disk I/O
• B. to keep more information in memory for each locked row
• C. to increase concurrency among multiple users on the same table
• D. to reduce the number of locks when accessing rows out of the table

Answer: C

NEW QUESTION 14
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 15
Which two statements are true about the COMMIT WORK statement? (Choose two.)

• A. The keyword WORK is optional.
• B. A single COMMIT WORK can end several BEGIN WORK statements.
• C. The COMMIT WORK statement releases all row locks but not table locks.
• D. All of the successful modifications that the transaction makes are saved to disk when you issue a COMMIT WORK statement.
• E. A new transaction automatically starts after each COMMIT WORK or ROLLBACK WORK statement in a nonlogged database.

Answer: AD

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

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

Answer: BC

NEW QUESTION 17
Given the following: CREATE TABLE customer (customer_num INT, company CHAR(25)); Which of the following SQL statements will return an error?

• A. INSERT INTO customer VALUES (453);
• B. INSERT INTO customer VALUES (453, '"ABC Company");
• C. INSERT INTO customer (company) VALUES ("ABC Company");
• D. INSERT INTO customer (customer_num, company) VALUES (453, "ABC Company");

Answer: A

NEW QUESTION 18
You received an error, "Chunk is not empty", while trying to remove a chunk. How do you verify which objects still occupy space in the chunk?

• A. onspaces
• B. onmonitor
• C. oncheck -pe
• D. SELECT * from SYSTABLES

Answer: C

NEW QUESTION 19
Informix is currently in online mode. As a DataBase System Administrator (DBSA), you switch to administration mode with ADMIN_USER_MODE_WITH_DBSA = 0. Who can
access Informix databases?

• A. only Informix
• B. only a DBSA
• C. only Informix or a DBSA
• D. only root, Informix or a DBSA

Answer: C

NEW QUESTION 20
Given the following table definition: CREATE TABLE t1(col1 BOOLEAN); Which of the following statements will fail to insert a row?

• A. INSERT INTO t1 values ('t');
• B. INSERT INTO t1 values ('f');
• C. INSERT INTO t1 values (1);
• D. INSERT INTO t1 values (NULL);

Answer: C

NEW QUESTION 21
In which two places may a function be used in a SELECT statement? (Choose two.)

• A. in a subquery
• B. in a HAVING clause
• C. in a GROUP BY clause
• D. in the ORDER BY clause
• E. in the select (or projection) list

Answer: AE

NEW QUESTION 22
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 23
In which database does Informix store the information when a new task is created in OpenAdmin Tool's Task Scheduler?

• A. sysutils
• B. sysusers
• C. sysadmin
• D. sysmaster

Answer: C

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