C2090-558 Dumps

C2090-558 Braindumps C2090-558 Real Questions C2090-558 Practice Test C2090-558 Actual Questions

IBM

C2090-558

Informix 11.70 Fundamentals

https://killexams.com/pass4sure/exam-detail/C2090-558

What is true about poll threads?

poll threads always run on a CPU vp

poll threads always run on a NET vp

poll threads always run on an ADM vp

poll threads can be configured on a CPU or NET vp

Answer: D Question #111

Which database contains the system-monitoring interface (SMI) tables which provide information about the state of the database server?

Answer: C Question #112

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

smart blobspace

encrypted space

Answer: AD Question #113

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

SELECT from table ABC at database LMN on server XYZ

SELECT from table ABC at server LMN on database XYZ

SELECT from table LMN on database ABC on server XYZ

SELECT from table XYZ on database ABC at server LMN

Answer: D Question #114

You create a table with the statement shown below: CREATE TABLE foo(col INTEGER) In which dbspace will the table reside?

in a temporary dbspace

in the default dbspace that is defined in onconfig

in the dbspace where the current database was created

in the dbspace specified by the IFX_DBSPACE environment variable

Answer: C Question #115

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?

SELECT * from SYSTABLES

Answer: C Question #116

Which of the following statement is true of System Monitoring Interface (SMI) tables?

SMI tables store database structures.

Contains tasks used by the database scheduler

SMI tables are also known as System Catalog tables

Contains tables that the database server maintains automatically

Answer: D Question #117

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

SD secondary servers support automatic index repair

SD secondary servers use paging files to track pages between checkpoints

SD secondary servers require an HDR secondary server to be present in order to function

SD secondary servers can become a High-Availability Data Replication (HDR) secondary server

Answer: B Question #118

Which technology can be used to execute Data Definition Language (DDL) command across multiple instances?

Enterprise Replication

High Availability Cluster

High Availability Data Replication

Answer: A Question #119

What is the lowest level of granularity supported by Enterprise Replication?

Answer: A Question #120

Which of the following Informix server modes disable execution of SQL statements for all users while allowing administrative users to perform maintenance tasks?

Answer: C