image


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


Question #110


What is true about poll threads?


image

  1. poll threads always run on a CPU vp

    image

  2. poll threads always run on a NET vp

    image

  3. poll threads always run on an ADM vp

    image

  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?


image

  1. sysutils

    image

  2. sysstate

    image

  3. sysmaster

    image

  4. sysmonitor


Answer: C Question #112

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


image

  1. dbspace

    image

  2. flash space

    image

  3. smart rowspace

    image

  4. smart blobspace

    image

  5. encrypted space


Answer: AD Question #113

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


image

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

    image

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

    image

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

    image

  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?

image

  1. in a temporary dbspace

    image

  2. in the default dbspace that is defined in onconfig

    image

  3. in the dbspace where the current database was created

    image

  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?


image

  1. onspaces

    image

  2. onmonitor

    image

  3. oncheck -pe

    image

  4. SELECT * from SYSTABLES


Answer: C Question #116

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


image

  1. SMI tables store database structures.

    image

  2. Contains tasks used by the database scheduler

    image

  3. SMI tables are also known as System Catalog tables

    image

  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?


image

  1. SD secondary servers support automatic index repair

    image

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

    image

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

    image

  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?


image

  1. Flexible Grid

    image

  2. Enterprise Replication

    image

  3. High Availability Cluster

    image

  4. High Availability Data Replication


Answer: A Question #119

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


image

  1. column

    image

  2. instance

    image

  3. database

    image

  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?


image

  1. Offline

    image

  2. On-Line

    image

  3. Quiescent

    image

  4. Administrative


Answer: C


image

6$03/( 48(67,216


7KHVH TXHVWLRQV DUH IRU GHPR SXUSRVH RQO\ )XOO YHUVLRQ LV XS WR GDWH DQG FRQWDLQV DFWXDO TXHVWLRQV DQG DQVZHUV


.LOOH[DPV FRP LV DQ RQOLQH SODWIRUP WKDW RIIHUV D ZLGH UDQJH RI VHUYLFHV UHODWHG WR FHUWLILFDWLRQ H[DP SUHSDUDWLRQ 7KH SODWIRUP SURYLGHV DFWXDO TXHVWLRQV H[DP GXPSV DQG SUDFWLFH WHVWV WR KHOS LQGLYLGXDOV SUHSDUH IRU YDULRXV FHUWLILFDWLRQ H[DPV ZLWK FRQILGHQFH +HUH DUH VRPH NH\ IHDWXUHV DQG VHUYLFHV RIIHUHG E\ .LOOH[DPV FRP


$FWXDO ([DP 4XHVWLRQV .LOOH[DPV FRP SURYLGHV DFWXDO H[DP TXHVWLRQV WKDW DUH H[SHULHQFHG LQ WHVW FHQWHUV 7KHVH TXHVWLRQV DUH XSGDWHG UHJXODUO\ WR HQVXUH WKH\ DUH XS WR GDWH DQG UHOHYDQW WR WKH ODWHVW H[DP V\OODEXV %\ VWXG\LQJ WKHVH DFWXDO TXHVWLRQV FDQGLGDWHV FDQ IDPLOLDUL]H WKHPVHOYHV ZLWK WKH FRQWHQW DQG IRUPDW RI WKH UHDO H[DP


([DP 'XPSV .LOOH[DPV FRP RIIHUV H[DP GXPSV LQ 3') IRUPDW 7KHVH GXPSV FRQWDLQ D FRPSUHKHQVLYH FROOHFWLRQ RI TXHVWLRQV DQG DQVZHUV WKDW FRYHU WKH H[DP WRSLFV %\ XVLQJ WKHVH GXPSV FDQGLGDWHV FDQ HQKDQFH WKHLU NQRZOHGJH DQG LPSURYH WKHLU FKDQFHV RI VXFFHVV LQ WKH FHUWLILFDWLRQ H[DP


3UDFWLFH 7HVWV .LOOH[DPV FRP SURYLGHV SUDFWLFH WHVWV WKURXJK WKHLU GHVNWRS 9&( H[DP VLPXODWRU DQG RQOLQH WHVW HQJLQH 7KHVH SUDFWLFH WHVWV VLPXODWH WKH UHDO H[DP HQYLURQPHQW DQG KHOS FDQGLGDWHV DVVHVV WKHLU UHDGLQHVV IRU WKH DFWXDO H[DP 7KH SUDFWLFH WHVWV FRYHU D ZLGH UDQJH RI TXHVWLRQV DQG HQDEOH FDQGLGDWHV WR LGHQWLI\ WKHLU VWUHQJWKV DQG ZHDNQHVVHV


*XDUDQWHHG 6XFFHVV .LOOH[DPV FRP RIIHUV D VXFFHVV JXDUDQWHH ZLWK WKHLU H[DP GXPSV 7KH\ FODLP WKDW E\ XVLQJ WKHLU PDWHULDOV FDQGLGDWHV ZLOO SDVV WKHLU H[DPV RQ WKH ILUVW DWWHPSW RU WKH\ ZLOO UHIXQG WKH SXUFKDVH SULFH 7KLV JXDUDQWHH SURYLGHV DVVXUDQFH DQG FRQILGHQFH WR LQGLYLGXDOV SUHSDULQJ IRU FHUWLILFDWLRQ H[DPV


8SGDWHG &RQWHQW .LOOH[DPV FRP UHJXODUO\ XSGDWHV LWV TXHVWLRQ EDQN DQG H[DP GXPSV WR HQVXUH WKDW WKH\ DUH FXUUHQW DQG UHIOHFW WKH ODWHVW FKDQJHV LQ WKH H[DP V\OODEXV 7KLV KHOSV FDQGLGDWHV VWD\ XS WR GDWH ZLWK WKH H[DP FRQWHQW DQG LQFUHDVHV WKHLU FKDQFHV RI VXFFHVV


7HFKQLFDO 6XSSRUW .LOOH[DPV FRP SURYLGHV IUHH [ WHFKQLFDO VXSSRUW WR DVVLVW FDQGLGDWHV ZLWK DQ\ TXHULHV RU LVVXHV WKH\ PD\ HQFRXQWHU ZKLOH XVLQJ WKHLU VHUYLFHV 7KHLU FHUWLILHG H[SHUWV DUH DYDLODEOH WR SURYLGH JXLGDQFH DQG KHOS FDQGLGDWHV WKURXJKRXW WKHLU H[DP SUHSDUDWLRQ MRXUQH\


'PS .PSF FYBNT WJTJU IUUQT LJMMFYBNT DPN WFOEPST FYBN MJTU

.LOO \RXU H[DP DW )LUVW $WWHPSW *XDUDQWHHG