IBM C2090-558 Guidance 2021

NEW QUESTION 1
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 2
Which database contains the system-monitoring interface (SMI) tables which provide information about the state of the database server?

• A. sysutils
• B. sysstate
• C. sysmaster
• D. sysmonitor

Answer: C

NEW QUESTION 3
Which two SQL commands can be used to invoke a stored procedure? (Choose two.)

• A. RUN function
• B. CALL function
• C. CALL procedure
• D. EXECUTE function
• E. EXECUTE procedure

Answer: DE

NEW QUESTION 4
Click the Exhibit button.

The tables shown in the exhibit have been created for a class enrollment system where a course can be assigned to many classes. The class table joins to the course table on the course_num columns. Which two of the following SQL statements are required to establish a referential integrity relationship between these tables? (Choose two.)

• A. ALTER TABLE class ADD CONSTRAINT (PRIMARY KEY (class_id));
• B. ALTER TABLE class ADD CONSTRAINT (PRIMARY KEY (course_num));
• C. ALTER TABLE course ADD CONSTRAINT (PRIMARY KEY (course_num));
• D. ALTER TABLE class ADD CONSTRAINT (FOREIGN KEY (course_num)REFERENCES course);
• E. ALTER TABLE course ADD CONSTRAINT (FOREIGN KEY (course_num) REFERENCES class);

Answer: CD

NEW QUESTION 5
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 6
Which command option should be used to resume an interrupted onbar restore?

• A. -RETRY
• B. -RESTART
• C. -REINTIIALZE
• D. -BEGIN_AGAIN

Answer: B

NEW QUESTION 7
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 8
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 9
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 10
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 11
When restoring data, which granularity of object may NOT be restored?

• A. a single table
• B. a single chunk
• C. a single dbspace
• D. an entire instance

Answer: B

NEW QUESTION 12
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 13
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 14
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 15
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 16
Business rules require that every time a row in table A is updated in your OLTP database, a row in table B must also be updated. How can you guarantee this rule will be maintained correctly and consistently when there are multiple applications and developers?

• A. Use a trigger.
• B. Create a foreign key.
• C. Use a nightly batch process.
• D. Define a task in the sysadmin database.

Answer: A

NEW QUESTION 17
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 18
User A creates a User Defined Routine (UDR). Which privilege must be granted to other users before they can run user A's UDR?

• A. DBA on the database
• B. EXECUTE on the procedure
• C. RESOURCE on the database
• D. SELECT on the tables used in the procedure

Answer: B

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