Latest C2090-558 Practice Tests with Actual Questions

Get Complete pool of questions with Premium PDF and Test Engine

Exam Code : C2090-558
Exam Name : Informix 11.70 Fundamentals
Vendor Name : "IBM"






C2090-558 Dumps

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


killexams.com


IBM


C2090-558


Informix 11.70 Fundamentals


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


Question #110


What is true about poll threads?


  1. poll threads always run on a CPU vp

  2. poll threads always run on a NET vp

  3. poll threads always run on an ADM vp

  4. 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?


  1. sysutils

  2. sysstate

  3. sysmaster

  4. sysmonitor




Answer: C Question #112

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


  1. dbspace

  2. flash space

  3. smart rowspace

  4. smart blobspace

  5. encrypted space




Answer: AD Question #113

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


  1. SELECT from table ABC at database LMN on server XYZ

  2. SELECT from table ABC at server LMN on database XYZ

  3. SELECT from table LMN on database ABC on server XYZ

  4. 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?

  1. in a temporary dbspace

  2. in the default dbspace that is defined in onconfig

  3. in the dbspace where the current database was created

  4. 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?


  1. onspaces

  2. onmonitor

  3. oncheck -pe

  4. SELECT * from SYSTABLES




Answer: C Question #116

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


  1. SMI tables store database structures.

  2. Contains tasks used by the database scheduler

  3. SMI tables are also known as System Catalog tables

  4. 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?


  1. SD secondary servers support automatic index repair

  2. SD secondary servers use paging files to track pages between checkpoints

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

  4. 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?


  1. Flexible Grid

  2. Enterprise Replication

  3. High Availability Cluster

  4. High Availability Data Replication




Answer: A Question #119

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


  1. column

  2. instance

  3. database

  4. fragment




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?


  1. Offline

  2. On-Line

  3. Quiescent

  4. Administrative




Answer: C